If data is NULl/ not there L: Conversion from type 'DBNull' to type 'String' is not valid.

Question

User810354248 posted

IN my asp.net+vb+sql web in a query i get this error

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

if the data in that table is null then the above error comes

presl.Text = dt9.Tables("LEAVE").Rows(0).Item(0)

Answer 1

User475983607 posted

if the data in that table is null then the above error comes

Makes sense.  Simply, check if the value is DbNull before trying to assign the value to presl.Text. 

https://stackoverflow.com/questions/222834/handling-dbnull-data-in-vb-net

Answer 2

User288213138 posted

Hi Baiju EP,

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

 If you want to assign the value to presl.Text, Before that you need to check whether the table has the null value with it or not.

If Not IsDBNull(dt9.Tables("LEAVE").Rows(0).Item(0)) Then
    presl.Text = dt9.Tables("LEAVE").Rows(0).Item(0)
End If

But if you want to assign the null value to presl.Text, you can try to convernt cell value to string.

presl.Text = dt9.Tables("LEAVE").Rows(0).Item(0).ToString()

Best regards,

Sam

Answer 3

User810354248 posted

Thnaks