looking for blank fields

[smithbr]

I have a datagrid i am trying to update and need to know a way I can get it to only update those fields that have nothing in tehm...I have it written now as
dr.Item("Paid&quot = ""
but this is not working....how else can I write this so it works?

 

[PankajBanga]

use IsNull method.

 

[RiverGuy]

This might shed some light. In my table, the column with the index of 2 is the column in which I can have null values. I'm testing against that. Use the IsDBNull function.

Private Sub DataGrid1_CurrentCellChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGrid1.CurrentCellChanged
        Dim r As DataRow
        r = DataSet11.Tables(0).Rows(DataGrid1.CurrentCell.RowNumber)
        If IsDBNull(r(2)) Then
            MsgBox(r(1) & " is Null")
        Else
            MsgBox(r(1) & " is not Null")
        End If
    End Sub

 

[RiverGuy]

I believe there is no more IsNull function, must use IsDBNull.

 

[PankajBanga]

Well there is DataRow.IsNull method which gets a value indicating whether the specified column contains a null value.

see MSDN for more details....

 

[RiverGuy]

Cool, I was referreing to the generic IsNull function available in VB 6. But the DataRow's IsNull method will work too.

 

[smithbr]

Thank you guys....I figured it out
I used the system.dbnull
the new code looks like this
dr.Item("Paid&quot IS System.dbnull

Thanks again for the help