[RESOLVED] DBNull to type String is not valid. From a datagrid

[ConfusedAgain]

I am trying to populate a textbox.text with a value with a record from a datagrid.
I can get my value from the datagrid by the following
Dim eRow As Integer



eRow = datagrid.CurrentRow.Index


txtSelecteditem.Text = datagrid.Item(0, eRow).Value

This all works fin when there is a value in the cell it is picking up. However, I hit a problem when this filed is blank.

The error I get is:
Conversion from type 'DBNull' to type 'String' is not valid.


How can I get the textbox to populate with null if the field is null.

[aashish_9601]

Before assigning it to the textbox you can check whether it is null or not by using this

If TypeOf datagrid.Item(0, eRow).Value Is DBNull Then

[ConfusedAgain]

Excellant - works perfectly

[Zeth643]

Hi.

The other way you could do it, is to use the .ToString method.

txtSelecteditem.Text = datagrid.Item(0, eRow).Value.ToString

That way, any value that is DBNull (blank) will be filled as it is on the textbox.

[ConfusedAgain]

Works great too.
I thought I had tried that earlier but obviously not.

Many thanks