关键代码
父表
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);
联系客服