想要清除树视图并将另一个数据库绑定一次 [英] 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屋!
查看全文