Specific row withing a DataTable

[irahuman]

I have a data table which has a "Total" column. I want to be able to get a specific rows "Total" not all rows.\[code\]public void maxValue() { string pass = (String)Session["name"]; DataTable table = (DataTable)Session["CocaCola"]; int total = table.AsEnumerable().Sum(r => r.Field<int>("Total")); int totalAllowed = table.AsEnumerable().Sum(r => r.Field<Int32>("Total Allowed")); if (total >= totalAllowed) { Label1.Text = "Total value exceeded the maximum of " + totalAllowed; } else if (total < totalAllowed) { Label1.Text = "Total value which is allowed :" + totalAllowed; } if (pass.Equals("Low")) { Label1.Text = "You are not allowed any assets at this Stage"; //SNS.Checked = false; //TT.Checked = false; //Music.Checked = false; //SNS.Enabled = false; //TT.Enabled = false; //Music.Enabled = false; } }\[/code\]As you can see my method works but add the column up which i dont want to do. How would i go about changing it?