Advertisement
sharpcoders

Populate TreeView from Database using C#

Jan 30th, 2014
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.69 KB | None | 0 0
  1.         public DataTable LoadDataTable(string RefId)
  2.         {
  3.             string cs = "Your Connection String Here"; //"server=SharpCoders;UID=sa;password=sa1223;database=POS";
  4.             string query = "SELECT * from Sales where ReferenceID ='" + RefId + "' order by CustomerID ASC ";
  5.             DataTable dataTable = new DataTable();
  6.             SqlDataAdapter dAdapter = new SqlDataAdapter(query, cs);
  7.             dAdapter.Fill(dataTable);
  8.             return dataTable;
  9.         }
  10.         public TreeView loadTreeMenu(TreeView tvMenu, DataTable dtSale)
  11.         {
  12.             if (dtSale.Rows.Count > 0)
  13.             {
  14.                 foreach (DataRow drRec in dtSale.Rows)
  15.                 {
  16.                     TreeNode ParentNode = new TreeNode();
  17.                     ParentNode.Text = drRec["CustomerNameSales"].ToString();
  18.                     tvMenu.Nodes.Add(ParentNode);
  19.                     loadTreeSubMenu(ref ParentNode, drRec["CustomerID"].ToString(), dtSale);
  20.                 }
  21.             }
  22.             return tvMenu;
  23.         }
  24.         private void loadTreeSubMenu(ref TreeNode ParentNode, string ParentId, DataTable dtSale)
  25.         {
  26.             DataTable dtChildRecords = this.LoadDataTable(ParentId);
  27.             foreach (DataRow dRow in dtChildRecords.Rows)
  28.             {
  29.                 TreeNode child = new TreeNode();
  30.                 child.Text = dRow["CustomerNameSales"].ToString();
  31.                 ParentNode.Nodes.Add(child);
  32.                 //Recursion
  33.                 loadTreeSubMenu(ref child, dRow["CustomerID"].ToString(), dtSale);
  34.             }
  35.         }
  36.         private void button5_Click(object sender, EventArgs e)
  37.         {
  38.             treeView1.Nodes.Clear();
  39.             loadTreeMenu(treeView1, LoadDataTable(textBox1.Text));
  40.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement