string constr = "server=.;database=TongYong;user ID=sa;password=sa;";
SqlConnection conn = new SqlConnection(constr);
string sql = "select name from sysobjects where xtype ='U'";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataSet resultDS = new DataSet();
adapter.Fill(resultDS, "sysobject");
foreach (DataRow row in resultDS .Tables["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.Value = row["Name"].ToString();
tn.Text = row["Name"].ToString();
TreeView1.Nodes.Add(tn);
foreach (DataColumn col in resultDS.Tables[row["Name"].ToString()].Columns)
{
TreeNode subtn = new TreeNode();
subtn.Value = col.ColumnName;
subtn.Text = col.ColumnName;
tn.Nodes.Add(subtn);
}
} tn.Nodes.Add(subtn);//就是这句
最后一句出错了,“System.Web.UI.WebControls.TreeNode”并不包含“Nodes”的定义
就是两级的
SqlConnection conn = new SqlConnection(constr);
string sql = "select name from sysobjects where xtype ='U'";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataSet resultDS = new DataSet();
adapter.Fill(resultDS, "sysobject");
foreach (DataRow row in resultDS .Tables["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.Value = row["Name"].ToString();
tn.Text = row["Name"].ToString();
TreeView1.Nodes.Add(tn);
foreach (DataColumn col in resultDS.Tables[row["Name"].ToString()].Columns)
{
TreeNode subtn = new TreeNode();
subtn.Value = col.ColumnName;
subtn.Text = col.ColumnName;
tn.Nodes.Add(subtn);
}
} tn.Nodes.Add(subtn);//就是这句
最后一句出错了,“System.Web.UI.WebControls.TreeNode”并不包含“Nodes”的定义
就是两级的
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货