How to display group data separately using DataList in ASP.NET?

Question

I have a sql table which have the following data,

Id   City      Country 
---  ------    ------------
1    Delhi     India
2    New York  United States
3    Karachi   Pakistan
4    Mumbai    India
5    Lahore    Pakistan
6    Kanpur    India
7    Delhi     India
8    Mumbai    India

Now, I want to display the above data in my web app as displayed below;

India
Delhi (2)    Mumbai (2)    Kanpur (1)    

United States
New York (1)

Pakistan
Karachi (1)    Lahore (1)

Please tell me:

The SQL query which will fetch the data as I want. I want City, Country and Count (grouping of all cities)
And how to display the fetched data in the format I given above in ASP.NET C#. Is there any control which we can use to display the data as I want. Or we have to write any customized code, if customized code then please tell me the code for this.

Saif Khan · Accepted Answer · 2009-02-07 07:14:07Z

3

Your SQL should be

select country,city,count(city)
from dbo.location 
group by country,city order by country

Then use datarepeter to display your data. Follow this link

answered Feb 7, 2009 at 7:14

Saif Khan

18.9k30 gold badges106 silver badges147 bronze badges

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

2 Comments

Neil N Over a year ago

any reason why he has to use a Repeater instead of a DataList?

Saif Khan Over a year ago

based on his grouped display country>>data

Henrik · Accepted Answer · 2009-02-07 07:21:24Z

2

You can use a DataSet, normalize your DB, read two tables into it and then display it with two nested DataRepeater, just like two for-loops would do.

answered Feb 7, 2009 at 7:21

Henrik

9,9856 gold badges56 silver badges89 bronze badges

Collectives™ on Stack Overflow

How to display group data separately using DataList in ASP.NET?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related