想要清除树视图并将另一个数据库绑定一次 [英] Want to clear the tree view and bind the same database another once

问题描述

嗨兄弟姐妹我是这个领域的初学者所以请帮助我我已经将数据库绑定到树视图但是我想要清除树视图并将另一个数据库绑定到另一个我怎么能请帮助我

i使用它但它不起作用...



TreeView1.Attributes.Clear（）;





代码是

  public   void  loadtreeview（ string  connection）
 {
 FirstMiniProject.FirstMiniProject f =  new  FirstMiniProject.FirstMiniProject（connection）; 
  string  sql =  string  .Format（   SELECT name FROM sys.databases WHERE name NOT IN（'master'，'tempdb'，'model'，'msdb'））; 
 DataTable tab =  new  DataTable（）; 
 tab = f.loadtable（sql）; 
  for （ int  i =  0 ; i <  tab.Rows.Count; i ++）
 {
  string  root = tab.Rows [i] [  name]。ToString（）; 
 TreeView1.Nodes.Add（ new  TreeNode（root））; 
  string  sql1 =  string  .Format（   USE {0} SELECT name FROM sys.Tables，root）; 
 DataTable tab1 =  new  DataTable（）; 
 tab1 = f.loadtable（sql1）; 
  for （ int  j =  0 ; j <  tab1.Rows.Count; j ++）
 {
  string  child = tab1.Rows [j] [  name]。ToString（）; 
 TreeView1.Nodes [i] .ChildNodes.Add（ new  TreeNode（child））; 
} 
 
} 
} 

i想要清除树视图后我将再次调用此函数bind ;;;;

解决方案

http://social.msdn.microsoft.com/Forums/en/csharplanguage/thread/acc55693-214c-4825-a26b-6aed00c195f6 [ ^ ]

绑定数据通过这篇文章



C＃中的数据绑定TreeView [ ^ ]



并清除

 TreeView1.Nodes.Clear（）

hi brothers and sisters i am beginner in this field so please help me i am already binded the database to the tree view but i Want to clear the tree view and bind the same database another once how can i do please help me
i use this but it doesn''t work...

TreeView1.Attributes.Clear();


code is

public void loadtreeview(string connection)
        {
            FirstMiniProject.FirstMiniProject f = new FirstMiniProject.FirstMiniProject(connection);
            string sql = string.Format("SELECT name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')");
            DataTable tab = new DataTable();
            tab = f.loadtable(sql);
            for (int i = 0; i < tab.Rows.Count; i++)
            {
                string root = tab.Rows[i]["name"].ToString();
                TreeView1.Nodes.Add(new TreeNode(root));
                string sql1 = string.Format("USE {0} SELECT name FROM sys.Tables", root);
                DataTable tab1 = new DataTable();
                tab1 = f.loadtable(sql1);
                for (int j = 0; j < tab1.Rows.Count; j++)
                {
                    string child = tab1.Rows[j]["name"].ToString();
                    TreeView1.Nodes[i].ChildNodes.Add(new TreeNode(child));
                }

            }
        }

i want to clear the tree view after that i will call this function once again to bind;;;;

解决方案

http://social.msdn.microsoft.com/Forums/en/csharplanguage/thread/acc55693-214c-4825-a26b-6aed00c195f6[^]

to bind data go through this article

Data Binding TreeView in C#[^]

and to clear

TreeView1.Nodes.Clear()

这篇关于想要清除树视图并将另一个数据库绑定一次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！