>>>I'm not going to dig in that code
>>>
>>>(1) Is the field binary in the database ? and how is it stored
>>>
>>>(2) If yes, you have to convert it to a byte[] array and maybe convert the \x?? into one byte at a time
>>
>>I have another quick question. How should I access that column?
>>
>>Say, I have samples of
>>
>>table.Rows[0].Field<decimal>("fieldName")
>>
>>But what should it be for varbinary(max) column?
>
table.Rows[0].Field<byte[]>("fieldName")
Thanks, Rob, but this didn't work in the immediate window. The only thing I had access to was table.Rows[0].ItemArray
If it's not broken, fix it until it is.
My Blog