//绑定第一层树
OleDbConnection con = new OleDbConnection(DB.path);
con.Open();
OleDbCommand com = new OleDbCommand("select * from tbtree", con);
OleDbDataReader reader = com.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
TreeNode tn = new TreeNode();
tn.Text = reader[1].ToString();
tn.Value = reader[0].ToString();
//绑定第二层树
OleDbCommand com1 = new OleDbCommand("select * from tbtree", con);
OleDbDataReader reader1 = com1.ExecuteReader();
while (reader1.Read())
{
if (reader[0].Equals(reader1[2]))
{
TreeNode tn1 = new TreeNode();
tn1.Text = reader1[1].ToString();
tn1.Value = reader1[0].ToString();
// tn1.NavigateUrl = "ChanPinJieShaodh.aspx?id=" + reader1[0].ToString() + "";
//绑定第三层树
OleDbCommand com2 = new OleDbCommand("select * from tbtree", con);
OleDbDataReader reader2 = com2.ExecuteReader();
while (reader2.Read())
{
if (reader1[0].Equals(reader2[2]))
{
TreeNode tn2 = new TreeNode();
tn2.Text = reader2[1].ToString();
tn2.Value = reader2[0].ToString();
tn2.NavigateUrl = "ChanPinJieShaodh.aspx?id=" + reader2[0].ToString() + "";
//绑定第四层树
OleDbCommand com3 = new OleDbCommand("select * from tbtree", con);
OleDbDataReader reader3 = com3.ExecuteReader();
while (reader3.Read())
{
if (reader2[0].Equals(reader3[2]))
{
TreeNode tn3 = new TreeNode();
tn3.Text = reader3[1].ToString();
tn3.Value = reader3[0].ToString();
tn2.ChildNodes.Add(tn3);
// Response.Write(reader3[0].ToString());
tn3.NavigateUrl = "ChanPinJieShaodh.aspx?id=" + reader3[0].ToString() + "";
//绑定第五层树
OleDbCommand com4 = new OleDbCommand("select * from tbtree", con);
OleDbDataReader reader4 = com4.ExecuteReader();
while (reader4.Read())
{
if (reader3[0].Equals(reader4[2]))
{
TreeNode tn4 = new TreeNode();
tn4.Text = reader4[1].ToString();
tn4.Value = reader4[0].ToString();
tn3.ChildNodes.Add(tn4);
// Response.Write(reader3[0].ToString());
tn4.NavigateUrl = "ChanPinJieShaodh.aspx?id=" + reader4[0].ToString() + "";
}
}
}
}