how to check sqldatareader is null in c# code example

Example 1: C# datareadeer return null

// ****** Use MySqlDataReader instead of SqlReader if you are using MySQL *******

//You need to check for IsDBNull:
//That's your only reliable way to detect and handle this situation.
//I wrapped those things into extension methods and tend to return a default value 
//if the column is indeed null:

public static string SafeGetString(this SqlDataReader reader, int colIndex)
{
   if(!reader.IsDBNull(colIndex))
       return reader.GetString(colIndex);
   return string.Empty;
}

//Now you can call it like this:

employee.FirstName = SqlReader.SafeGetString(indexFirstName);

// and you'll never have to worry about an exception or a null value again.

Example 2: can sqldatareader be null

if (myReader.HasRows) //The key Word is **.HasRows**
{
    ltlAdditional.Text = "Contains data";
}
else
{   
    ltlAdditional.Text = "Is null Or Empty";
}

Tags:

Sql Example