请问，我要用C# winform的treeview动态绑定sql数据库

DataTable dt = new DataTable();
for (Int32 i = 0; i < dt.Columns; i++)
{
TreeNode tn = new TreeNode();
tn.Name = dt.Rows[i][0].ToString();
tn.Text = dt.Rows[i][1].ToString();
treeView1.Nodes.Add(tn);
}
要是无限添加的话就再加个方法就好了

这样就应该可以了。

string sql="select name from sysobject where xtype ='U'";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(resultDS, "sysobject");

foreach(DataRow row in resultDS.Talbes["sysobject"].Rows)
{
sql="Select top 1 * From "+row["Name"].ToString();
adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(resultDS, row["Name"].ToString());
TreeNode tn = new TreeNode();
tn.Name = row["Name"].ToString();
tn.Text = row["Name"].ToStr