dbnull

  • Thread starter Thread starter segue
  • Start date Start date
S

segue

How would I run an if statement for dbnull?

Much thanks.

Dim reader As OdbcDataReader = select_command.ExecuteReader()
Do While (reader.Read())

If reader.Item("somedbfield") <> DBNull.Value Then
 
Hi there,

Yep, as well as:
If Not TypeOf reader("somedbfield") Is DbNull then
If Not reader.IsDbNull(reader.GetOrdinal("somedbfield")) then
 
Back
Top