?? treeview.txt
字號:
private void fillmytree()
{
int i=-1;
int t=0;
rD_SQ_DataSet1.Merge(webser.RD_SQ_bowse());
ds.Merge(rD_SQ_DataSet1);
this.treeView1.ImageList=imageList2;
treeView1.Nodes.Clear();
treeView1.Nodes.Add(new TreeNode("標題說明"));
DataSet ds6 = webser.sqlquery(string.Format("select * from ZuZhi_Table where s_daim='{0}'", "001"), "TB");
foreach(DataRow dr in ds6.Tables["TB"].Rows)
{
i++;
int j = -1;//
treeView1.Nodes[t].Nodes.Add(new TreeNode("{" + dr["b_daim"].ToString() + "}" + dr["DZZ_mc"].ToString()));//
string dm = dr["b_daim"].ToString();
DataSet ds1 = webser.sqlquery(string.Format("select * from ZuZhi_Table where s_daim='{0}'", dm), "TB1");
foreach (DataRow dr1 in ds1.Tables["TB1"].Rows)
{
j++;
int r = -1;
treeView1.Nodes[0].Nodes[i].Nodes.Add(new TreeNode(dr1["b_daim"].ToString() + "|" + dr1["DZZ_mc"].ToString().Trim()));//父
string dm1 = dr1["b_daim"].ToString();
DataSet ds2 = webser.sqlquery(string.Format("select * from ZuZhi_Table where s_daim='{0}'", dm1), "TB2");
foreach (DataRow dr2 in ds2.Tables["TB2"].Rows)
{
r++;
int q = -1;
treeView1.Nodes[0].Nodes[i].Nodes[j].Nodes.Add(dr2["b_daim"].ToString().Trim() + "|" + dr2["DZZ_mc"].ToString().Trim());//
string dm2 = dr2["b_daim"].ToString();
DataSet ds3 = webser.sqlquery(string.Format("select * from ZuZhi_Table where s_daim='{0}'", dm2), "TB3");
foreach (DataRow dr3 in ds3.Tables["TB3"].Rows)
{
q++;
treeView1.Nodes[0].Nodes[i].Nodes[j].Nodes[r].Nodes.Add(dr3["b_daim"].ToString().Trim() + "|" + dr3["DZZ_mc"].ToString().Trim());//
string dm3 = dr3["b_daim"].ToString();
DataSet ds4 = webser.sqlquery(string.Format("select * from ZuZhi_Table where s_daim='{0}'", dm3), "TB4");
foreach (DataRow dr4 in ds4.Tables["TB4"].Rows)
{
treeView1.Nodes[0].Nodes[i].Nodes[j].Nodes[r].Nodes[q].Nodes.Add(dr4["b_daim"].ToString().Trim() + "|" + dr4["DZZ_mc"].ToString().Trim());//
}
}
}
}
}
treeView1.Nodes[0].Expand();
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -