How to check if Datarow value is null

Question

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{}

row["ColumnName"] != DBNull.Value, also you can try things like this by yourself. One way is to use debuger ! — mybirthname, Dec 10 '14 at 10:05

Felipe Oriani · Accepted Answer · 2021-10-13T11:43:43.300

83

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.

edited Oct 13 '21 at 11:43

answered Dec 10 '14 at 10:02

Felipe Oriani

37,948
19
131
194

returned type `string` and so much smaller – AleksP Dec 10 '14 at 10:04
Checking if the value is the right way to do this. :) – Felipe Oriani Dec 10 '14 at 10:12

score 22 · Answer 2 · answered Nov 02 '17 at 17:02

22

We have created an extension class that helps in these kinds of situations.

public static class DataRowExtensions
  {
    public static T FieldOrDefault<T>(this DataRow row, string columnName)
    {
      return row.IsNull(columnName) ? default(T) : row.Field<T>(columnName);
    }
  }

You can use is as follows:

int id = dataRow.FieldOrDefault<int>("Id");

answered Nov 02 '17 at 17:02

Ajit Goel

4,180
7
59
107

How would you put this on the outside of the foreach? – Demodave Mar 28 '19 at 21:52

How to check if Datarow value is null

2 Answers2

Linked

Related