Search code examples
c#datatablenulldatarow

How to check if Datarow value is null


Tell me please is this is correct way to check NULL in DataRow if need to return a string

 Convert.ToString(row["Int64_id"] ?? "")

Or should be like check with DBNull.Value.

Need to so much more smaller than

if(row["Int64_id"] != DBNull.Value){...}else if{}

Solution

  • Check if the data column is not null with DataRow.IsNull(string columnName)

    if (!row.IsNull("Int64_id"))
    {
      // here you can use it safety
       long someValue = (long)row["Int64_id"];
    }
    

    There are overloads for it using the index of the column or if you have the instance of the DataColumn. If you are sure about the index, use the index version which tends to be faster than the other options.