Return value from SQLCommand
本文关键字:SQLCommand from value Return | 更新日期: 2023-09-27 18:19:03
我有这个SqlCommand,但我不知道,我如何给出返回值?
string param = Request.QueryString["id"];
System.Data.SqlClient.SqlConnection se = new System.Data.SqlClient.SqlConnection(GetConnectionString());
{
System.Data.SqlClient.SqlCommand cme;
se.Open();
cme = new System.Data.SqlClient.SqlCommand("select Sum(case when (Domaci_tym = 'Tupesy') then Domaci_branky else Hoste_branky end) from Zapas AS branky where (ID_zapas=@ID_zapas)", se);
cme.Parameters.AddWithValue("@ID_zapas", param);
cme.ExecuteNonQuery();
se.Close();
将cme.ExecuteNonQuery();
改为:
double sum = 0d;
var result = cme.ExecuteScalar(); //returns object that needs casting to get proper value
if (result != null && double.TryParse(result.ToString(), out sum))
{
//query returned valid sum
}
关于这个方法的更多信息在这里