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 vote170 views1 answer
Asp.net c# set session timeout
C#
0 vote161 views1 answer
C# mailmessage set sender name
C#
1 vote174 views1 answer
Check if panel has controler c#
C#
0 vote179 views1 answer
Listbox1.remove item c#
C#
-1 vote174 views1 answer
How to make a .exe file in c# visual studio
C#
0 vote202 views1 answer
C# Color Convert
C#
0 vote180 views1 answer
C# print multiplication table
C#
7 votes185 views1 answer
How to convert string to bool c#
C#
0 vote175 views1 answer
C# tell if list object is empty
C#
6 votes200 views1 answer
Unity call function on animation onstateexit
C#