Bind Nested Tree view from database

• Download source files - 194 Kb

Introduction

This is an example of how to bind a nested tree from database.

Very Simple algorithm to bind tree.

method insertnodes is called recursively which will bind a nested tree at n level

create one table in access with following fields

module_id        integer

module_name   varchar(50)

parent_module    integer

place one treeview control, and call this method with first parameter null 

insertnodes(null,0);

private void insertnodes ( TreeNode n , int module_id )

OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\tree.mdb");

OleDbCommand cmd=new OleDbCommand( "SELECT * FROM [module] WHERE parent_module=" + module_id,con);

while(rdr.Read())

TreeNode t=new TreeNode(rdr["module_name"].ToString());

if(n==null)

else

}

source code is included which can be useful to understand the code 

regards,

ritesh