Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Ben
215
Dataset & relationship question
posted

Hey Guys,

Probably a easy one, but ive created a dataset with a parent table and child tables

using

DataRelation relation =

new System.Data.DataRelation("Rel" + i.ToString(),

ds.Tables[0].Columns["id"], ds.Tables[i].Columns["Parent ID"]);

ds.Relations.Add(relation);

 

I then  using SetDataBinding to bind it to my tree, the only problem im having for each row on the parent set it is showing 10 nodes(number of child table) even though there is no relationship between them, thus, for the tables that are related to the parent row, these are populated... what i would like to see is only the child tables with there names NOT the "Rel.." name

 any ideas

 

 

 

Parents
No Data
Reply
  • 469350
    Offline posted

    Hi Ben,

    It sounds like you are talking about the Band Nodes. If your data has sibling bands, then those bands have to be seperated out into different parents, so the tree creates the band nodes for that. There's no way to display data from different tables in a single nodes collection in the tree.

Children
No Data