Easy way to find Query return how many rows SQL Server

Question

This is windows back-end service where I need to write each and every action to Log file. I want to find how many rows return by SQL Select Query, I want to write that record to Log file.

Example:

Select statement return 35 rows.

Logs entries:

4/18/2016 4:54:47 PM : -Class--> CallBackOption| -Function--> UpdateServiceIBC| -Message--> SELECT * FROM CALLBACKOPTION WHERE ProccessStatus = 0
4/18/2016 4:54:47 PM : -Class--> Update Service Call Back Option| -Function--> UpdateServiceCall Back Option| -Message--> ***** New Record *****
4/18/2016 4:54:47 PM : -Class--> Update Service Call Back Option| -Function--> UpdateServiceCall Back Option| -Message--> Formatting ANI[sip:[email protected]] TO Contact[03022745301] against CA[400001358877]
4/18/2016 4:54:47 PM : -Class--> Update Service Call Back Option| -Function--> UpdateServiceCall Back Option| -Message--> Checking for Contact Number
4/18/2016 4:54:47 PM : -Class--> Update Service Call Back Option| -Function--> UpdateServiceCall Back Option| -Message--> Contact Number[9903022745301] call process Chain ID[1]
4/18/2016 4:54:47 PM : -Class--> Update Service Call Back Option| -Function--> UpdateServiceCall Back Option| -Message--> Updating AutoCall Back Option

Code Snippet:

     string query = "SELECT * FROM CALLBACKOPTION WHERE ProccessStatus = 0";
                    Log.WriteErrorLog("CallBackOption", "UpdateServiceIBC", "SELECT * FROM CALLBACKOPTION WHERE ProccessStatus = 0");
                    using (SqlConnection con = new SqlConnection(ConnectionString))
                    {
                        con.Open();
                        SqlCommand cmd = new SqlCommand(query, con);
                        SqlDataReader reader = cmd.ExecuteReader();
                        while (reader.Read())
                        {
                            Log.WriteErrorLog("Update Service Call Back Option", "UpdateServiceCall Back Option", "***** New Record *****");
                            string dateTime = reader["DateTime"].ToString();
                            string ANI = reader["ANI"].ToString();
                            string contact = ANI.Substring(ANI.IndexOf(":") + 1, ANI.IndexOf("@") - 4);
                            string CA = reader["CUSTOMER_ACCOUNT"].ToString();
Log.WriteErrorLog("","", "Formatting ANI[" + ANI + "] TO Contact[" + contact + "] against CA[" + CA + "]");

Are you interested in the data itself or do you just need the count? — Gottfried Lesigang
– Gottfried Lesigang, Commented Apr 18, 2016 at 12:17
I just need the count....! Please see the edited question for your reference...! — BilalAhmed
– BilalAhmed, Commented Apr 18, 2016 at 12:19

Tim Long · Accepted Answer · 2016-04-18 12:45:45Z

2

The easiest way in my eyes (if you are reading the data in any case):

[...]
int counter=0;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read()){
    counter++;
    [...]
}

The variabe counter will show the count of rows being processed.

Are there other CRUD statements too?

edited Apr 18, 2016 at 12:45

Tim Long

13.8k20 gold badges91 silver badges157 bronze badges

answered Apr 18, 2016 at 12:31

Gottfried Lesigang

67.6k9 gold badges60 silver badges124 bronze badges

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

Comments

Leonard Klausmann · Accepted Answer · 2016-04-18 12:27:21Z

0

If you want to know only the amount of rows you can use:

cmd.ExecuteNonQuery();

That will executes an SQL statement against the Connection and returns the number of rows affected.

MSDN

answered Apr 18, 2016 at 12:27

Leonard Klausmann

2153 silver badges13 bronze badges

Collectives™ on Stack Overflow

Easy way to find Query return how many rows SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related