111,126
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn = new SqlConnection (System.Configuration.ConfigurationManager.ConnectionStrings["infoConnectionString"].ConnectionString);
conn.Open();
SqlDataAdapter MyAdapter = new SqlDataAdapter("select * from person", conn);
DataSet ds = new DataSet();
MyAdapter.Fill(ds);
TreeView1.Nodes.Add(new TreeNode("父节点"));
TreeView1.ExpandDepth = 0;//第几个子节点开
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TreeView1.Nodes[0].ChildNodes.Add(new TreeNode(ds.Tables[0].Rows[i][0].ToString(), ds.Tables[0].Rows[i][1].ToString()));
}
TreeView1.DataBind();