Check if DataRow exists by column name in c#?

c# null datarow
waqasahmed picture waqasahmed · Apr 1, 2010 · Viewed 123.3k times · Source

I want to do something like this:

   private User PopulateUsersList(DataRow row)
        {
            Users user = new Users();
            user.Id = int.Parse(row["US_ID"].ToString());
            if (row["US_OTHERFRIEND"] != null)
            {
                user.OtherFriend = row["US_OTHERFRIEND"].ToString();
            }
            return user;
        }

However, I get an error saying US_OTHERFRIEND does not belong to the table. I want to simply check if it is not null, then set the value.

Isn't there a way to do this?

Answer

Kibbee picture Kibbee · Apr 1, 2010

You should try 

if (row.Table.Columns.Contains("US_OTHERFRIEND"))

I don't believe that row has a columns property itself.

Related questions

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(…

Read More
C# DataTable ItemArray returns '{}' - how can I test for null value?

I have a DataTable resultSet; - I'm trying to check fields for null, but get an '{}' (empty-set ?) object back. Searches involving "{}" aren't yielding any appropriate solutions. This is the code that isn't working as expected when the "fk_…

Read More
what is the correct way to read from a datarow if the cell might be null

I have the following code which seems to blow up if the column in the datarow (dr) is null. what is the correct way to parse out the value from the data row and handle null checks? Person person = new …

Read More