Displaying items in a treeview from the database

Question

0.00/5 (No votes)

See more:

, +

Dear All,

I am generating the TreeView by the following code:

XML

<ul id="navigation" class="treeview">

            <asp:Repeater runat="server" ID="repeatGroups">
                <ItemTemplate>
                    <li><a href='Default.aspx?name=<%# Eval("GroupName") %>'><%# Eval("GroupName")%></a>

                        <asp:Repeater runat="server" ID="repeatCategory" DataSource='<%# Eval("Categories")%>' OnItemDataBound="repeatCategory_ItemDataBound">
                            <HeaderTemplate><ul></HeaderTemplate>
                            <ItemTemplate>
                                <li><a href='Default.aspx?name=<%# Eval("Name") %>'><%# Eval("Name") %></a>

                                    <asp:Repeater runat="server" ID="repeatItem" DataSource='<%# Eval("Items")%>'>
                                        <HeaderTemplate><ul></HeaderTemplate>
                                        <ItemTemplate>
                                            <li><a href='Default.aspx?name=<%# Eval("Name") %>'><%# Eval("Name")%></a></li>
                                        </ItemTemplate>
                                        <FooterTemplate></ul></FooterTemplate>
                                    </asp:Repeater>

                                </li>
                            </ItemTemplate>
                            <FooterTemplate></ul></FooterTemplate>
                        </asp:Repeater>

                    </li>
                </ItemTemplate>
            </asp:Repeater>

        </ul>

.cs code:

C#

protected void repeatCategory_ItemDataBound(object sender, RepeaterItemEventArgs e)
       {
           if (e.Item.DataItem != null)
           {
               //bind any products
               Repeater repeatItem = (Repeater)e.Item.FindControl("repeatItem");
               if (repeatItem != null)
                   repeatItem.Visible = (repeatItem.Items.Count > 0) ? true : false;

           }
       }

With the above code, I can display a Treeview by hardcoding the items into the Treeview using ArrayList. But, I want to access the items from the database(SQL Server) and display the same.

Can Any one suggest me how should be the structure of the table in my database?

Thanks & Regards

Posted 10-Nov-11 22:44pm

Raj.rcr

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Reiss · Answer 1 · 2011-11-10T23:12:00

One of the points of tiered application design is that the UI shouldn't care how the backend data is stored, your middle tier is reponsible for transforming the data into whatever format is required.

Your database should be designed so that logical entities are grouped in normalised tables not how it should be displayed to an end user.

Find a database design that fits the data and then transform it so that it can be presented to a user in your business logic tier.

Im my experience data models change less often than UI's as when more features are added at the front end they often don't require changes to the table structures - it is jsut cutting the data differently.

srinivas vadepally · Answer 2 · 2011-11-11T00:18:00

Solution 2

Hi raj,

Creating Treeview[^]

Posted 11-Nov-11 0:18am

srinivas vadepally

palraj001 · Answer 3 · 2011-11-11T03:24:00

Hi try with this,

  TreeNode pnode, cnode, dnode;
TreeNode pnode, cnode, dnode;
    view.Nodes.Clear();



   DataSet ds =sh.GetDataSet("SELECT   distinct  Table1.value1,Table1.value2 FROM         table2 INNER JOIN    Table1 ON table2.Section = Table1.value1");


   foreach(DataRow dr in ds.Tables[0].Rows)
   {

       pnode = new TreeNode();
       pnode.Text = dr["value2"].ToString();
       pnode.Value = dr["value1"].ToString();
       view.Nodes.Add(pnode);

       view.CollapseAll();


       DataSet ds1 = sh.GetDataSet("SELECT    distinct table2.SubSection FROM table2 INNER JOIN    Table1 ON table2.Section = Table1.value1  where Table1.value2 like '" + dr["value2"].ToString() + "'  ");
           foreach (DataRow dr1 in ds1.Tables[0].Rows)
           {

               cnode = new TreeNode();
               cnode.Text = dr1["SubSection"].ToString();
                 pnode.ChildNodes.Add(cnode);


               DataSet ds2 = sh.GetDataSet("SELECT    distinct  table2.value4,table2.value3  FROM         table2 INNER JOIN    Table1 ON table2.Section = Table1.value1  where Table1.value2 like '" + dr["value2"].ToString() + "' and table2.SubSection like '" + dr1["SubSection"].ToString() + "' ");
               foreach (DataRow dr2 in ds2.Tables[0].Rows)
               {


                   dnode = new TreeNode();
                   dnode.Text = dr2["value3"].ToString();
                   dnode.Value = dr2["value4"].ToString();
                   cnode.ChildNodes.Add(dnode);

               }
           }

regards,
Pal

Displaying items in a treeview from the database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0