Access cell value of datatable

Question

Can anyone help me how to access for example value of first cell in 4th column?

a b c d
1 2 3 5
g n m l

for example, how to access to value d, if that would be datatable?

Thanks.

vc 74 · Accepted Answer · 2016-10-28T13:29:39.043

144

If you need a weak reference to the cell value:

object field = d.Rows[0][3]

or

object field = d.Rows[0].ItemArray[3]

Should do it

If you need a strongly typed reference (string in your case) you can use the DataRowExtensions.Field extension method:

string field = d.Rows[0].Field<string>(3);

(make sure System.Data is in listed in the namespaces in this case)

Indexes are 0 based so we first access the first row (0) and then the 4th column in this row (3)

edited Oct 28 '16 at 13:29

answered Jan 26 '12 at 17:10

vc 74

37,131
7
73
89

4

@OP Just keep in mind that you'll often want to check first to ensure that there really are enough rows/columns when hard coding values like this. – Servy Jan 26 '12 at 18:11
1

see also http://stackoverflow.com/a/13816531/638977 It suggestes `int number = dt.Rows[i].Field(j);` – Behzad Ebrahimi Aug 16 '16 at 09:08

score 80 · Answer 2 · edited Jun 10 '13 at 11:20

80

string abc= dt.Rows[0]["column name"].ToString();

edited Jun 10 '13 at 11:20

Sander

392
2
13

answered Oct 13 '12 at 08:19

ashok luhach

801
6
2

score 13 · Answer 3 · edited Jan 08 '16 at 14:50

13

You can also try (first cell in 4th column):

dt.Rows[0][3]

edited Jan 08 '16 at 14:50

Soner Gönül

97,193
102
206
364

answered Dec 05 '13 at 18:37

FrenkyB

6,625
14
67
114

score 8 · Answer 4 · answered Jan 26 '12 at 17:15

8

foreach(DataRow row in dt.Rows)
{
    string value = row[3].ToString();
}

answered Jan 26 '12 at 17:15

gabsferreira

3,089
7
37
61

score 7 · Answer 5 · answered Jun 24 '14 at 13:42

7

data d is in row 0 and column 3 for value d :

DataTable table;
String d = (String)table.Rows[0][3];

answered Jun 24 '14 at 13:42

athena

279
3
11

score 1 · Answer 6 · answered Jun 20 '17 at 04:26

public V[] getV(DataTable dtCloned)
{

    V[] objV = new V[dtCloned.Rows.Count];
    MyClasses mc = new MyClasses();
    int i = 0;
    int intError = 0;
    foreach (DataRow dr in dtCloned.Rows)
    {
        try
        {
            V vs = new V();
            vs.R = int.Parse(mc.ReplaceChar(dr["r"].ToString()).Trim());
            vs.S = Int64.Parse(mc.ReplaceChar(dr["s"].ToString()).Trim());
            objV[i] = vs;
            i++;
        }
        catch (Exception ex)
        {
            //
            DataRow row = dtError.NewRow();
            row["r"] = dr["r"].ToString();
            row["s"] = dr["s"].ToString();
            dtError.Rows.Add(row);
            intError++;
        }
    }
    return vs;
}

score 0 · Answer 7 · answered Nov 24 '22 at 16:59

Assuming that the values in "SomeColumnName" are unique / distinct and that the value you are looking for in "NameOfColumnWhereIsTheValueYouLookingFor" is "Double".

double SomeDoubleValue = (double)SomeDataTable.Select("SomeColumnName = ValueWhichDetermineTheRowLocation").First()["NameOfColumnWhereIsTheValueYouLookingFor"]

Access cell value of datatable

7 Answers7

Linked