62,254
社区成员
发帖
与我相关
我的任务
分享
protected void bind_TreeView()
{
TreeNode tt = new TreeNode();
tt.Text = "所有学生信息(";
string sql = "select count(*) as total from student";
con.Open();
SqlDataReader dr = con.sqlreader(sql);
if (dr.Read()) tt.Text += dr["total"].ToString().Trim();
dr.Close();
tt.Text += ")";
if (this.TreeViewgl.Nodes.Count < 1)
TreeViewgl.Nodes.Add(tt);
string[] array = { "文科", "理科","综合", "文艺特长" };
for (int i = 0; i < array.Length; i++)
{
TreeNode one = new TreeNode();
one.Text = array[i].Trim() + "(";
sql = "select count(*) as ss from student where zb='" + array[i] + "'";
dr = con.sqlreader(sql);
if (dr.Read()) one.Text += dr["ss"].ToString().Trim();
dr.Close();
one.Text += ")";
tt.ChildNodes.Add(one);
}
con.Close();
}