Grouping & The DataGrid or DataList or Repeater Control

[David Wier]

Check out this code sample:
<a href="http://aspnet101.com/aspnet101/tutorials.aspx?id=8">Nesting
Controls</a> -
there's even a code sample for Nesting Datalists that might be what you
want:
[url]http://aspnet101.com/aspnet101/aspnet/codesample.aspx?code=nest[/url]


David Wier
[url]http://aspnet101.com[/url]
[url]http://aspexpress.com[/url]


"Demetri" <Reject@Spam.com> wrote in message
news:0b8601c35dbc$24f4be80$a301280a@phx.gbl...

> If I have data that comes back in the following format:
>
> Brand City
> --------- ----------
> A1 New York
> B2 New York
> B4 New York
> A5 Boston
> A6 Boston
> C3 Chicago
> C5 Chicago
> D1 Los Angeles
>
>
> I want the page to display it this way (grouped by City):
>
> New York
> A1
> B2
> B4
>
> Boston
> A5
> A6
>
> Chicago
> C3
> C5
>
> Los Angeles
> D1
>
> How do I do that? All examples of populating a DataGrid
> are all Top-Down - I need to be able to group it. Any
> suggestions?

[S. Justin Gengo]

Demetri,

First look into using a view to select the records you need.

Something like:

Dim BrandView As New DataView(MyTable)
BrandView.RowFilter = "State = '" & strState & "'"

Then bind the dataview to another datagrid / datalist nested withing the
other.

Heres a good article on nesting datagrids:

[url]http://www.standardio.org/article.aspx?id=155[/url]

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
[url]www.aboutfortunate.com[/url]

"Out of chaos comes order."
Nietzche


"Demetri" <Reject@Spam.com> wrote in message
news:0b8601c35dbc$24f4be80$a301280a@phx.gbl...

> If I have data that comes back in the following format:
>
> Brand City
> --------- ----------
> A1 New York
> B2 New York
> B4 New York
> A5 Boston
> A6 Boston
> C3 Chicago
> C5 Chicago
> D1 Los Angeles
>
>
> I want the page to display it this way (grouped by City):
>
> New York
> A1
> B2
> B4
>
> Boston
> A5
> A6
>
> Chicago
> C3
> C5
>
> Los Angeles
> D1
>
> How do I do that? All examples of populating a DataGrid
> are all Top-Down - I need to be able to group it. Any
> suggestions?