Converting to Byte Array after reading a BLOB from SQL in C#

Question

I need to read a BLOB and store it in a byte[], before going forward with Deserializing;

Consider:

 //Reading the Database with DataAdapterInstance.Fill(DataSet);
     DataTable dt = DataSet.Tables[0];
    foreach (DataRow row in dt.Rows)
    {
    byte[] BinDate = Byte.Parse(row["Date"].ToString()); // convert successfully to byte[]

    }

I need help in this C# statement, as I am not able to convert an object type into a byte[]. Note, "Date" field in the table is a blob and not of type Date;

Help appreciated; Soham

You may take a look at the answer I gave to a similar question: stackoverflow.com/questions/625029/… — Darin Dimitrov
– Darin Dimitrov, Commented Apr 17, 2010 at 10:40

Guffa · Accepted Answer · 2010-04-17 10:41:29Z

18

Just cast the value to a byte array:

byte[] binDate = (byte[])row["Date"];

A blob in the database maps to a byte array in .NET, so the database driver have already done that conversion for you.

answered Apr 17, 2010 at 10:41

Guffa

703k111 gold badges760 silver badges1k bronze badges

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

Comments

Patrick D'Souza · Accepted Answer · 2013-05-18 17:18:02Z

2

byte[] binDate = (byte[])row["Date"];

edited May 18, 2013 at 17:18

Patrick D'Souza

3,5592 gold badges25 silver badges40 bronze badges

answered Apr 17, 2010 at 11:03

Sandeep Sachan

611 bronze badge

Comments

Marc Gravell · Accepted Answer · 2010-04-17 10:40:32Z

0

If "Date" is a blob, it should already come out as a byte[] - not sure why you are calling ToString(), but Byte.Parse will only parse a single byte.

answered Apr 17, 2010 at 10:40

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Collectives™ on Stack Overflow

Converting to Byte Array after reading a BLOB from SQL in C#

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related