How do i sum the value from each column from last row

How do i sum the value from each column from last row of data table.

i have a datatable which last row has total number for each product. for example column_Apple total apple in last row has 5, column_Orange total orange in last row has 10.

Now i need to sum up total fruits totalApple + totalOrange and print out.

You can write the code to loop through the datarow, sum the column then update the total. Here is an example.

DataTable table = new DataTable();
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Apple", typeof(int));
var column = new DataColumn();
column.DataType = System.Type.GetType("System.Int64");
column.ColumnName = "Orange";
column .AllowDBNull = true;
table.Columns.Add(column);
table.Columns.Add("Total", typeof(int));
table.Rows.Add(1,10,20,0);
table.Rows.Add(2,14,10,0);
table.Rows.Add(3,9,null,0);
int totalApple = 0;
int totalOrange = 0;
foreach (DataRow row in table.Rows)
{
int.TryParse(row["Apple"].ToString(), out totalApple);
int.TryParse(row["Orange"].ToString(), out totalOrange);
row["Total"] = totalApple + totalOrange ;
Console.WriteLine( row["Total"]);
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan7y ago
You can write the code to loop through the datarow, sum the column then update the total. Here is an example.
DataTable table = new DataTable();

        table.Columns.Add("Id", typeof(int));
        table.Columns.Add("Apple", typeof(int));

        var column = new DataColumn();
                column.DataType = System.Type.GetType("System.Int64");
                column.ColumnName = "Orange";
                column .AllowDBNull = true;

        table.Columns.Add(column);
        table.Columns.Add("Total", typeof(int));

        table.Rows.Add(1,10,20,0);
        table.Rows.Add(2,14,10,0);
        table.Rows.Add(3,9,null,0);
        int totalApple = 0;
        int totalOrange = 0;

        foreach (DataRow row in table.Rows)
        {
            int.TryParse(row["Apple"].ToString(), out totalApple);
            int.TryParse(row["Orange"].ToString(), out totalOrange);

            row["Total"] = totalApple + totalOrange ;

            Console.WriteLine( row["Total"]);
        }
+1