SqlConnection con=new SqlConnection(@"server=wjs08;uid=sa;pwd=dw;database=whg;");
con.Open();
SqlDataAdapter Dta=new SqlDataAdapter("select * from ta",con);
//Dta.MissingSchemaAction=MissingSchemaAction.AddWithKey;
SqlDataAdapter Dtb=new SqlDataAdapter("select * from tb",con);
ds.EnforceConstraints=true;
Dta.Fill(ds,"tas");
Dtb.Fill(ds,"tbs");
DataRelation datarelationco=new DataRelation("datarelationco",ds.Tables["tas"].Columns["ID"],ds.Tables["tbs"].Columns["ID"]);
ds.Relations.Add(datarelationco);
dataGrid1.DataSource=ds.Tables["tas"].DefaultView;
con.Open();
SqlDataAdapter Dta=new SqlDataAdapter("select * from ta",con);
//Dta.MissingSchemaAction=MissingSchemaAction.AddWithKey;
SqlDataAdapter Dtb=new SqlDataAdapter("select * from tb",con);
ds.EnforceConstraints=true;
Dta.Fill(ds,"tas");
Dtb.Fill(ds,"tbs");
DataRelation datarelationco=new DataRelation("datarelationco",ds.Tables["tas"].Columns["ID"],ds.Tables["tbs"].Columns["ID"]);
ds.Relations.Add(datarelationco);
dataGrid1.DataSource=ds.Tables["tas"].DefaultView;