.net - Check if Column is empty

Question

I am looking on how to check the column data of a specific row. I found this:

For Each row In tablePiglet.Rows ' - data table
        If Not DBNull.Value.Equals(row("CurrentLocation")) Then
            MessageBox.Show("Not Empty")
        Else
            MessageBox.Show("Empty")
        End If
    Next

I tried to run the app, and the code does not execute. I added a breakpoint in For Each but it just ended. Why is that? There had been yet a data on CurrentLocation field, so it should display empty.

What I want is to check whether that row's CurrentLocation is empty or not.
Something like : SELECT CurrentLocation FROM tableFoo WHERE id=1 then check if its empty or not.
Is the code above the right thing to do? Or are there other better ways?

Answer 1

try this:

    For Each _dtrow as DataRow In tablePiglet.Rows ' - data table
        If _dtrow.Item("CurrentLocation").toString IsNot Nothing Or
           _dtrow.Item("CurrentLocation").toString <> vbNullString Then

              MessageBox.Show("Not Empty")
        Else
              MessageBox.Show("Empty")

        End If
    Next