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.

Source: stackoverflow.com

Similar codes

2 votes273 views2 answers
Unity animator check if animation is playing
C#
33 votes314 views5 answers
Unity get child
C#
0 vote245 views1 answer
Copy-the-entire-contents-of-a-directory-in-c-sharp
C#
0 vote275 views1 answer
C# How to display text in console
C#
0 vote285 views1 answer
C# program that print charater from A to Z and it's corresponding number
C#
0 vote267 views1 answer
C# #region #endregion
C#
0 vote287 views1 answer
Grab reference from method parameter c#
C#
1 vote298 views1 answer
How to get value from object in c#
C#
0 vote280 views1 answer
C# scrape html document
C#
0 vote282 views1 answer
Findobject getcomponent
C#