C# 里TreeView绑定数据库实现分类

《C# 里TreeView绑定数据库实现分类》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、C#里TreeView绑定数据库实现分类分类：导航控件TreeView/Menu/SiteMapPath2010-03-2221:3345人阅读评论(0)收藏举报codes=c#]//从数据库中读取数据           SqlConnectioncon=newSqlConnection("server=127.0.0.1//sqlexpress;uid=sa;");           con.Open();           con.ChangeDatabase("STggggg");      

2、     SqlCommandcmd=newSqlCommand("select*from产品树whereNodeType='f'",con);           //cmd.CommandType=CommandType.StoredProcedure;           SqlDataAdaptersda=newSqlDataAdapter(cmd);           DataSetds=newDataSet();           try           {              

3、 sda.Fill(ds);           }           catch           {           }           finally           {               cmd=null;               con.Close();           }           //往TreeView中添加树节点           //添加根节点           TreeNodetn=newTreeNode();           tn.

4、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;           //把其他节点加上去          

5、 if(ds!=null)           {[/codes][codes=c#]               foreach(DataRowdrinds.Tables[0].Rows)               {                   tn=newTreeNode();                   tn.Text=dr["Product"].ToString();                   tn.Name=dr["CateID"].ToString();//Nam

6、e作为CateID                   tn.Tag=dr["RootID"].ToString();//Tag作为RootID                   tn.ImageIndex=1;                   tn.SelectedImageIndex=1;                   //判断是否为主节点                   if(dr["CateID"].ToString()==dr["RootID"].ToString())     

7、              {                       //主节点                       tv.SelectedNode=tv.TopNode;                   }                   else                   {                       //其他节点                       if(tv.SelectedNode.Name!=dr["ParentID"].ToStrin

8、g())                       {                           TreeNode[]tn_temp=tv.Nodes.Find(dr["ParentID"].ToString(),true);//通过ParentID查找父节点                           if(tn_temp.Length>0)                           {