TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
pradeep sharma
NA
34
10.8k
TreeView implementation in ASP.NET with SQL Server 2005
Oct 14 2009 1:38 AM
TreeView implementation in ASP.NET with SQL Server 2005 Step-1 Go to ToolBox ->click on treeView and drag it on your .aspx page
Step-2 Open Sql Server 2005 and create two tables tsRoute- CREATE TABLE [dbo].[tsRoute] ( [rid] [int] IDENTITY(1,1) NOT NULL, [routeID] [varchar](50), [startPoint] [varchar](50) ) tsRouteDetails CREATE TABLE [dbo].[tsRouteDetails]( [routedetailsid] [int] IDENTITY(1,1) NOT NULL, [routeid] [varchar](50), [picupsPoint] [varchar](100) Step-3 Open aspx.cs using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using DAL4Portal; public partial class Transport_TreeViewdemo : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fillRouteTree(); } } private void fillRouteTree() { SqlConnection con = null; con = new SqlConnection(); con = DAL.GetConnection(); con.Open(); int parentRouteID = 0; string strQuery = "select * from tsRoute where routeid='ROUTE001'"; SqlCommand cmd = new SqlCommand(strQuery, con); SqlDataReader dr = cmd.ExecuteReader(); string[,] parentRouteNode = new string[1, 2]; int count = 0; while (dr.Read()) { parentRouteNode[count, 0] = dr["routeid"].ToString(); parentRouteNode[count++, 1] = dr["startPoint"].ToString(); } cmd.Dispose(); dr.Close(); //create node with parent node for (int loop = 0; loop < count; loop++) { TreeNode root = new TreeNode(); root.Text = parentRouteNode[loop, 1]; root.Target = "_blank"; // root.NavigateUrl = "TreeViewdemo.aspx"; string strChildQuery = "select * from tsRouteDetails where routeid= '"+ parentRouteNode[loop, 0]+"'"; cmd = new SqlCommand(strChildQuery, con); SqlDataReader childDr = cmd.ExecuteReader(); while (childDr.Read()) { TreeNode childRouteNode = new TreeNode(); childRouteNode.Text = childDr["picupsPoint"].ToString(); childRouteNode.Target = "_blank"; root.ChildNodes.Add(childRouteNode); //root.NavigateUrl = "TreeViewdemo.aspx"; } TreeView1.Nodes.Add(root); } TreeView1.CollapseAll(); TreeView1.CollapseImageUrl = ""; } } Step-4 Output Congratulations!!
Reply
Answers (
1
)
remove redundant data from database.
DataGridView Value in combo box change should change the value in text collumn in same datagridview