Databases
StackOverflow2013
Postsdbo
POBinding ASP.NET TreeView Control to a Dataset
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBinding ASP.NET TreeView Control to a Dataset
    primarykey
    data
    text
    <p>In <a href="http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.treeview.aspx">MSDN</a> they say about TreeView control ("Binding to Data" paragraph):</p> <blockquote> <p>The TreeView control can also be bound to an XmlDocument object <strong>or a DataSet object with relations</strong>. To bind to one of these data sources, set the DataSource property of the TreeView control to the data source, and then call the DataBind method.</p> </blockquote> <p>So in a simple WebForms page with only a TreeView i wrote:</p> <pre><code> DataSet ds = new DataSet(); DataTable dt = new DataTable("Masters"); ds.Tables.Add(dt); dt.Columns.Add("MasterId", typeof(Int32)); dt.Columns.Add("Name", typeof(String)); DataTable dt1 = new DataTable("Details"); ds.Tables.Add(dt1); dt1.Columns.Add("DetailId", typeof(Int32)); dt1.Columns.Add("MasterId", typeof(Int32)); dt1.Columns.Add("Name", typeof(String)); DataRow rw; DataRow rw1; for (int i = 0; i &lt; 5; i++) { rw=dt.NewRow(); dt.Rows.Add(rw); rw["MasterId"] = i; rw["Name"] = "Master Name " + i.ToString(); for (int j = 0; j &lt; 10; j++) { rw1 = dt1.NewRow(); dt1.Rows.Add(rw1); rw1["DetailId"] = i * 5 + j; rw1["MasterId"] = i; rw1["Name"] = "Detail Name " + j.ToString() + " of Master Name "+ i.ToString(); } } ds.Relations.Add(new DataRelation("Masters_Details",dt.Columns["MasterId"], dt1.Columns["MasterId"])); TreeView1.DataSource = ds; TreeView1.DataBind(); </code></pre> <p>But in line where i set DataSource it throws exception:</p> <p><strong>HierarchicalDataBoundControl only accepts data sources that implement IHierarchicalDataSource or IHierarchicalEnumerable.</strong></p> <p>I understood this occurs because DataSet doesn't implement such interface ... so why did they write is possible to bind to a "DataSet with relations"? Thank you in advance</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAntonio Manello
    1. USAntonio Manello
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POBinding ASP.NET TreeView Control to a Dataset
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POBinding ASP.NET TreeView Control to a Dataset
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POBinding ASP.NET TreeView Control to a Dataset
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPossibly helpful: http://www.codeproject.com/Articles/25753/Binding-the-ASP-NET-TreeView-to-a-DataSet-or-an-Ob Although, it doesn't explain the language in the documentation.
      singulars
      1. POBinding ASP.NET TreeView Control to a Dataset
      1. This table or related slice is empty.
    2. COtks i read that article....and a lot of them where TreeView has populated node by node...but the key point of my question is **why** they say is possible in a native way.
      singulars
      1. POBinding ASP.NET TreeView Control to a Dataset
      1. USAntonio Manello
    3. COIn such a case on MSDN, I usually rate the topic unhelpful and then give an explanation of my reasoning or what should be there instead. ie: where's the example for that case, what's the closest you can come up with.
      singulars
      1. POBinding ASP.NET TreeView Control to a Dataset
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload