c#TreeView

 

 private void button2_Click(object sender, System.EventArgs e)
  {
  
   string file=Application.StartupPath + "//datamining//dm.mdb";
   connString = "Provider=Microsoft.jet.OLEDB.4.0;data source="+file;
  
   //OleDbConnection cnn = new OleDbConnection(connString);
   conn=new OleDbConnection(connString);
   conn.Open();
   OleDbDataAdapter adapter=new OleDbDataAdapter("select * from test",connString);
   DataSet ds=new DataSet();
   adapter.Fill(ds,"one");
  
  
   this.treeView1.Nodes.Add ("grandpa");
   Loadchild (this.treeView1.Nodes[0],ds,"grandpa");
  }
  private void Loadchild(TreeNode tn,DataSet ds,string mine)//ds includes all the data in the table.
   {
   DataRow[] drs= ds.Tables[0].Select("pkey='" + mine + "'");
   for(int i=0;i<drs.Length;i++)
   {
   string getvstr =drs[i]["vstr"].ToString();
   //string getpkey=drs[i]["pkey"].ToString();
   string getckey=drs[i]["ckey"].ToString();
   tn.Nodes.Add (getvstr);
  
   if (ds.Tables[0].Select("pkey='" + getckey + "'").Length>0)
   {
   drs= ds.Tables[0].Select("pkey='" + mine + "'");
   Loadchild (tn.Nodes[i],ds,getckey );
   }
   }
   }