Retireve a query as a byte array

Question

Im trying to retrieve a query as a byte array. Im stuck @ the code though.

byte[] temp = QueryFile("SELECT modelFile FROM items WHERE modelName='F_Pants1'");
    public byte[] QueryFile(string queue)
            {
                MySqlCommand command = MySqlCon.CreateCommand();
                MySqlDataReader Reader;
                command.CommandText = queue;
                MySqlCon.Open();
                Reader = command.ExecuteReader();
                byte[] thisrow = new byte[1000];
                while (Reader.Read())
                {
                    for (int i = 0; i < Reader.FieldCount; i++)
                        thisrow[0] = Convert.ToByte(Reader.GetValue(i).ToString());


                }
                thisrow = thisrow.Remove(thisrow.Length - 1, 1);
                MySqlCon.Close();

                return thisrow;

            }

If anyone has an answer, i would greatly appreciate it.

functions that accept completed sql queries as strings will lead to sql injection security issues. — Joel Coehoorn
– Joel Coehoorn, Commented Nov 29, 2011 at 4:22
SQL Injection if the function will get an un-checked strings. — Moshe L
– Moshe L, Commented Nov 29, 2011 at 7:42

competent_tech · Accepted Answer · 2011-11-29 04:18:38Z

4

You're making it a bit too complicated. Try this instead:

       try {
         Reader = command.ExecuteReader();
         if (Reader.Read())
          {
              return Reader.GetValue(0) as Byte[];
          }
        } finally {
           MySqlCon.Close();
        }

answered Nov 29, 2011 at 4:18

competent_tech

45.1k12 gold badges96 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Joel Coehoorn Over a year ago

This is also too complicated - he can just use .ExecuteScalar()

David W Over a year ago

ill change the function later but it returns null when i query

Collectives™ on Stack Overflow

Retireve a query as a byte array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related