------------------代码开始----------------------------------------------------------------------
DataSet ds = new DataSet();
string strConn = "User ID=system;Data Source=oracle09;Persist Security Info=True;Password=eport";
OracleConnection conn = new OracleConnection(strConn);
conn.Open();
OracleDataAdapter oda = new OracleDataAdapter("select * from offline_dec.USERINFO", conn);
oda.Fill(ds, "userInfo");
BindingSource bsmaster = new BindingSource();
OracleDataAdapter odaMembers = new OracleDataAdapter("select * from offline_dec.USERINFO_FAMILYMEMBERS", conn);
oda.Fill(ds, "memberInfo");
BindingSource bsSonsMembers = new BindingSource();
OracleDataAdapter odaPlaces = new OracleDataAdapter("select * from offline_dec.USERINFO_WORKPLACE", conn);
oda.Fill(ds, "placeInfo");
BindingSource bsSonsPlaces = new BindingSource();
conn.Close();
//添加约束 家庭成员
DataRelation drMembers = new DataRelation("家庭成员", ds.Tables["userInfo"].Columns["userid"], ds.Tables["memberInfo"].Columns["userid"]);
ds.Relations.Add(drMembers);
//工作地
DataRelation drPlaces = new DataRelation("工作地", ds.Tables["userInfo"].Columns["userid"], ds.Tables["placeInfo"].Columns["userid"]);
ds.Relations.Add(drPlaces);
bsmaster.DataSource = ds;
bsmaster.DataMember = "userInfo";
bsSonsMembers.DataSource = ds;
bsSonsMembers.DataMember = "memberInfo";
bsSonsPlaces.DataSource = ds;
bsSonsPlaces.DataMember = "placeInfo";
gridControl1.DataSource = ds.Tables["userInfo"];
-------------------代码结束--------------------------------------------------------------------------
//在YBID和BZYBID之间创建关系 System.Data.DataRelation dataRelation; System.Data.DataColumn dataColumn1; System.Data.DataColumn dataColumn2; dataColumn1 = ds.Tables["Parents"].Columns["YBID"];//设定表关系 dataColumn2 = ds.Tables["Sons"].Columns["BZYBID"]; dataRelation = new System.Data.DataRelation("ParentsSons", dataColumn1, dataColumn2); if (ds.Relations.Count == 0) { ds.Relations.Add(dataRelation); }