recognizing NULL field in IF statement

  • Thread starter Thread starter Etayki
  • Start date Start date
E

Etayki

Hello,

I am trying to create an IF statement that will recognize whether or
not a field in the database table is set to some value or if is NULL.

Dim myCommand As New System.Data.SqlClient.SqlCommand("SELECT
* FROM Keyword", conn)
Dim myReader As System.Data.SqlClient.SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
While myReader.Read()
If Not myReader("coil_search") Then
...
...
End If
End While
myReader.Close()

The "If Not myReader("coil_search") Then" statement does not seem to
recognize a NULL field.

How can I write a statement that will recognize a NULL field?

Thanks,

Etay
 
Hello,

I am trying to create an IF statement that will recognize whether or
not a field in the database table is set to some value or if is NULL.

Dim myCommand As New System.Data.SqlClient.SqlCommand("SELECT
* FROM Keyword", conn)
Dim myReader As System.Data.SqlClient.SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
While myReader.Read()
If Not myReader("coil_search") Then
...
...
End If
End While
myReader.Close()

The "If Not myReader("coil_search") Then" statement does not seem to
recognize a NULL field.

How can I write a statement that will recognize a NULL field?

Thanks,

Etay
Click to expand...

IsDbNull(...)

Thanks,

Seth Rowe
 
Etayki said:
I am trying to create an IF statement that will recognize whether or
not a field in the database table is set to some value or if is NULL.

Dim myCommand As New System.Data.SqlClient.SqlCommand("SELECT
* FROM Keyword", conn)
Dim myReader As System.Data.SqlClient.SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
While myReader.Read()
If Not myReader("coil_search") Then
...
...
End If
End While
myReader.Close()

The "If Not myReader("coil_search") Then" statement does not seem to
recognize a NULL field.

How can I write a statement that will recognize a NULL field?
Click to expand...

'If ... Is DBNull.Value Then...'. Take a look at the 'IsDBNull' function
too.
 
Back
Top