多种方法进行treeview绑定数据库.docVIP

TreeView绑定数据库 数据库： 公司：id(int)???? company(varchar(50) 部门：id(int)???? deid(int)???? department(varchar(50)) 班组：id(int)???? coid(int)???? class(varchar(50)) 方法1： ? ????????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.Tables[department].Rows.Count;?j++)//循环?ds.Tables[de