主从表

关键代码
父表
SqlDataAdapter sda = new SqlDataAdapter();
            SqlCommand cmd = new SqlCommand(strSQL, myConn);
            sda.SelectCommand = cmd;
            sda.Fill(ds, "Parents");
子表
 SqlDataAdapter sda2 = new SqlDataAdapter();
            SqlCommand cmd2 = new SqlCommand(strSQL2, myConn);
            sda2.SelectCommand = cmd2;
            sda2.Fill(ds, "Sons");
建立关系
System.Data.DataRelation dataRelation;
            System.Data.DataColumn dataColumn1;
            System.Data.DataColumn dataColumn2;

            dataColumn1 = ds.Tables["Parents"].Columns["YBID"];//设定表关系
            dataColumn2 = ds.Tables["Sons"].Columns["标准样板ID"];
            dataRelation = new System.Data.DataRelation("ParentsSons", dataColumn1, dataColumn2);