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 vote261 views1 answer
Convert relative path to physical path c#
C#
0 vote275 views1 answer
C# enum variable set to nonthing
C#
0 vote303 views1 answer
C# get enum value by DescriptionAttribute
C#
2 votes273 views1 answer
C# program that uses array, yield keyword
C#
1 vote279 views1 answer
Unity 3d camera rotate up and down
C#
26 votes307 views4 answers
Unity print
C#Unity
-1 vote272 views1 answer
Instantiate date time variable C#
C#
0 vote280 views1 answer
C# itext 7 PdfDocument from byte array
C#
2 votes273 views1 answer
Unity deactive code from code
C#
2 votes243 views1 answer
How to create a new folder with c#
C#