TreeView绑定数据库.docVIP

数据库： 公司：id(int)???? company(varchar(50) 部门：id(int)???? deid(int)???? department(varchar(50)) 班组：id(int)???? coid(int)???? class(varchar(50)) 前台：略后台代码：DB DBManager = new DB();//实例化数据库操作类?? ??????? string strConn = System.Configuration.ConfigurationManager.ConnectionStrings[rizhi].ConnectionString;?? ??????? protected void Page_Load(object sender, EventArgs e)?? ??????? {?? ??????????? if (!IsPostBack)?? ??????????? {?? ??????????????? //TreeView1.Attributes.Add(onclick, OnTreeNodeChecked());?? ??????????????? TreeView1.Attributes.Add(onclick, testClick(event);return true;);//单击文字，CheckBox=true?? ??????????????? TreeView1.ShowCheckBoxes = TreeNodeTypes.Leaf;//最后一级选中?? ??????????????? TreeView1.ExpandDepth = 0;//不展开?? ??????????????? using (SqlConnection conn = new SqlConnection(strConn))?? ??????????????? {?? ??????????????????? DataSet ds_company = new DataSet();//实例化数据集（公司）?? ??????????????????? SqlDataAdapter sda_company = new SqlDataAdapter(select * from [company] where id+0+ and id+1001, conn);//实例化数据适配器（公司）?? ??????????????????? sda_company.Fill(ds_company, company);//虚拟表填充到内存?? ??????????????????? for (int i = 0; i ds_company.Tables[company].Rows.Count; i++)//循环所有公司?? ??????????????????? {?? ??????????????????????? TreeNode td_company = new TreeNode();//实例化公司节点?? ??????????????????????? td_company.Text = ds_company.Tables[company].Rows[i][company].ToString();//公司节点名称?? ??????????????????????? TreeView1.Nodes.Add(td_company);//将公司节点添加至树?? ??????????????????????? td_company.SelectAction = TreeNodeSelectAction.Expand;?? ??????????????????????? DataSet ds_department = new DataSet();//实例化数据集（部门）?? ??????????????????????? SqlDataAdapter sda_department = new SqlDataAdapter(select * from [department] where [coid]= + ds_company.Tables[company].Rows[i][id]+ and department全公司 , conn);//实例化数据库适配器（部门）?? ??????????????????????? sda_department.Fill(ds_department, department);//虚拟表填充到内存?? ??????????????????????? for (int j = 0; j ds_department.