[ASP.NET 3.5] How would you do it?

[Bazenga]

Hello,

I have no idea why I'm freezing on this, but here it goes:

I have a very basic database (2 tables, 1-to-many relationship) and I need a way to represent these two tables in an asp.net page. If you want, the tables look something like this:

-Item

-ItemID: integer, primarykey

-ItemName: nvarchar(max)

-ItemDescription

-ItemDescriptionID: integer, primarykey

-ItemID: integer, foreign key

-Other description goes here.

Kindly don't pay any attention to the above tables, it's just to give an example of what I have.

What I want to achieve is to have a grid inside a grid. When the user clicks on a row in the master grid, the subgrid gets loaded underneath that row with the right information.

So if you have the same requirements, how would you approach it? I need to display the information from both tables (all the information).

I hope that was clear enough.

[BGM]

i would start by googling (or binging) "nested gridview"

i have done it quickly, and it looks like it exists, but not as native functionality.

this looks promising: http://www.codeguru.com/columns/vb/article.php/c12647/

there are also some youtube videos that look interesting.

[Bazenga]

thanks a lot man. I did google (I don't bing :p) nested gridview but almost all of them have examples of a gridview inside a column and not a row.

[BGM]

i see the issue!

as you are using .net 3.5, check out a nested listview, if i have some time i might give it a crack tomorrow.. :)

[Bazenga]

OWH! I completely forgot about the listview !! I'm going to have a go on it tomorrow as well. Hopefully I'll be able to solve it =).