我这样做可以把sql语句的取出的值赋给一个变量么?大家帮我看看,谢谢

[jourmen]

我想把sql语句的取出的值赋给一个变量,我是这样做的,但是取不到:(

String selectCmd = "select sum(count) from commstock where commodity='11'";

OleDbDataAdapter myCommand = new OleDbDataAdapter(selectCmd, myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds_in, "count");
String sum = ds_in.Tables["count"].Columns[0].ToString();


可是我现在sum的值怎么都是1,55555555555555555555

[sdliubo]

count 是系统的关键字

[jourmen]

谢谢大哥:)

解决了:)

给分:)

[暗石绿]

string selectCmd = "select sum(字段) from commstock where commodity='11'";
SqlConnection sqlConn = new SqlConnection(strSql);
SqlCommand sqlCmd = new SqlCommand(selectCmd,sqlConn);
sqlConn.Open();
string result = sqlCmd.ExecuteScalar().ToString();
sqlConn.Close();

[ppp80]

myCommand.Fill(ds_in);
String sum = ds_in.Tables[0].Columns[0].ToString();