How to spot an empty access field with data reader C#

Question

I'm trying to create a method that returns a string from my db that fulfills my conditions.

The first condition is working. But, the second condition is that part of entry in access is empty, at least one field.

This is my code:

OleDbCommand datacommand = new OleDbCommand();
datacommand.Connection = dataConnection;
datacommand.CommandText = "SELECT   numNumber, numLocation " +
                          "FROM     tblNumbers  " +
                          "ORDER BY numID ";
OleDbDataReader dataReader = datacommand.ExecuteReader();
while (dataReader.Read())
{
    if (MatchServiceLetters(dataReader.GetString(0))) // && dataReader.GetInt32(1) == null?/)
}
return dataReader.GetString(0);

If the int field is empty, the comparison to null isn't working. so how can I know if it is empty?

Answer 1

From MSDN:

No conversions are performed; therefore, the data retrieved must already be a 32-bit signed integer. Call IsDBNull to look for null values before calling this method.

So you would use:

if(!dataReader.IsDBNull(1))
{
    return dataReader.GetInt32(1);
}
else
{
    return 0; // or better yet, make your method return Nullable<int>
}