Reading NULL Value from SQL that is a BinaryType in c# from a Datarow [duplicate]

Question

I'm trying to read the null value from my SQL.

The column presentationDocBinData is Nullable and it is a NULL.

So i tried reading it this way,

presentation.presentationDocBinData = (Byte[])dr["presentationDocBinData"];

But according to it, they're unable to read the null value that it receives. It says

Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.

So is there anyway to give it a default value or leave it blank if it is possible? it works fine with a value in it though.

st mnmn · Accepted Answer · 2014-06-22 09:47:55Z

0

you have to ask if it is DBNull

presentation.presentationDocBinData =dr["presentationDocBinData"]==DBNull.Value?null:(Byte[])dr["presentationDocBinData"];

answered Jun 22, 2014 at 9:47

st mnmn

3,6753 gold badges28 silver badges32 bronze badges

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

1 Answer 1