Binoy asked this 4 years ago

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

I am getting this error on my program

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

The error occurs at the below line

strResult= dtGrid.Rows(i).Item("RESULT")

dtGrid is a data table and what i doing here is to get the "RESULT" column and assign it to string variable.

Please help..

Best Answer by williamhold 2 years ago

This message is getting because the ASP.NET program unable to handle DBNull value. In these cases you can determine whether a value retrieved from a database field is a DBNull value by passing the value of that field to the DBNull.Value.Equals method.


If IsDBNull(ds.Tables(0).Rows(i).Item(0)) Then

  Label1.Text = "DBNULL exist in the field "

End If

Vikas 4 years ago

convert the data using toString() function and then assign to string variable, So your code should be changed to

strResult= dtGrid.Rows(i).Item("RESULT").toString()