// 创建DataSet
DataSet myDataSet = new DataSet();
//string connStr = Properties.Resources.ConnectionString;
OleDbConnection conn = new OleDbConnection(_OLEDB);
DataTable[] myDataTables = new DataTable[3];
myDataTables[0] = new DataTable("MF_PSS");
myDataTables[1] = new DataTable("TF_PSS");
myDataTables[2] = new DataTable("TF_PSS_RCV");
//创建DataTable
myDataSet.Tables.Add(myDataTables[0]);
OleDbCommand cmd1 = new OleDbCommand(Constants.TxtSql, conn);
OleDbDataAdapter oleAdapter1 = new OleDbDataAdapter(cmd1);
oleAdapter1.Fill(myDataSet.Tables[0]);
//为Table 添加数据
myDataSet.Tables.Add(myDataTables[1]);
OleDbCommand cmd2 = new OleDbCommand(Constants.TxtSql1, conn);
OleDbDataAdapter oleAdapter2 = new OleDbDataAdapter(cmd2);
oleAdapter2.Fill(myDataSet.Tables[1]);
myDataSet.Tables.Add(myDataTables[2]);
OleDbCommand cmd3 = new OleDbCommand(Constants.TxtSql2, conn);
OleDbDataAdapter oleAdapter3 = new OleDbDataAdapter(cmd3);
oleAdapter3.Fill(myDataSet.Tables[2]);
//创建 “DataRelation”
DataRelation RelPSS = new DataRelation("TF_PSS_MF", myDataSet.Tables[0].Columns["PS_NO"],
myDataSet.Tables[1].Columns["PS_NO"]);
DataRelation RelRCV = new DataRelation("TF_PSS_RCV", myDataSet.Tables[0].Columns["PS_NO"],
myDataSet.Tables[2].Columns["PS_NO"]);
myDataSet.Relations.Add(RelPSS);
myDataSet.Relations.Add(RelRCV);
//返回从表数据
return myDataSet;
如上面这一段代码所示, 在我对你们提供的DEMO 进行拓展添加多一层的关系的时候, 在进行预览的时候 会显示是空白捞不出来数据~ 是否是我这边有什么问题呢? |