5.8w+
社区成员
- 主页
- .NET Framework
- ASP
- Web Services
- .NET互联网桌面应用
- VB
- 图表区
- 分析与设计
- 组件/控件开发
- AppLauncher
- 问答
我这样做可以把sql语句的取出的值赋给一个变量么?大家帮我看看,谢谢
我想把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
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
...全文
请发表友善的回复…
发表回复
ppp80 2004-04-07
myCommand.Fill(ds_in);
String sum = ds_in.Tables[0].Columns[0].ToString();
String sum = ds_in.Tables[0].Columns[0].ToString();
暗石绿 2004-04-07
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();
SqlConnection sqlConn = new SqlConnection(strSql);
SqlCommand sqlCmd = new SqlCommand(selectCmd,sqlConn);
sqlConn.Open();
string result = sqlCmd.ExecuteScalar().ToString();
sqlConn.Close();
jourmen 2004-04-07
谢谢大哥:)
解决了:)
给分:)
解决了:)
给分:)
sdliubo 2004-04-07
count 是系统的关键字