recognizing NULL field in IF statement

[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

 

[rowe_newsgroups]

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

IsDbNull(...)

Thanks,

Seth Rowe

 

[Herfried K. Wagner [MVP]]

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?

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