班级1
学生1
班级2
学生2
数据结果如下:
1 学校 0 0
102 班级1 1 0
103 班级2 1 0
102004 学生1 102 0
102005 学生2 102 0
103004 学生4 103 0
103005 学生5 103 0
private void BindTreeView()
{
int i = 0;
string sqlstr = db.GetConnectionString();
try
{
using (SqlConnection conn = new SqlConnection(sqlstr))
{
conn.Open();
SqlCommand comm = new SqlCommand("select * from Department", conn);
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
int j = 0;
//添加父节点
TreeView1.Nodes.Add(new TreeNode(reader[1].ToString(),reader[0].ToString()));
using (SqlConnection mycon = new SqlConnection(sqlstr))
{
mycon.Open();
SqlCommand mycom = new SqlCommand("select id,dutyName from duty where deptID = @deptID", mycon);
mycom.Parameters.Add("@deptID", reader[0].ToString());
SqlDataReader myreader = mycom.ExecuteReader();
while (myreader.Read())
{
//添加子节点
TreeView1.Nodes[i].ChildNodes.Add(new TreeNode(myreader[1].ToString(),myreader[0].ToString()));
using (SqlConnection sqlcon = new SqlConnection(sqlstr))
{
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand("select userID,username from userview where dutyID = @dutyID", sqlcon);
sqlcom.Parameters.Add("@dutyID", myreader[0].ToString());
SqlDataReader sqlreader = sqlcom.ExecuteReader();
while (sqlreader.Read())
{
TreeView1.Nodes[i].ChildNodes[j].ChildNodes.Add(new TreeNode(sqlreader[1].ToString(),sqlreader[0].ToString()));
}
}
j = j + 1;
}
}
i = i + 1;
}
}
this.TreeView1.CollapseAll();
this.TreeView1.ShowCheckBoxes = TreeNodeTypes.All;
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
这个treeview是2005下的