Coolite 学习之三：TreePanel 绑定

 连接数据库动态加载树

public void TreeBind()
        {
            Exsql.Open();
            string sql = "select id,name from dbo.Tree where fid is null";
            SqlDataAdapter da = new SqlDataAdapter(sql, Exsql.conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "temp1");
            DataTable dt = ds.Tables[0];
            Coolite.Ext.Web.TreeNode root = new Coolite.Ext.Web.TreeNode("Root","Root",Icon.Application);
            TreePanel1.Root.Add(root);
          root.Checked = Coolite.Ext.Web.ThreeStateBool.False;
            root.Expanded = true;
            foreach (DataRow dr in dt.Rows)
            {
                string id=dr[0].ToString();
                string name = dr[1].ToString();
                Coolite.Ext.Web.TreeNode node = new Coolite.Ext.Web.TreeNode(id, id+"&"+name, Icon.Application);
                root.Nodes.Add(node);
              node.Checked = Coolite.Ext.Web.ThreeStateBool.False; //是否在节点前面加chenckbox
              node.Expanded = true;
                BindNode(id,node);
                          }

          
        }

        private void BindNode(string node,Coolite.Ext.Web.TreeNode Node)
        {
         
                string sql = "select * from Tree where fid='" +node + "'";
                SqlDataAdapter da = new SqlDataAdapter(sql, Exsql.conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "temp1");
                DataTable dt = ds.Tables[0];
              
                foreach (DataRow dr in dt.Rows)
                {
                    string id = dr[0].ToString();
                    string name = dr[1].ToString();
                    Coolite.Ext.Web.TreeNode node1 = new Coolite.Ext.Web.TreeNode(id, id+"&"+name, Icon.Application);
                    Node.Nodes.Add(node1);
                  //  node.Checked = Coolite.Ext.Web.ThreeStateBool.False;
                    node1.Checked = Coolite.Ext.Web.ThreeStateBool.False;
                    node1.Expanded = true; 
                    BindNode(id, node1);

                }

        }