I am new to C#/ASP.Net. and I have a project now that involves binding a tree from two SQL Table. I've done some home work.. and I was able to bind my tree. first here are my tables. My goal is to group my child to it's corresponding parent. but what happens is it the child goes into all the parents. I know i am almost there but i got stuck. 
\[code\]tblCategory(parentnodes)categoryID(varchar(20))Category(varchar(50))active(char(1))tblDocuments(childnodes)id(int)description(varchar(100))title(varchar(20))categoryid(varchar(20))tblcategory.categoryid = tbldocuments.categoryid\[/code\]here are my codes.\[code\] protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //bindtree DataTable dtCategoryNodes = new DataTable(); dtCategoryNodes = content.dtCategoryNodes(); dtCategoryNodes.AcceptChanges(); DataTable dtNodes = new DataTable(); dtNodes = content.GetNodes(); dtNodes.AcceptChanges(); TreeNode CategoryNode = null; for (int i = 0; i < dtCategoryNodes.Rows.Count; i++) { string categoryid = dtCategoryNodes.Rows["CategoryID"].ToString(); CategoryNode = new TreeNode(dtCategoryNodes.Rows "CATEGORY"].ToString()); CategoryNode.Collapse(); for (int j = 0; j < dtNodes.Rows.Count; j++) { string parentid = dtNodes.Rows[j]["parentid"].ToString(); TreeNode childNode = new TreeNode(dtNodes.Rows[j]["TITLE"].ToString()); CategoryNode.ChildNodes.Add(childNode); } tvContents.Nodes.Add(CategoryNode); tvContents.DataBind(); } } } \[/code\]but i had a problem here. here is what happened to my tree.\[code\]a. Crift Items a.1Configuring DCOM b.Internal Refresher Trainings b.1Configuring DCOM c. Product/Process Update c.1 Configuring DCOM d.Promotions/Discounts d.1 Configuring DCOM e.QA Update e.1 Configuring DCOM \[/code\]below is my data tbldocument id Title File CategoryID 1 Configuring DCOM DCOM.doc PRODUPDT\[code\]tblCategoryCategoryID Category activeCRIFT Crift Items YIRTRAIN Internal Refresher Trainings YPRODUPDT Product/Process Update YPROMODISCS Promotions/Discounts YQAUPDT QA Update Y\[/code\]Appreciate all comments and suggestions! Thanks in advance!
\[code\]tblCategory(parentnodes)categoryID(varchar(20))Category(varchar(50))active(char(1))tblDocuments(childnodes)id(int)description(varchar(100))title(varchar(20))categoryid(varchar(20))tblcategory.categoryid = tbldocuments.categoryid\[/code\]here are my codes.\[code\] protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //bindtree DataTable dtCategoryNodes = new DataTable(); dtCategoryNodes = content.dtCategoryNodes(); dtCategoryNodes.AcceptChanges(); DataTable dtNodes = new DataTable(); dtNodes = content.GetNodes(); dtNodes.AcceptChanges(); TreeNode CategoryNode = null; for (int i = 0; i < dtCategoryNodes.Rows.Count; i++) { string categoryid = dtCategoryNodes.Rows["CategoryID"].ToString(); CategoryNode = new TreeNode(dtCategoryNodes.Rows "CATEGORY"].ToString()); CategoryNode.Collapse(); for (int j = 0; j < dtNodes.Rows.Count; j++) { string parentid = dtNodes.Rows[j]["parentid"].ToString(); TreeNode childNode = new TreeNode(dtNodes.Rows[j]["TITLE"].ToString()); CategoryNode.ChildNodes.Add(childNode); } tvContents.Nodes.Add(CategoryNode); tvContents.DataBind(); } } } \[/code\]but i had a problem here. here is what happened to my tree.\[code\]a. Crift Items a.1Configuring DCOM b.Internal Refresher Trainings b.1Configuring DCOM c. Product/Process Update c.1 Configuring DCOM d.Promotions/Discounts d.1 Configuring DCOM e.QA Update e.1 Configuring DCOM \[/code\]below is my data tbldocument id Title File CategoryID 1 Configuring DCOM DCOM.doc PRODUPDT\[code\]tblCategoryCategoryID Category activeCRIFT Crift Items YIRTRAIN Internal Refresher Trainings YPRODUPDT Product/Process Update YPROMODISCS Promotions/Discounts YQAUPDT QA Update Y\[/code\]Appreciate all comments and suggestions! Thanks in advance!