通过关系显示主从表

            //建立连接

            string connection = Properties.Settings.Default.学生成绩管理系统ConnectionString;
            SqlConnection con = new SqlConnection(connection);
            SqlDataAdapter adp = new SqlDataAdapter("select * from Student", con);
            DataSet dataSet = new DataSet();
            adp.Fill(dataSet, "Student");

            adp = new SqlDataAdapter("select * from Score", con);
            adp.Fill(dataSet, "Score");

            //添加关系

            DataRelation rel = new DataRelation("Student_Score", dataSet.Tables["Student"].Columns["StId"], dataSet.Tables["Score"].Columns["StId"]);
            dataSet.Relations.Add(rel);
            //MessageBox.Show(dataSet.Relations[0].ToString());

            //绑定数据
            bindingSource1.DataSource = dataSet;
            bindingSource1.DataMember = "Student";
          
            bindingSource2.DataSource =bindingSource1;
            bindingSource2.DataMember = "Student_Score";
           
            dataGridView1.DataSource = bindingSource1;
            dataGridView2.DataSource = bindingSource2;