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

1 vote325 views1 answer
C# zeitverzögerung
C#
0 vote313 views1 answer
Find qual values in a dictionary c#
C#
1 vote316 views1 answer
C# how to refresh your binding source
C#
0 vote307 views1 answer
C# remove all punctuation from string
C#
0 vote343 views1 answer
Asp.net get most recent file in directory
C#
5 votes310 views5 answers
C# merge two lists
C#
0 vote334 views2 answers
DWGExportOptions
C#
0 vote348 views1 answer
Instantiate object in circle
C#
1 vote329 views1 answer
Warum wächst Weizen besonders gut in den Steppen?
C#
0 vote301 views1 answer
CS0234 compile error c# unity fix scene managment
C#