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

0 vote239 views1 answer
Hacker typer.com
C#
3 votes272 views5 answers
Bitmap to byte array c#
C#
33 votes258 views5 answers
String to datetime c#
C#
2 votes294 views1 answer
Dropdown text mesh pro unity
C#Unity
1 vote233 views1 answer
C# string remove special characters
C#
7 votes269 views2 answers
Insert variables into string c#
C#
4 votes250 views1 answer
Isprime c#
C#
2 votes251 views1 answer
C# separate string by comma
C#
15 votes271 views3 answers
C# get today's date
C#
1 vote260 views1 answer
C# error CS0515
C#