Loading

get value from Sql Statement and store in a variable

get value from Sql Statement and store in a variable

peter piper

11y958Visual Basic .NET

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 ?

3 Replies

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

Manas Mohapatra11y ago
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 piper11y ago
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 <= dt2.Rows.Count; idx++)
{
var totalVal = dt2[idx]["Total"].ToString();
}
Manas Mohapatra11y ago
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<= MyTable.Rows.Count; 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.