Assuming your
DataGridView
has a
DataTable
as a data source you can do like this.
Just an example table. You already have a data table
DataTable dt = new DataTable();
dt.Columns.Add("Sunday", typeof(int));
dt.Columns.Add("Monday", typeof(int));
dt.Columns.Add("Tuesday", typeof(int));
dt.Columns.Add("Wednesday", typeof(int));
dt.Columns.Add("Thursday", typeof(int));
dt.Columns.Add("Friday", typeof(int));
dt.Columns.Add("Saturday", typeof(int));
for (int i = 0; i < 5; i++)
{
dt.Rows.Add(1, 2, 3, 4, 5, 6, 7);
}
dt.AcceptChanges();
Here your code starts
var query = dt.AsEnumerable().AsQueryable();
int sumSunday = query.Sum(row => (int)row["Sunday"]);
int sumMonday = query.Sum(row => (int)row["Monday"]);