Breaking News: Grepper is joining You.com. Read the official announcement!

how to get a cell value from datatable c#

Gorgeous Gannet answered on September 14, 2022 Popularity 9/10 Helpfulness 3/10

answer how to get a cell value from datatable c#

how to get a cell value from datatable c#

Comment

for (i = 0; i <= dt.Rows.Count - 1; i++)
{
    for (j = 0; j <= dt.Columns.Count - 1; j++)
    {
        var cell = dt.Rows[i][j];
       
    }
}
----------------------------------------------------
  //If you want to do some operations on any other cell based on current cell
   for (int i = 0; i < dt.Rows.Count ; i++)
                {
                    var sum = 0.0;
                    for (int j = 2; j < dt.Columns.Count-1 ; j++)
                    {
                        if (dt.Rows[i][j] == null || dt.Rows[i][j] == DBNull.Value)
                            continue;
                        string cell = (string)dt.Rows[i][j];
                        var cellvalue = float.Parse(cell);
                        sum = sum + cellvalue;
                    }
                    dt.Rows[i][dt.Columns.Count-1] = sum;
                }

Popularity 9/10 Helpfulness 3/10 Language csharp

Source: stackoverflow.com

Tags: c# cell datatable get

Link to this answer
Share Copy Link