Question

ASP.NET循环读取数据

用的是C#
string sqltotal = "select sum(num) from stock where modules='" + modules.Text.Trim() + "' and stockarea='" + stockarea.SelectedValue.Trim() + "' and state='" + state.SelectedValue.Trim() + "' and remark='" + remark.Text.Trim() + "'";

SqlDataAdapter datotal = new SqlDataAdapter(sqltotal, strCon);
DataSet dstotal = new DataSet();
datotal.Fill(dstotal, sqltotal);

do while not rs3.eof
rs3.movenext
loop
这些话在C#该怎么写

Answer 1

string sqltotal = "select sum(num) from stock where modules='" + modules.Text.Trim() + "' and stockarea='" + stockarea.SelectedValue.Trim() + "' and state='" + state.SelectedValue.Trim() + "' and remark='" + remark.Text.Trim() + "'";

SqlDataAdapter datotal = new SqlDataAdapter(sqltotal, strCon);
DataSet dstotal = new DataSet();
datotal.Fill(dstotal, sqltotal);

while (rs.read())
{
}

Answer 2

string sqltotal = "select sum(num) from stock where modules='" + modules.Text.Trim() + "' and stockarea='" + stockarea.SelectedValue.Trim() + "' and state='" + state.SelectedValue.Trim() + "' and remark='" + remark.Text.Trim() + "'";

SqlDataAdapter datotal = new SqlDataAdapter(sqltotal, strCon);
DataSet dstotal = new DataSet();
datotal.Fill(dstotal, sqltotal);
int sum=0;
for (int i=0;i<dstotal.rows.count;i++)
{
sum=Convert.ToInt32(rows[i][0])
}

Answer 3

u建议