Question

treeview怎么绑定数据库里的数据呢

Answer 1

ParentIDFromCateTableOrder ByCateID,RootID,ParentIDEND代码：private void MainForm_Load(object sender, EventArgs e){//从数据库中读取数据 SqlConnection con = new SqlConnection(ConnString.ConStr); SqlCommand cmd = new SqlCommand("CateTable_GetList", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet();try{sda.Fill(ds);}catch{}finally{cmd = null; con.Close();}//往TreeView中添加树节点 //添加根节点 TreeNode tn = new TreeNode(); tn.Text = "种类"; tn.Name = "0";//Name作为ID tn.Tag = "0";//Tag作为RootID tn.ImageIndex = 0; tn.SelectedImageIndex = 0; tv.Nodes.Add(tn);//该TreeView命名为tv tv.SelectedNode = tv.TopNode; //把其他节点加上去 if (ds != null){foreach (DataRow dr in ds.Tables[0].Rows){tn = new TreeNode(); tn.Text = dr["CateName"].ToString(); tn.Name = dr["CateID"].ToString();//Name作为CateID tn.Tag = dr["RootID"].ToString();//Tag作为RootID tn.ImageIndex = 1; tn.SelectedImageIndex = 1; //判断是否为主节点 if (dr["CateID"].ToString() == dr["RootID"].ToString()){//主节点tv.SelectedNode = tv.TopNode;}else{//其他节点if (tv.SelectedNode.Name != dr["ParentID"].ToString()){TreeNode[] tn_temp = tv.Nodes.Find(dr["ParentID"].ToString(), true);