get value from Sql Statement and store in a variable

Question

This is the Sql statement I am using behind a button in c# which will populate a DataGridView SqlDataAdapter = new SqlDataAdapter(@SELECT detail.branch SUM(CONVERT(DECIMAL(8 2) detail.total)) AS TOTAL SUM(CONVERT(DECIMAL(8 2) detail.typeA)) AS SALES FROM detail I need to extract and store the value of TOTAL so I can use it in another Sql Statement. Is this possible ?

Manas Mohapatra · Answer

Hi Peter There is small mistake in code : dg2.DataSource = dt2; // Databind method here dg2.databind(); for (int idx = 0; idx dt2.Rows.Count; idx++) { var totalVal = dt2[idx][Total].ToString(); } And also you can do in other way: foreach (DataRow row in Datatable.Rows) { var totalVal = row[Total].ToString(); } Lastly make sure that you have total column present in your result set. Still if you are getting issue please put code and error message as well.

peter piper · Answer

Hi Manas Getting errors on line var totalVal = dt2[idx][Total].ToString(); dt2 = new DataTable(); sda2.Fill(dt2); dg2.DataSource = dt2; for (int idx = 0; idx { var totalVal = dt2[idx][Total].ToString(); }

Manas Mohapatra · Answer

Hi Peter I am assuming that you are using datatable/dataset withdataadapter. If datatable: DataTable MyTable = new DataTable(); MyAdapter.Fill(MyTable); for(int idx=0; idx { var totalVal = MyTable[idx][Total] .ToString(); } Now you got total value in totalVal variable and you can that value in next SQL statement. If any doubt/problem please put your code here.