TreeView连接数据

 

        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source='" + HttpContext.Current.Server.MapPath("~/LHB_DataBase/rss.mdb") + "';Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
        OleDbConnection cn = new OleDbConnection();
        OleDbCommand cmd = new OleDbCommand();

        private void TreeViewOpeartor()
        ...{
            this.TreeView1.Nodes.Clear();
            string OledbString = "select * from categories ";
            DataTable rss_Url = this.GetRss_Url();
            cn.ConnectionString = connectionString;
            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = OledbString;
            OleDbDataReader dda = cmd.ExecuteReader();
            while(dda.Read())
            ...{
                TreeNode theNode = new TreeNode ();
                theNode.Text = dda["categoryname"].ToString();
                theNode.NodeData = dda["ID"].ToString();
                this.TreeView1.Nodes.Add(theNode);
                DataRow[] urls = rss_Url.Select("categoryID=" + dda["ID"].ToString());
                for(int i = 0 ; i < urls.Length ; i++)
                ...{
                    Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
                    node.Text = urls[i]["Rss_name"].ToString();
                    node.Target = urls[i]["Id"].ToString();
                    node.NodeData = urls[i]["ID"].ToString();
                    theNode.Nodes.Add(node);
                }
            }
            dda.Close();
            cn.Close();
        }

    
        private DataTable GetRss_Url()
        ...{
            cn.ConnectionString = connectionString ;
            OleDbDataAdapter dda = new OleDbDataAdapter("select * from rss where releasetoweb=1 ",cn);
            DataTable dt = new DataTable();
            dda.Fill(dt);
            return dt;
        }