Click here to Skip to main content
12,452,240 members (53,292 online)
Click here to Skip to main content
Add your own
alternative version

Stats

86.7K views
33 bookmarked
Posted

How to load data from database to TreeView

, 21 Mar 2008 CPOL
Rate this:
Please Sign up or sign in to vote.
How to load data from database to TreeView

Introduction

How to load data from database into the Treeview control

1-Create two table as show below

Table ParentTable

Table1.jpg

ChildTable

Table2.jpg

2-Add some data

ParentTable

Table3.jpg

ChildTable

Table4.jpg

Drag and drap a TreeView control on the web page

As show below

Image1.jpg

3-Copy the below listed code in the aspx.cs page

//Code Detail          
protected void Page_Load(object sender, EventArgs e)

{

fill_Tree2();

}
        

void fill_Tree2()

{



DataSet PrSet = PDataset("Select * from ParentTable");

TreeView1.Nodes.Clear();

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

{

TreeNode tnParent = new TreeNode();

tnParent.Text = dr["ParentName"].ToString();

tnParent.Value = dr["ParentID"].ToString(); 

tnParent.PopulateOnDemand = true;

tnParent.ToolTip = "Click to get Child";

tnParent.SelectAction = TreeNodeSelectAction.SelectExpand;

tnParent.Expand();

tnParent.Selected = true;

TreeView1.Nodes.Add(tnParent);

FillChild(tnParent, tnParent.Value);

}

 

}

public void FillChild(TreeNode parent,string ParentId)

{

DataSet ds = PDataset("Select * from ChildTable where ParentId =" + ParentId);

parent.ChildNodes.Clear();

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

{

TreeNode child = new TreeNode();

child.Text = dr["ChildName"].ToString().Trim();

child.Value = dr["ChildId"].ToString().Trim();

if (child.ChildNodes.Count == 0)

{

child.PopulateOnDemand = true;

}

child.ToolTip = "Click to get Child";

child.SelectAction = TreeNodeSelectAction.SelectExpand;

child.CollapseAll();

parent.ChildNodes.Add(child);

}

}

 

protected DataSet PDataset(string Select_Statement)

{

SqlConnection SqlCon = new SqlConnection("Data Source=;Integrated Security=True");

SqlDataAdapter ad = new SqlDataAdapter(Select_Statement, SqlCon);

DataSet ds = new DataSet();

ad.Fill(ds);

return ds;

 

}

Image2.jpg

Points of Interest

Learn new control

History

Keep a running update of any changes or improvements you've made here.

License

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

Share

About the Author

T.Ashraf
Chief Technology Officer Compuacademy.net
United States United States
More than 15 years of experience in design, architecture and development of various commercial objects oriented application.Other Specialties

Data Migration:
• MS Access database to SQL 2005/2008
• MS Access database to Oracle
• MS Access database to My SQL
• FoxPro to SQL

Application Migration:
• Converted MS Access application to .net web application (Asp.net)
• Excel Application to .net 3.5 web application
• FoxPro application to .net 3.5
Reporting development and support
• MS access reports
• Crystal reports
• SQL Reports(SSRS)
• DevExpress reports
• Cognos reports
Application development and support
• .net Application web /Win forms
• SharePoint
• MS Access
• Website
• Ecommerce
• WCF
• Web Services
3rd Party Control Support
• DevExpress
• .netForum
• Telerik
Version controls Support
• Team Foundation Server
• Source Safe
• CVS
• SVN

You may also be interested in...

Pro
Pro

Comments and Discussions

 
Questiongetting treeview control items Pin
sowjnaya21-Mar-12 2:52
membersowjnaya21-Mar-12 2:52 
AnswerRe: getting treeview control items Pin
T.Ashraf3-May-12 14:07
memberT.Ashraf3-May-12 14:07 
GeneralMy vote of 5 Pin
amit sopan Roman27-Feb-12 0:52
memberamit sopan Roman27-Feb-12 0:52 
GeneralGetting error Pin
mrkeivan9-May-10 22:46
membermrkeivan9-May-10 22:46 
GeneralRe: Getting error Pin
T.Ashraf10-May-10 0:20
memberT.Ashraf10-May-10 0:20 
GeneralHelp Me! Pin
Say Vanden25-May-09 22:14
memberSay Vanden25-May-09 22:14 
GeneralRe: Help Me! Pin
T.Ashraf26-May-09 0:10
memberT.Ashraf26-May-09 0:10 
GeneralRe: Help Me! Pin
Say Vanden26-May-09 15:29
memberSay Vanden26-May-09 15:29 
GeneralRe: Help Me! Pin
T.Ashraf11-Jan-10 7:36
memberT.Ashraf11-Jan-10 7:36 
GeneralSorry, but I have to vote this down Pin
achimera22-Mar-08 14:12
memberachimera22-Mar-08 14:12 
GeneralRe: Sorry, but I have to vote this down Pin
T.Ashraf22-Mar-08 22:37
memberT.Ashraf22-Mar-08 22:37 
GeneralTree-Like DataBase Table... Pin
Sergey Alexander Gynech21-Mar-08 7:34
memberSergey Alexander Gynech21-Mar-08 7:34 
GeneralRe: Tree-Like DataBase Table... Pin
T.Ashraf21-Mar-08 7:43
memberT.Ashraf21-Mar-08 7:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160826.1 | Last Updated 21 Mar 2008
Article Copyright 2008 by T.Ashraf
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid