binding data in asp.net treeview control?

Question

I need a treeview structure like

Accounts-->Kmart-->California-->Stockton CA 95207
                             -->Oakdale, CA 95361

from this table

SCID    SCEID   SCElement   ParentID    Parent      SalesChannelName
67      27      Account     0           Root        Kmart
71      28      State       67          KMart       California
72      29      Store       71          California  Stockton CA 95207
74      29      Store       71          California  Oakdale, CA 95361

i tried a sample from this link http://aspalliance.com/732. It is working fine.But i dont know how to (write a query to) form a tree structure from this table in that sample code..Any suggestion?

Arion · Accepted Answer · 2012-03-05 14:28:17Z

1

Fill the data from the table two times with different tablenames.

Ex:

da.Fill(ds,"Table1");
da.Fill(ds,"Table2");

Now add a data relation in the dataset with the ID from the Table1 and ParentId from Table2

Now Bind to the treeview

Below link will help you.

http://joshsmithonwpf.wordpress.com/2007/05/05/binding-a-treeview-to-a-dataset/

This uses two tables from DB. But you can use the same table twice with small change in the SQL query

edited Mar 5, 2012 at 14:28

Arion

31.3k10 gold badges74 silver badges89 bronze badges

answered Mar 5, 2012 at 14:26

PraveenVenu

8,3674 gold badges32 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bala3569 Over a year ago

cannot download that demo project here it is blocked...can u download and send it to [email protected]

SeanCocteau · Accepted Answer · 2012-03-05 14:21:30Z

1

In order to 'bind' data to a treeview, it must be in the correct format for the treeview to digest. That is it must apply the IHierarchicalDataSource interface such as a formatted XML Document, etc.

Unfortunately when you grab your data from the database it is not going to be hierarchically formatted leaving you with two options...

Convert your data into an XMLDataSource and format / organise your data before binding to the treeview
Just as in the example, load the data into a DataTable and use a recursive function to add the nodes manually. I guess if you're looking for encapsulation you could inherit a new control from the existing treeview and add the method accordingly.

HTH

answered Mar 5, 2012 at 14:21

SeanCocteau

1,86619 silver badges25 bronze badges

Collectives™ on Stack Overflow

binding data in asp.net treeview control?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related