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();

Return value from SQLCommand

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
}

关于这个方法的更多信息在这里