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 vote136 views1 answer
Cs string to enum
C#
0 vote214 views1 answer
Chaine de connexion sql server c#
C#
0 vote109 views1 answer
Visibility bound to radio button wpf
C#
1 vote134 views1 answer
Add text to combobox c#
C#
0 vote219 views1 answer
Unity c# hooke's law suspension
C#Unity
0 vote140 views1 answer
C# check if object can be cast to type
C#
2 votes152 views1 answer
How to do a web request unity
C#
0 vote149 views1 answer
Solr Binary Field to byte[]
C#
0 vote184 views1 answer
C# get random between 0 and 1
C#
0 vote192 views1 answer
How to use the mouse scroll wheel to move the camera in unity
C#Unity