public void FillDataSets(NBADWDataEntryApplication.dsDE_ESAFSiteList dataSet1) { // Turn off constraint checking before the dataset is filled. // This allows the adapters to fill the dataset without concern // for dependencies between the tables. dataSet1.EnforceConstraints = false; try { // Open the connection. this.oleDbConnection1.Open(); // Attempt to fill the dataset through the OleDbDataAdapter1. this.oleDbdaDE_ESAFSiteList.Fill(dataSet1); } catch (System.Exception fillException) { // Add your error handling code here. throw fillException; } finally { // Turn constraint checking back on. dataSet1.EnforceConstraints = true; // Close the connection whether or not the exception was thrown. this.oleDbConnection1.Close(); System.IO.StringWriter sw1 = new System.IO.StringWriter(); // Write the DataSet to the ViewState property. dataSet1.WriteXml(sw1); ViewState["dSet1"] = sw1.ToString(); } }
public void FillDataSets(NBADWDataEntryApplication.dscdEnvironmentalObservations_Groups dataSet1, NBADWDataEntryApplication.dscdEnvironmentalObservations dataSet2, NBADWDataEntryApplication.dstblEnvironmentalObservations dataSet3) { // Turn off constraint checking before the dataset is filled. // This allows the adapters to fill the dataset without concern // for dependencies between the tables. dataSet1.EnforceConstraints = false; dataSet2.EnforceConstraints = false; dataSet3.EnforceConstraints = false; try { // Open the connection. this.oleDbConnection1.Open(); // Attempt to fill the dataset through the OleDbDataAdapter1. this.oleDbdacdEnvironmentalObservations_Groups.Fill(dataSet1); this.oleDbdacdEnvironmentalObservations.Fill(dataSet2); this.oleDbdatblEnvironmentalObservations.Fill(dataSet3); } catch (System.Exception fillException) { // Add your error handling code here. throw fillException; } finally { // Turn constraint checking back on. dataSet1.EnforceConstraints = true; dataSet2.EnforceConstraints = true; dataSet3.EnforceConstraints = true; // Close the connection whether or not the exception was thrown. this.oleDbConnection1.Close(); System.IO.StringWriter sw1 = new System.IO.StringWriter(); System.IO.StringWriter sw2 = new System.IO.StringWriter(); //System.IO.StringWriter sw3 = new System.IO.StringWriter(); // Write the DataSet to the ViewState property. dataSet1.WriteXml(sw1); dataSet2.WriteXml(sw2); //dataSet3.WriteXml(sw3); ViewState["dSet1"] = sw1.ToString(); ViewState["dSet2"] = sw2.ToString(); //ViewState["dSet3"] = sw3.ToString(); //tEO = objdstblEnvironmentalObservations.Tables["tblEnvironmentalObservations"]; } }