How to get row value by just giving column name in DataTable

Question

Is it possible to get a row value by giving column name when DataTable holds a single row, without iteration.

foreach(DataRow row in dt.Rows)
{
    string strCity = row["City"].ToString();
}

Table

I need Something like below without loop when we have only one row,

String cn=row["ColumnName"].ToString()

What is a row value? Rows consist of columns so you should say what column you want — Gilad Green, Aug 19 '16 at 13:04
Possible duplicate of [DataRow: Select cell value by a given column name](http://stackoverflow.com/questions/7119993/datarow-select-cell-value-by-a-given-column-name) — sr28, Aug 19 '16 at 13:05

score 20 · Answer 1 · answered Nov 23 '18 at 05:48

20

This is the way:

string Text = dataTable.Rows[0]["ColumnName"].ToString();

answered Nov 23 '18 at 05:48

Paul Pérez

320
3
9

score 3 · Answer 2 · answered Nov 23 '18 at 05:54

3

Use following code to get the value of the first row of the DataTable without iteration:

string strCity = string.Empty;
if (yourDataTable.Rows.Count > 0)
    strCity = yourDataTable.Rows[0]["City"].ToString();

answered Nov 23 '18 at 05:54

Brijesh Kumar Tripathi

1,762
15
25

score 1 · Answer 3 · answered Aug 19 '16 at 13:07

1

Convert.ToString(row["ColumnName"]);

answered Aug 19 '16 at 13:07

Aniruddh

11
1

score 0 · Answer 4 · answered Aug 19 '16 at 13:05

0

This is attempting to index the row itself:

row["ColumnName"].ToString()

What you're looking for is to index the items within the row:

row.Item["ColumnName"].ToString()

when DataTable holds a single row, without iteration

If you're guaranteed that there is a row, you can reference it directly:

dt.Rows[0].Item["ColumnName"].ToString()

As with any indexing, you should probably do some bounds checking before trying to index it though.

answered Aug 19 '16 at 13:05

David

208,112
36
198
279

4

Note that there is no `row.Item` in DataRow – Douglas Gaskell May 12 '18 at 04:34
it not row.Item ... it's row.ItemArray – GregJF Jan 07 '22 at 01:00

score 0 · Answer 5 · answered Sep 02 '19 at 10:47

DataTable dt = new DataTable();    
sqlDa.Fill(dt);
        if (dt.Rows.Count > 0)
        { 
            StringBuilder html = new StringBuilder();
            foreach (DataRow row in dt.Rows)
            {
                html.Append(row.Field<Int32>("Columname"));

            }
        }

How to get row value by just giving column name in DataTable

5 Answers5