I have a dataset containing two tables. One of the tables is the Customer table and the other one is the customer Purchases table. They have a one to many relationship; each customer can have more than one purchases.
I can't get the RadTreeView to dispay anything related to the Customer or Purchases
. They only thing the TreeView displays is the following: System.Data.DataViewManagerListTypeDescriptor. That looks like an error message!?
What am I doing wrong?
I've been struggling with this for an entire day; trying anythign under the sun.
I am using the newest RadTreeView control.
My datbase tables look as follows:
ID (autoincrement unique ID)
PurchasesID (autoincrement unique ID)
Customer_ID (foreign key to ID in Customer table)
In the tree view, the customer's purchases should show up underneath each customer's name.
Here is my code:
sender, EventArgs e)
DataSet ds =
SqlConnection mySqlConnection =
"Select * from Customer"
"Select * from Purchases"
SqlCommand sql_Customer =
SqlDataAdapter da =
da.SelectCommand.CommandText = strPurchases_Query;
// Add the relation. Maybe this is not needed because we use the RelationBindings of the RadTreeView
DataColumn parentCol = ds.Tables[
DataColumn childCol = ds.Tables[
, parentCol, childCol);
treeView1.DataSource = ds;