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 vote264 views1 answer
C# generate insert statement from object
C#
0 vote266 views1 answer
Get directory name of path c#
C#
1 vote265 views1 answer
Attribute [livewire] does not exist.
C#
0 vote323 views1 answer
Remove lines from textfile
C#
0 vote278 views1 answer
Unity get rid of mouse
C#Unity
0 vote274 views2 answers
== vs equals c#
C#
19 votes253 views2 answers
Unity set text value
C#
0 vote320 views1 answer
How to chceck for a tag in a trigger enter 2d unity
C#Unity
0 vote258 views1 answer
Asp.net unregister client script
C#
0 vote290 views1 answer
C# standard microphone decibels
C#