Using select count(*) in c#

Question

    String dd_webCofig = ConfigurationManager.ConnectionStrings["server132"].ConnectionString;
    SqlConnection ddlistconn = new SqlConnection(dd_webCofig);
    ddlistconn.Open();

    string ddlist = "select count(*) from jud_order where complex_name=@a and case_no=@b and sign=@c and jud_order_date=@d and user_code=@e";
    SqlCommand ddlistCmd = new SqlCommand(ddlist, ddlistconn);
    ddlistCmd.Parameters.AddWithValue("a", "a");
    ddlistCmd.Parameters.AddWithValue("b", "a");
    ddlistCmd.Parameters.AddWithValue("c", "a");
    ddlistCmd.Parameters.AddWithValue("d", "a");
    ddlistCmd.Parameters.AddWithValue("e", "a");

    SqlDataReader myReader = ddlistCmd.ExecuteReader();

I am having the above query which returns number of rows, now my problem is how t read the output of the query? What i want is

 if(count=0)
{ 
   //Do
} 
else if(counnt >0)
{
    //Do something else
}

m.edmondson · Accepted Answer · 2011-04-18 11:13:50Z

13

You want to use ExecuteScalar(); instead which will return a single result.

So this line:

ddlistCmd.ExecuteReader();

should be:

ddlistCmd.ExecuteScalar();

which you can then assign to count after type casting the result.

edited Apr 18, 2011 at 11:13

answered Apr 18, 2011 at 11:04

m.edmondson

30.9k29 gold badges129 silver badges212 bronze badges

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

6 Comments

Artemix Over a year ago

Note that ExecuteScalar returns object. You will need to cast the result to int.

Henk Holterman Over a year ago

And you have to type-cast the result.

clamchoda Over a year ago

His problem is, how to read the output of the query. How does this have so many up votes without the answer?

m.edmondson Over a year ago

@Chris - This is the answer - surely?

clamchoda Over a year ago

Can you make an edit showing how to access the count(*) stored in the ddListCmd? I think he will accept your answer after that!

|

Oleks · Accepted Answer · 2011-04-18 11:08:09Z

0

int result=ddlistCmd.ExecuteScalar();

edited Apr 18, 2011 at 11:08

Oleks

32.4k11 gold badges80 silver badges134 bronze badges

answered Apr 18, 2011 at 11:06

Zo Has

13.1k24 gold badges92 silver badges150 bronze badges

Comments

Oleks · Accepted Answer · 2011-04-18 11:08:22Z

-1

Try:

myReader.Read();
count= int.Parse(myReader[0].ToString());

edited Apr 18, 2011 at 11:08

Oleks

32.4k11 gold badges80 silver badges134 bronze badges

answered Apr 18, 2011 at 11:07

Varun Goel

3393 silver badges15 bronze badges

1 Comment

TomTom Over a year ago

RTFM ;) for exactly THIS there is a better wy (ExecuteScalar)

Collectives™ on Stack Overflow

Using select count(*) in c#

3 Answers 3

6 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related