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 );
}
}
}
{
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 );
}
}
}