How to get data from datacolumn

Question

I am doing an foreach on all columns on my DataTables row. I want to get data from a specific column but cant figure out how to do it. See code.

DataTable dt = mHandler.GetRegistrtationProgress(customer);
int column = 1;
foreach (DataColumn dc in dt.Columns)
{
    string hutt = dc.ToString();
    if (column == 11)
    {
        if (hutt.Equals("1"))
        {
            addSpecificPicture();   
        }
    }
    else
    {
        if (hutt.Equals("1"))
        {
            addPicture(column);
        }
    }
    column++;
}

When i run this code I only get name on column but there must be a good method to get value? Or not?

What exactly are you trying to do ? Get values from the first column and call `addPictures` on each value ? — Habib, Apr 09 '14 at 12:35
Nope! :) I have one row in my DataTable and I want to go through each column in that row, get the value from that column and depending on the value add a picture. — chrillelundmark, Apr 09 '14 at 12:39
Then you should get that row and then run a foreach over its items, not the columns. The columns are NOT the cells ... — Hinek, Apr 09 '14 at 12:42
Ok, thought it was possible to run on the columns... will try that... — chrillelundmark, Apr 09 '14 at 12:43
You'd have to loop through DataRows for parsing, instead of DataColumns. — LakshmiNarayanan, Apr 09 '14 at 12:45

score 9 · Accepted Answer · answered Apr 09 '14 at 12:44

Not clear what you are trying to achieve, but if you want to retrieve the value of your only one row for every column then you have to use the dc.ColumnName property

DataTable dt = mHandler.GetRegistrtationProgress(customer);
foreach (DataColumn dc in dt.Columns)
{
     string hutt = dt.Rows[0][dc.ColumnName].ToString();
     ....

Of course you could simply loop over the column of the row using an indexer

DataRow row = dt.Rows[0];
for(int i = 0; i < dt.Columns.Count; i++)
{
     string hutt = row[i].ToString();

There is also the option of the property ItemArray in the DataRow object where every element of the array contains the corresponding value

DataRow row = dt.Rows[0];
for(int i = 0; i < row.ItemArray.Length; i++)
{
     string hutt = row.ItemArray[i].ToString();
     ....

Thats exactly what i tried to achive, get value from one single row. I used your first code sample and it worked like a charm! Thanks! — chrillelundmark, Apr 09 '14 at 12:54

score 2 · Answer 2 · edited May 23 '17 at 12:01

2

You have to go through the rows first, then columns.

foreach (DataRow dr in dt.Rows) {
    foreach(DataColumn dc in dt.Columns) {
        string hutt = dr[dc].ToString()
    }
}

Or like Steve answered, if you have only 1 row.

You also can have a look here

edited May 23 '17 at 12:01

Community

1
1

answered Apr 09 '14 at 12:45

Jonathan Massot

31
2

How to get data from datacolumn

2 Answers2