Presenting complex query results through datagrid

Discussion in 'ASP .Net Datagrid Control' started by Bijoy Naick, Feb 24, 2004.

  1. Bijoy Naick

    Bijoy Naick Guest

    lets assume that i run a query that returns the following records

    countryID,countryName,cityID,cityName
    1,USA,1,Chicago
    1,USA,2,Los Angeles
    1,USA,3,Detriot
    2,Canada,7,Toronto
    2,Canada,9,Montreal
    3,England,15,London

    The intended output needs to look like this..

    <table>
    <tr>
    <td>Country</td>
    <td>Cities</td>
    </tr>
    <tr>
    <td>USA</td>
    <td>Chicago, Los Angeles,Detriot</td>
    <tr>
    <tr>
    <td>Canada</td>
    <td>Toronto, Montreal</td>
    <tr>
    <tr>
    <td>England</td>
    <td>London</td>
    <tr>
    </table>

    How can I use teh datagrid control to present the information like this?
    Bijoy Naick, Feb 24, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rhino
    Replies:
    2
    Views:
    406
    Rhino
    Feb 11, 2005
  2. Jim Higson
    Replies:
    2
    Views:
    398
    Jukka K. Korpela
    Aug 23, 2004
  3. Replies:
    4
    Views:
    611
  4. Ingvald Straume (from Norway - Europe)

    Presenting a new(?) idea for free open source software development.

    Ingvald Straume (from Norway - Europe), Aug 7, 2005, in forum: C++
    Replies:
    10
    Views:
    579
    Ingvald Straume (from Norway - Europe)
    Aug 9, 2005
  5. Vedran

    Presenting calculation results

    Vedran, Sep 10, 2008, in forum: Python
    Replies:
    1
    Views:
    287
    Marco Bizzarri
    Sep 10, 2008
Loading...

Share This Page