OleDbConnection thisConnection = new OleDbConnection(
@"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =D:\tmp\stdreg32.mdb"); //Open connection object
thisConnection.Open(); //Create DataAdapter object for update and other opration
OleDbDataAdapter thisAdapter = new OleDbDataAdapter(
"SELECT CourseID,CourseTitle FROM Course", thisConnection); //Create CommandBuilder object to build SQl command
OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter); //Create DataSet to contain related data tables rows, and columns
DataSet thisDataSet = new DataSet(); //Create DataAdapter for each table and fill
OleDbDataAdapter CourseAdapter = new OleDbDataAdapter(
"SELECT * FROM Course", thisConnection); OleDbDataAdapter SectionAdapter = new OleDbDataAdapter(
"SELECT * FROM Pst", thisConnection);
CourseAdapter.Fill(thisDataSet, "Course");
SectionAdapter.Fill(thisDataSet, "Pst"); //Set up DataRelation between Course and Pst
System.Data.DataRelation CourseSectionRet = thisDataSet.Relations.Add("CoursePst",
thisDataSet.Tables["Course"].Columns["CourseID"],
thisDataSet.Tables["Pst"].Columns["CourseID"]);为什么在DataRelation这块出现错误,错误信息如下:未处理的“System.ArgumentException”类型的异常出现在 system.data.dll 中
其他信息:不能启用此约束,因为不是所有的值都具有相应的父值。请高手指点,谢谢
@"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =D:\tmp\stdreg32.mdb"); //Open connection object
thisConnection.Open(); //Create DataAdapter object for update and other opration
OleDbDataAdapter thisAdapter = new OleDbDataAdapter(
"SELECT CourseID,CourseTitle FROM Course", thisConnection); //Create CommandBuilder object to build SQl command
OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter); //Create DataSet to contain related data tables rows, and columns
DataSet thisDataSet = new DataSet(); //Create DataAdapter for each table and fill
OleDbDataAdapter CourseAdapter = new OleDbDataAdapter(
"SELECT * FROM Course", thisConnection); OleDbDataAdapter SectionAdapter = new OleDbDataAdapter(
"SELECT * FROM Pst", thisConnection);
CourseAdapter.Fill(thisDataSet, "Course");
SectionAdapter.Fill(thisDataSet, "Pst"); //Set up DataRelation between Course and Pst
System.Data.DataRelation CourseSectionRet = thisDataSet.Relations.Add("CoursePst",
thisDataSet.Tables["Course"].Columns["CourseID"],
thisDataSet.Tables["Pst"].Columns["CourseID"]);为什么在DataRelation这块出现错误,错误信息如下:未处理的“System.ArgumentException”类型的异常出现在 system.data.dll 中
其他信息:不能启用此约束,因为不是所有的值都具有相应的父值。请高手指点,谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货