I want to display in gridview Coursename and Count of Coursename via Asp.net&C#

Question

0.00/5 (No votes)

See more:

hi all
I have one table in sqldataserver with this column:
Coursename
CourseId
StudentId

and with this data:

mathmatic 1115 8684612
mathmatic 1115 8684613
mathmatic 1115 8684614
operatingSystem 1116 8684612
operatingSystem 1116 8684615
operatingSystem 1116 8684613

I want to display in gridview Coursename and Count of Coursename via Asp.net&C#

For Exmple:

Coursename Count
mathmatic 3
operatingSystem 4

Please help me
ang give me any code for this
Thank you....

Posted 24-Oct-11 1:21am

omidfarvaha

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yuri Vital · Answer 1 · 2011-10-24T01:50:00

Solution 1

try this (I gues that you use SQL Server)

SQL

select Coursename, COUNT(Coursename) as [Count]
from *typeHereYourTableName"
group by Coursename

[EDIT]

it's obviously group by not order by... i'am confused.

[/EDIT]

Posted 24-Oct-11 1:50am

Yuri Vital

Updated 24-Oct-11 1:59am

v2

Yogesh Pednekar · Answer 2 · 2011-10-24T01:56:00

Solution 2

SQL

select Coursename, COUNT(Coursename) as [Count]
from tablename
group by Coursename

i hope this will help you.

Posted 24-Oct-11 1:56am

Yogesh Pednekar

uspatel · Answer 3 · 2011-10-24T01:57:00

use this query to bind your gridview

SQL

select coursename,count(coursename) as NoOfcount from tablename group by coursename.

bind gridview as

C#

string str = "select coursename,count(coursename) as NoOfcount from tablename group by coursename";
        SqlDataAdapter da = new SqlDataAdapter(str, Db.GetConnection());
         DataTable table = new DataTable();
        table.Locale = System.Globalization.CultureInfo.InvariantCulture;
        da.Fill(table);
        GridView1.DataSource = table;
        GridView1.DataBind();

Rakesh Katanguri · Answer 4 · 2011-10-24T01:58:00

Hi,
First you need to connect with the database.
Then use the following logic...

SqlCommand cmd= new SqlCommand("select Coursename, COUNT(Coursename) as Count
from *Table_Name", connection string name);

SqlDataReader sdr = cmd.ExecuteReader();
GridView1.DataSource = sdr;
GridView1.DataBind();

I want to display in gridview Coursename and Count of Coursename via Asp.net&C#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0