一小段代码,现在我已经绑定了两张表的数据,如果有三张表该怎么绑定?搞了很久都没有搞出来。
SqlConnection con = new SqlConnection("server=.;database=SManageMent;integrated security=true;");
con.Open();
string sql="select * from departmenttb select * from classtb";
SqlDataAdapter sda=new SqlDataAdapter(sql,con);
DataSet ds=new DataSet();
sda.Fill(ds);
DataView dv = ds.Tables[1].DefaultView;
DataView dv2 = ds.Tables[2].DefaultView;
TreeNode root = new TreeNode("学生管理系统");
treeView1.Nodes.Add(root);
TreeNode node = new TreeNode("全部学生信息");
root.Nodes.Add(node);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode depart = new TreeNode(dr["departmentname"].ToString());
node.Nodes.Add(depart);
dv.RowFilter = "departmentNo=" + dr["departmentNo"].ToString();
foreach (DataRowView dgv in dv)
{
TreeNode cla = new TreeNode(dgv["className"].ToString());
depart.Nodes.Add(cla);
}
}
SqlConnection con = new SqlConnection("server=.;database=SManageMent;integrated security=true;");
con.Open();
string sql="select * from departmenttb select * from classtb";
SqlDataAdapter sda=new SqlDataAdapter(sql,con);
DataSet ds=new DataSet();
sda.Fill(ds);
DataView dv = ds.Tables[1].DefaultView;
DataView dv2 = ds.Tables[2].DefaultView;
TreeNode root = new TreeNode("学生管理系统");
treeView1.Nodes.Add(root);
TreeNode node = new TreeNode("全部学生信息");
root.Nodes.Add(node);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode depart = new TreeNode(dr["departmentname"].ToString());
node.Nodes.Add(depart);
dv.RowFilter = "departmentNo=" + dr["departmentNo"].ToString();
foreach (DataRowView dgv in dv)
{
TreeNode cla = new TreeNode(dgv["className"].ToString());
depart.Nodes.Add(cla);
}
}
兄弟,参考我2年前写的代码。
http://hi.baidu.com/chengzq11/blog/item/e14ca88bc9fa841ec9fc7a30.html