Thursday, August 20, 2009

Check for DBNull value

SqlDataReader myreader = command.ExecuteReader();
if( myreader["column_name"] != DBNull.Value)
{
//code goes here
}
or

SqlDataReader myreader = command.ExecuteReader();
if(myreader["column_name"] != Convert.DBNull)
{
//code goes here
}

No comments: