DaniWeb Forum Index > Software Development > C#

C# RSS

Counting instances of a value in DB

Please support our C# advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Sep 2009

Posts: 29

Reputation: benkyma is an unknown quantity at this point

Solved Threads: 0

benkyma

Offline

Light Poster

Counting instances of a value in DB

-1

Oct 9th, 2009

I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how to handle the output. So far I have:

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
SqlCommand appCommand = new SqlCommand("select count(title) from poss_titles where title = @thisTitle", appConnection);
                appCommand.Parameters.AddWithValue("@thisTitle", cands[i]);
                SqlDataReader reader;
 
                reader = appCommand.ExecuteReader();
SqlCommand appCommand = new SqlCommand("select count(title) from poss_titles where title = @thisTitle", appConnection);
                appCommand.Parameters.AddWithValue("@thisTitle", cands[i]);
                SqlDataReader reader;
                
                reader = appCommand.ExecuteReader();