ASP.NET

ASP.NET RSS

add nodes and subnodes to a treeview from sql database by coding in asp.net 2.0

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jan 2007

Posts: 16

Reputation: rinkuchoudhury is an unknown quantity at this point

Solved Threads: 0

rinkuchoudhury rinkuchoudhury is offline

Offline

Newbie Poster

add nodes and subnodes to a treeview from sql database by coding in asp.net 2.0

Mar 26th, 2007

hi
I have to add nodes and subnodes to a tree view from sql database in asp.net(VB.Net) 2.0

How to do this
i have 3 tables
i want to add nodes from first table and respective childnodes from the 2nd table subsiquent child nodes from the 3rd table

how to do this

•

Join Date: Jan 2006

Posts: 275

Reputation: f1 fan is an unknown quantity at this point

Solved Threads: 11

f1 fan

Offline

Posting Whiz in Training

Re: add nodes and subnodes to a treeview from sql database by coding in asp.net 2.0

Mar 26th, 2007

The easiest way is to write a query to select the data from all 3 tables and put them into a dataset with relationships.
Then you just have to iterate through the first table one row at a time and create a node for it. Then run through that rows child rows one at a time and create a node for them and add them to the parent node, and run through each of the child rows of those rows and do the same.
In pseudo code (as i am more a C# than Vb person)

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
..Create Dataset with 3 tables and 2 relationships
Create a top node
For each table1row in table1
Create table1node
Add it to topnode's node
for each table2row in table1row.getchildrows()
Create table2node
Add it to table1node
for each table3row in table2row.getchildrows()
Create table3node
end table3row for each
end table2row foreach
end table1row foreach
 
..Create Dataset with 3 tables and 2 relationships
Create a top node
For each table1row in table1
Create table1node
Add it to topnode's node
for each table2row in table1row.getchildrows()
Create table2node
Add it to table1node
for each table3row in table2row.getchildrows()
Create table3node
end table3row for each
end table2row foreach
end table1row foreach

•

Join Date: Jun 2009

Posts: 1

Reputation: bassam572009 is an unknown quantity at this point

Solved Threads: 0

bassam572009 bassam572009 is offline

Offline

Newbie Poster

Re: add nodes and subnodes to a treeview from sql database by coding in asp.net 2.0

Jul 20th, 2009

if you have sample in asp.net and use vb lang
pls
send me by e-mail
<EMAIL SNIPPED>

Last edited by peter_budo; Jul 20th, 2009 at 12:09 pm. Reason: Keep It On The Site - Do not post asking for an answer to be sent to you via email or PM.