Loading

Conversion from type 'DBNull' to type 'String' is not valid

ToBe

Dear All,

I'm getting this error when reach this lines of my code
Conversion from type 'DBNull' to type 'String' is not valid

this is my code :

If DS.Tables(0).Rows.Count <> 0 Then
            blnD = DS.Tables(0).Rows(0)("ItemExist")
            FORM1_ID = DS.Tables(0).Rows(0)("FORMID")
           Prev_FORM_ID = DS.Tables(0).Rows(0)("PREVFORMID") <--- in this line the debuger will stop and give me the error :(

           lblDONE.Text = "Successfully Saved"

what to do ??

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
Try changing this line:

Prev_FORM_ID = DS.Tables(0).Rows(0)("PREVFORMID")

to this:

If Not DS.Tables(0).Rows(0).IsNull("PREVFORMID") Then

Prev_FORM_ID = DS.Tables(0).Rows(0)("PREVFORMID")

End If
0
ToBe12y ago
thank you so much guys I tried it's working now
0
Jignesh Trivedi12y ago
hi,
try...
if (! DBNull.Value.Equals(DS.Tables(0).Rows(0)("PREVFORMID")))
      Prev_FORM_ID = DS.Tables(0).Rows(0)("PREVFORMID")
   else
      Prev_FORM_ID = String.Empty;
hope this will help you.
0