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 vote388 views1 answer
Struct constructor c#
C#
0 vote407 views1 answer
C# check control type
C#
4 votes343 views7 answers
Int
C#
15 votes336 views2 answers
Format double to 2 decimal places in c#
C#
1 vote326 views2 answers
2d look at unity
C#
6 votes315 views1 answer
Net core 5.0 create model from database
C#
0 vote324 views1 answer
Antlr c# errors
C#
0 vote361 views1 answer
Bitter foods examplews
C#
0 vote334 views1 answer
C# tolower all in a array
C#
-1 vote323 views1 answer
How to backgrund c# red
C#