//使用ExecuteScalar方法获取第一行第一列数据。 cmd.Connection.Open(); cmd.CommandText="SELECT IsNull(Sum(Num),0) AS TotalNum FROM YourTable"; int iTotalNum=cmd.ExecuteScalar(); cmd.Connection.Close(); cmd.Dispose();
SELECT Sum(字段名) FROM YourTable
SELECT Sum(字段名) FROM YourTable 就是这样的了。楼主看一下SQL里面的聚合函数吧。
cmd.Connection.Open();
cmd.CommandText="SELECT IsNull(Sum(Num),0) AS TotalNum FROM YourTable";
int iTotalNum=cmd.ExecuteScalar();
cmd.Connection.Close();
cmd.Dispose();
就是这样的了。楼主看一下SQL里面的聚合函数吧。