Return value from SQLCommand

Question

I have this SqlCommand, but i dont know, how i give the return value?

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

gzaxx · Accepted Answer · 2013-06-19 08:25:42Z

4

Change this line cme.ExecuteNonQuery(); to:

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
}

More info about that method here

answered Jun 19, 2013 at 8:25

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Return value from SQLCommand

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related