c# sum 函数取值问题

[jin225]

string cmdtxt = "select sum(ProductId) as SumProduct from Product where BigCategId=" + int.Parse(bigCateg);

怎么在asp.net程序中得到 返回的数据

写的详细点
谢谢了
我要给label赋值的

[沉序员]

lz.sql=有問題

[我姓区不姓区]

            using (SqlConnection conn = new SqlConnection("连接字符串"))
            {
                string cmdtxt = "select sum(ProductId) as SumProduct from Product where BigCategId=" + int.Parse(bigCateg);
                SqlCommand cmd = new SqlCommand(cmdtxt, conn);
                conn.Open();
                label1.Text = cmd.ExecuteScalar().ToString();
                conn.Close();
            }
        }

[-无-为-]

string cmdtxt = "select sum(ProductId) from Product where BigCategId=" + int.Parse(bigCateg);

别名SumProduct 去掉，选择comand的ExecuteScalar（）方法

label.text=cmd.ExecuteScalar（）;

[mjjzg]

连接数据库,查询这条语句,将返回的行记录给lable不就oK了

[dengxiao1981]

/// <summary>
/// 执行Sql语句返回ID值
/// </summary>
/// <param name="str_Sql">Sql语句</param>
public string RunSqlReturnID(string strSql)
{
string ID = "";
Open();
SqlCommand cmd = new SqlCommand(strSql, mysqlconnec);
int i = cmd.ExecuteNonQuery();

if (i != 0)
{
try
{
SqlDataAdapter Ada = new SqlDataAdapter("select @@identity", mysqlconnec);
DataSet ds = new DataSet();
Ada.Fill(ds);
ID = ds.Tables[0].Rows[0][0].ToString();
}
catch { }
}

mysqlconnec.Close();
mysqlconnec.Dispose();
return ID;
}

[xmycl008]

string ConnectionString = "Data Source=.;DataBase=数据库;Uid=登录名;Pwd=密码;";
SqlConnection conn = new SqlConnection(ConnectionString);
string sql = "select sum(ProductId) as SumProduct from Product where BigCategId=" + int.Parse(bigCateg);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
label1.Text = cmd.ExecuteScalar().ToString();
conn.Close();

[甩尾儿Boy]

6楼的比较好