Drill down datagrid in C#.net

agarwalvidhu · #1 (**permalink**) February 23rd, 2006, 06:33 AM

Hi

I am working on Datagrid in C#.net. I have to create hierarchical/drilldown datagrid such that the datagrid is nested at three levels. I have instantiated one datagrid. Using TemplateColumn,i am adding another datagrid. When + button is clicked this nested datagrid shows the details of that ID. Now i have to go one level down and show records for the item clicked in the second grid. However i cant get which event to use to write code in

Urgent help needed for it

MAKO · #2 (**permalink**) February 25th, 2006, 11:23 AM

My friend, all you need to do is to create the datarelations between
the tables you need in the dataset and then bind a Datagrid to that dataset and done.

:-Q Marvin B-)

agarwalvidhu · #3 (**permalink**) February 27th, 2006, 01:37 AM

Hi marvin,
I could have used data relations in that but with relations i dont get the expandable and collapsable thing. I want the data to be displayed only for the region the user wish to c and not all at one go. Moreover when i tried using datarelations, i am getting the following error. can u help me out in tht:

"The relation is not parented to the table to which this DataView points"

I checked my query. the parent table has records for order and child table for order details

Thankx

ziaiz · #4 (**permalink**) April 14th, 2006, 05:30 AM

HI VIDHU,
I AM GETTING SAME PROBLEM?

have you found any solution???

zia

rkedia · #5 (**permalink**) May 1st, 2006, 05:50 PM

Hi Vidhu,

Can you send me the code that you used to create drill down datagrid that is nested at three levels, I need only 2 levels and I am having a difficult time figuring this out.

Thanks,

Renu

MAKO · #6 (**permalink**) May 4th, 2006, 10:56 AM

Guys, you can use a dataset designer (includen in VS) and create the xml squema for your dataset's tables, in there, you can define datarelations between the tables which will therefore make your datagrid show the expandable + signs when you bind that dataset to it.

MAKO - "El super simio"

rajanvash · #7 (**permalink**) May 22nd, 2006, 12:12 AM

Hi,

Being a new developer to .NET technologies, i request Marvin to post the code for this drill down data grid solution.

Thanks and Regards,
Rajan Vashisht