help with heirarchical grid

[Mike]

I just downloaded the trial and I'm trying to display heirarchical data. I've gone through the examples but no luck. The best I can do is display the master row with the plus sign but when I click the plus sign I don't see the details.

I'm using a stored procedure to populate my dataset. It returns two tables. Table[0] is the master and Table[1] is the detail.

I've tried the following two examples. Any help would be apprecieated.

 

Example 1.

dataAdapter.Fill(myDataSet);

myDataSet.Tables[0].TableName = "workorder";
myDataSet.Tables[1].TableName = "details";

DataRelation dr = new DataRelation("workorders",
   myDataSet.Tables[0].Columns["WorkOrderId"],
   myDataSet.Tables[1].Columns["WorkOrderId"]);
DataSet.Relations.Add(dr);

radGridView1.AutoGenerateHierarchy = true;
radGridView1.DataSource = myDataSet;
radGridView1.DataMember = "workorder";

Example 2. 

radGridView1.DataSource = myDataSet.Tables[0];

GridViewTemplate template = new GridViewTemplate();
template.DataSource = myDataSet.Tables[1];
radGridView1.MasterGridViewTemplate.ChildGridViewTemplates.Add(template);

GridViewRelation relation = new GridViewRelation(radGridView1.MasterGridViewTemplate);
relation.ChildTemplate = template;
relation.RelationName = "workorders";
relation.ParentColumnNames.Add("WorkOrderId");
relation.ChildColumnNames.Add("WorkOrderId");
radGridView1.Relations.Add(relation);

[Victor]

Hi Mike,

Thank you for contacting us. Please see our Hierarchical Data tutorial in our online documentation. The tutorial is available here.

Please write again if you need further assistance.

Sincerely yours,
Victor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Mike]

Victor,

Yes, the tutorial is where I got the code from in my examples. For some reason I can't get it to work. I thought it might be something simple that I'm overlooking and that's the reason I posted my examples. is there additional information I can provide to help diagnose the problem? Thanks.

[Victor]

Hi Mike,

Thanks for writing.
I found an easier solution than the help tutorial. Here is what you need to do.
1. Create a RadGridView.
2. Add a DataSet with it's tables (I suggest using the Visual Studio wizard).
3. Fill the tables with a TableAdapter.
4. Set RadGridView's AutoGenerateHierarchy property to true.
5. Set the RadGridView's DataSource property to the dataset.
6. Set the RadGridView's DataMemeber property to the name of one of the tables.
I have attached a sample application showcase the points. It's really short. Everything is done in the Form's OnLoad event.
I hope this is helpful to you. Please write again if you have other questions or issues.

Greetings,
Victor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.