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
710
Hide Hierarchial Relations
posted

I retrieved a DataSet from the database with multiple tables, and defined the relationships between the tables. When I bind the DataSet to the Tree, the relations show-up as nodes in the Tree hierarchy. How can I hide these relations.

For example, instead of:

Tom Harden

   InvoiceRelationshipName

      1   $500

      2   $450

I would like:

Tom Harden

   1   $500

   2   $450

Parents
No Data
Reply
  • 69832
    Offline posted

    You can't skip a level of the data hierarchy, so unless there is a DataRelation defined between the data in the which the invoice records reside and the one in which the names of people reside (e.g., "Tom Harden"), you can't. You should be able to use a SQL query to create a DataSet with one table that has the people's names and another with the invoice records, and define a relation between them, in effect skipping the "InvoiceRelationshipName" in the example given above.

    Note that the UltraTree.ColumnSettings.ShowBandNodes property allows you to hide the label nodes that are created for "bands", but I don't think that will help you here.

Children