title: How to display group data separately using DataList in ASP.NET?
body: <p>I have a sql table which have the following data,</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Now, I want to display the above data in my web app as displayed below;</p>
  
  <pre><code>India
  Delhi (2)    Mumbai (2)    Kanpur (1)    
  
  United States
  New York (1)
  
  Pakistan
  Karachi (1)    Lahore (1)
  </code></pre>
  
  <p>Please tell me:</p>
  
  <ul>
  <li>The SQL query which will fetch the data as I want. I want City, Country and Count (grouping of all cities)</li>
  <li>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.</li>
  </ul>