一小段代码,现在我已经绑定了两张表的数据,如果有三张表该怎么绑定?搞了很久都没有搞出来。
  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);
                }
            }