Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > Presenting complex query results through datagrid

Reply
Thread Tools

Presenting complex query results through datagrid

 
 
Bijoy Naick
Guest
Posts: n/a
 
      02-24-2004
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?
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET won't retrieve query results that depend on union query Eric Nelson ASP .Net 5 02-04-2009 10:51 PM
Presenting calculation results Vedran Python 1 09-10-2008 05:18 PM
Presenting VOIP as an ISDN/BRI trunk newsgroups@djguk_spam.co.uk UK VOIP 5 08-11-2005 05:07 PM
I18N Question re presenting time remaining Rhino Java 2 02-11-2005 01:35 PM
presenting an alternative when browser can't handle unicode symbols Jim Higson HTML 2 08-23-2004 06:15 PM



Advertisments