用TreeView读取数据库的一个表
要求在每个节点的子节点下面显示表的列和行
谁能帮我把下面的代码改改啊.... protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindTree();
}
} public void BindTree()
{
string con = "server=.;uid=sa;pwd=123456;database=pubs";
SqlConnection Conn = new SqlConnection(con);
SqlDataAdapter sqlda = new SqlDataAdapter("select * from titles", Conn);
DataSet ds = new DataSet();
sqlda.Fill(ds, "titles");
TreeNode t1 = new TreeNode();
TreeNode t2 = new TreeNode(); foreach (DataColumn c in ds.Tables[0].Columns)
{
t1.ChildNodes.Add(new TreeNode(c.Caption));
foreach (DataRow r in ds.Tables[0].Rows)
{
t2.ChildNodes.Add(new TreeNode(r[0].ToString()));
}
}
TreeView1.Nodes.Add(t1);
TreeView1.Nodes.Add(t2);
}
要求在每个节点的子节点下面显示表的列和行
谁能帮我把下面的代码改改啊.... protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindTree();
}
} public void BindTree()
{
string con = "server=.;uid=sa;pwd=123456;database=pubs";
SqlConnection Conn = new SqlConnection(con);
SqlDataAdapter sqlda = new SqlDataAdapter("select * from titles", Conn);
DataSet ds = new DataSet();
sqlda.Fill(ds, "titles");
TreeNode t1 = new TreeNode();
TreeNode t2 = new TreeNode(); foreach (DataColumn c in ds.Tables[0].Columns)
{
t1.ChildNodes.Add(new TreeNode(c.Caption));
foreach (DataRow r in ds.Tables[0].Rows)
{
t2.ChildNodes.Add(new TreeNode(r[0].ToString()));
}
}
TreeView1.Nodes.Add(t1);
TreeView1.Nodes.Add(t2);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货