Datalist within a Datalist.

[Rob Manger]

Hi All,

This may be a stupid question, and may not be the correct solution for my
problem, but here goes.

I want to include a datalist within a datalist, in order to effectively
group items according to one of the columns in a dataset. For example: I
have 2 artists and 7 items. I want to display these in the following
format:

Artist1 Item1
Item2
Item5
Item7

Artist2 Item3
Item4
Item6

I have successfully included a datalist inside a datalist, BUT the second
datalist lists ALL items. I need to somehow run a custom SELECT statement,
eg: in a dataview, but I can't figure out how to do this dynamically. I
want to avoid having a separate Dataview for each Artist.

Can anyone help me please? And is this the right solution?

Regards and Thanx in advance.

Rob
ro**@devtest.com

[Erik Frey]

I'm not sure if I understand your question, but it sounds like you're
trying to duplicate the functionality provided in datagrids:
http://www.dotnetjunkies.com/tutoria...63C4C9BBC.dcik

Hope that helps,

Erik

"Rob Manger" <ro**@devtest.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi All,

This may be a stupid question, and may not be the correct solution for my
problem, but here goes.

I want to include a datalist within a datalist, in order to effectively
group items according to one of the columns in a dataset. For example: I
have 2 artists and 7 items. I want to display these in the following
format:

Artist1 Item1
Item2
Item5
Item7

Artist2 Item3
Item4
Item6

I have successfully included a datalist inside a datalist, BUT the second
datalist lists ALL items. I need to somehow run a custom SELECT statement, eg: in a dataview, but I can't figure out how to do this dynamically. I
want to avoid having a separate Dataview for each Artist.

Can anyone help me please? And is this the right solution?

Regards and Thanx in advance.

Rob
ro**@devtest.com

[Rob Manger]

Erik,

Thanx heaps for the prompt reply. This looks like exactly what I want :D

Rob.

"Erik Frey" <er*******@hotmail.com> wrote in message
news:uO**************@TK2MSFTNGP09.phx.gbl...

I'm not sure if I understand your question, but it sounds like you're
trying to duplicate the functionality provided in datagrids:
http://www.dotnetjunkies.com/tutoria...63C4C9BBC.dcik
Hope that helps,

Erik

"Rob Manger" <ro**@devtest.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi All,

This may be a stupid question, and may not be the correct solution for my problem, but here goes.

I want to include a datalist within a datalist, in order to effectively
group items according to one of the columns in a dataset. For example: I have 2 artists and 7 items. I want to display these in the following
format:

Artist1 Item1
Item2
Item5
Item7

Artist2 Item3
Item4
Item6

I have successfully included a datalist inside a datalist, BUT the second datalist lists ALL items. I need to somehow run a custom SELECT

statement,

eg: in a dataview, but I can't figure out how to do this dynamically. I
want to avoid having a separate Dataview for each Artist.

Can anyone help me please? And is this the right solution?

Regards and Thanx in advance.

Rob
ro**@devtest.com