How to check specific column exist in datarow?

Question

I came across situation,where columnname for datatable is dynamic.While fetching a data I want to check existence of column.

DataTable table = ds.Table["Sample1"]

if(table.Row.Count > 0)
{
foreach(DataRow dr in table.Rows )
{
    if(dr.Table.Column.Contain("DateInfo"))
    {
        // store value in variable
        // first approach
    }

    if(table.Column.Contain("DateInfo"))
    {
        // store value in variable
        // second approach
    }
}
}

Which one is best approach?

It needs to be `Columns.Contains` instead of `Column.Contain` — Vishal Suthar, Nov 28 '13 at 06:07
possible duplicate of [ADO.NET DataRow - check for column existence](http://stackoverflow.com/questions/970985/ado-net-datarow-check-for-column-existence) — James Lawruk, Oct 31 '14 at 13:03

Vishal Suthar · Accepted Answer · 2013-11-28T06:04:51.727

Will this be enough:

1st Approach: Which will simply check in an entire DataTable.

datatable.Columns.Contains("column")

2nd Approach: which will check for each row collection in DataTable

dr.Table.Columns.Contains("column")

3rd Approach: Which fetch each columns in DataColumnCollection object and then check if it contains the specific field or not.

DataColumnCollection columns = datatable.Columns;

if (columns.Contains(columnName))

So these all approaches are better in their own way. you can use whatever you find it better.

score 1 · Answer 2 · answered Nov 28 '13 at 05:56

1

This is best one

dr.Table.Column.Contain("DateInfo")

foreach loop get single row at a time sometimes if any conditional is possible in this method

answered Nov 28 '13 at 05:56

senthilkumar2185

2,536
3
22
36

How to check specific column exist in datarow?

2 Answers2