/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.oleDbdacdEnvironmentalObservations_Groups = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.objdscdEnvironmentalObservations = new NBADWDataEntryApplication.dscdEnvironmentalObservations(); this.oleDbdatblEnvironmentalObservations = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand(); this.objdstblEnvironmentalObservations = new NBADWDataEntryApplication.dstblEnvironmentalObservations(); this.dvcdEnvironmentalObservations = new System.Data.DataView(); this.oleDbdacdEnvironmentalObservations = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.objdscdEnvironmentalObservations_Groups = new NBADWDataEntryApplication.dscdEnvironmentalObservations_Groups(); this.dvtblEnvironmentalObservations = new System.Data.DataView(); ((System.ComponentModel.ISupportInitialize)(this.objdscdEnvironmentalObservations)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblEnvironmentalObservations)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdEnvironmentalObservations)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdEnvironmentalObservations_Groups)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblEnvironmentalObservations)).BeginInit(); this.dgCurrentRecords.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgCurrentRecords_DeleteCommand); // // oleDbdacdEnvironmentalObservations_Groups // this.oleDbdacdEnvironmentalObservations_Groups.SelectCommand = this.oleDbSelectCommand1; this.oleDbdacdEnvironmentalObservations_Groups.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdEnvironmentalObservations", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("ObservationGroup", "ObservationGroup")})}); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT MIN(ObservationID) AS ObservationID, ObservationGroup FROM cdEnvironmental" + "Observations GROUP BY ObservationGroup ORDER BY MIN(ObservationID)"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // try { //this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Registry Path=;Data Source=""C:\Data_Warehouse\Tabular_Data\NBAquaticDataWarehouse_DW.mdb"";Jet OLEDB:System database=;Jet OLEDB:Global Bulk Transactions=1;User ID=Admin;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:SFP=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Engine Type=5;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Global Partial Bulk Ops=2;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Create System Database=False;Jet OLEDB:Database Locking Mode=1"; this.oleDbConnection1.ConnectionString = Session["ConnectionString"].ToString(); } catch(System.NullReferenceException) { Server.Transfer("Login.aspx"); } // objdscdEnvironmentalObservations // this.objdscdEnvironmentalObservations.DataSetName = "dscdEnvironmentalObservations"; this.objdscdEnvironmentalObservations.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdatblEnvironmentalObservations // this.oleDbdatblEnvironmentalObservations.DeleteCommand = this.oleDbDeleteCommand2; this.oleDbdatblEnvironmentalObservations.InsertCommand = this.oleDbInsertCommand2; this.oleDbdatblEnvironmentalObservations.SelectCommand = this.oleDbSelectCommand2; this.oleDbdatblEnvironmentalObservations.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblEnvironmentalObservations", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("EnvObservationID", "EnvObservationID"), new System.Data.Common.DataColumnMapping("FishPassageObstructionInd", "FishPassageObstructionInd"), new System.Data.Common.DataColumnMapping("Observation", "Observation"), new System.Data.Common.DataColumnMapping("ObservationGroup", "ObservationGroup"), new System.Data.Common.DataColumnMapping("ObservationSupp", "ObservationSupp"), new System.Data.Common.DataColumnMapping("PipeSize_cm", "PipeSize_cm")})}); this.oleDbdatblEnvironmentalObservations.UpdateCommand = this.oleDbUpdateCommand2; // // oleDbDeleteCommand2 // this.oleDbDeleteCommand2.CommandText = "DELETE FROM tblEnvironmentalObservations WHERE (EnvObservationID = ?)"; this.oleDbDeleteCommand2.Connection = this.oleDbConnection1; this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("EnvObservationID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EnvObservationID", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand2 // this.oleDbInsertCommand2.CommandText = "INSERT INTO tblEnvironmentalObservations(AquaticActivityID, FishPassageObstructio" + "nInd, Observation, ObservationGroup, ObservationSupp, PipeSize_cm) VALUES (?, ?," + " ?, ?, ?, ?)"; this.oleDbInsertCommand2.Connection = this.oleDbConnection1; this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishPassageObstructionInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishPassageObstructionInd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Observation", System.Data.OleDb.OleDbType.VarWChar, 50, "Observation")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationGroup")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationSupp", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationSupp")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("PipeSize_cm", System.Data.OleDb.OleDbType.Integer, 0, "PipeSize_cm")); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT AquaticActivityID, EnvObservationID, FishPassageObstructionInd, Observatio" + "n, ObservationGroup, ObservationSupp, PipeSize_cm FROM tblEnvironmentalObservati" + "ons"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbUpdateCommand2 // this.oleDbUpdateCommand2.CommandText = @"UPDATE tblEnvironmentalObservations SET AquaticActivityID = ?, FishPassageObstructionInd = ?, Observation = ?, ObservationGroup = ?, ObservationSupp = ?, PipeSize_cm = ? WHERE (EnvObservationID = ?) AND (AquaticActivityID = ? OR ? IS NULL AND AquaticActivityID IS NULL) AND (FishPassageObstructionInd = ?) AND (Observation = ? OR ? IS NULL AND Observation IS NULL) AND (ObservationGroup = ? OR ? IS NULL AND ObservationGroup IS NULL) AND (ObservationSupp = ? OR ? IS NULL AND ObservationSupp IS NULL) AND (PipeSize_cm = ? OR ? IS NULL AND PipeSize_cm IS NULL)"; this.oleDbUpdateCommand2.Connection = this.oleDbConnection1; this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishPassageObstructionInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishPassageObstructionInd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Observation", System.Data.OleDb.OleDbType.VarWChar, 50, "Observation")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationGroup")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationSupp", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationSupp")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("PipeSize_cm", System.Data.OleDb.OleDbType.Integer, 0, "PipeSize_cm")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EnvObservationID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EnvObservationID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FishPassageObstructionInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FishPassageObstructionInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Observation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Observation", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Observation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Observation", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationGroup", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationGroup1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationGroup", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationSupp", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationSupp", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationSupp1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationSupp", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PipeSize_cm", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PipeSize_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PipeSize_cm1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PipeSize_cm", System.Data.DataRowVersion.Original, null)); // // objdstblEnvironmentalObservations // this.objdstblEnvironmentalObservations.DataSetName = "dstblEnvironmentalObservations"; this.objdstblEnvironmentalObservations.Locale = new System.Globalization.CultureInfo("en-US"); // // dvcdEnvironmentalObservations // this.dvcdEnvironmentalObservations.Table = this.objdscdEnvironmentalObservations.cdEnvironmentalObservations; // // oleDbdacdEnvironmentalObservations // this.oleDbdacdEnvironmentalObservations.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbdacdEnvironmentalObservations.InsertCommand = this.oleDbInsertCommand1; this.oleDbdacdEnvironmentalObservations.SelectCommand = this.oleDbSelectCommand3; this.oleDbdacdEnvironmentalObservations.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdEnvironmentalObservations", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Observation", "Observation"), new System.Data.Common.DataColumnMapping("ObservationCategory", "ObservationCategory"), new System.Data.Common.DataColumnMapping("ObservationGroup", "ObservationGroup"), new System.Data.Common.DataColumnMapping("ObservationID", "ObservationID")})}); this.oleDbdacdEnvironmentalObservations.UpdateCommand = this.oleDbUpdateCommand1; // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = @"DELETE FROM cdEnvironmentalObservations WHERE (ObservationID = ?) AND (Observation = ? OR ? IS NULL AND Observation IS NULL) AND (ObservationCategory = ? OR ? IS NULL AND ObservationCategory IS NULL) AND (ObservationGroup = ? OR ? IS NULL AND ObservationGroup IS NULL)"; this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Observation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Observation", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Observation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Observation", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationCategory", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationCategory", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationCategory1", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationCategory", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationGroup", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationGroup1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationGroup", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = "INSERT INTO cdEnvironmentalObservations(Observation, ObservationCategory, Observa" + "tionGroup) VALUES (?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Observation", System.Data.OleDb.OleDbType.VarWChar, 50, "Observation")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationCategory", System.Data.OleDb.OleDbType.VarWChar, 40, "ObservationCategory")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationGroup")); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT Observation, ObservationCategory, ObservationGroup, ObservationID FROM cdE" + "nvironmentalObservations"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = @"UPDATE cdEnvironmentalObservations SET Observation = ?, ObservationCategory = ?, ObservationGroup = ? WHERE (ObservationID = ?) AND (Observation = ? OR ? IS NULL AND Observation IS NULL) AND (ObservationCategory = ? OR ? IS NULL AND ObservationCategory IS NULL) AND (ObservationGroup = ? OR ? IS NULL AND ObservationGroup IS NULL)"; this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Observation", System.Data.OleDb.OleDbType.VarWChar, 50, "Observation")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationCategory", System.Data.OleDb.OleDbType.VarWChar, 40, "ObservationCategory")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationGroup")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Observation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Observation", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Observation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Observation", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationCategory", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationCategory", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationCategory1", System.Data.OleDb.OleDbType.VarWChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationCategory", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationGroup", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ObservationGroup1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ObservationGroup", System.Data.DataRowVersion.Original, null)); // // objdscdEnvironmentalObservations_Groups // this.objdscdEnvironmentalObservations_Groups.DataSetName = "dscdEnvironmentalObservations_Groups"; this.objdscdEnvironmentalObservations_Groups.Locale = new System.Globalization.CultureInfo("en-US"); // // dvtblEnvironmentalObservations // this.dvtblEnvironmentalObservations.Table = this.objdstblEnvironmentalObservations.tblEnvironmentalObservations; ((System.ComponentModel.ISupportInitialize)(this.objdscdEnvironmentalObservations)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblEnvironmentalObservations)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvcdEnvironmentalObservations)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdEnvironmentalObservations_Groups)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblEnvironmentalObservations)).EndInit(); }
public void LoadDataSets() { // Create a new dataset to hold the records returned from the call to FillDataSet. // A temporary dataset is used because filling the existing dataset would // require the databindings to be rebound. NBADWDataEntryApplication.dscdEnvironmentalObservations_Groups objDataSetTemp1; NBADWDataEntryApplication.dscdEnvironmentalObservations objDataSetTemp2; NBADWDataEntryApplication.dstblEnvironmentalObservations objDataSetTemp3; objDataSetTemp1 = new NBADWDataEntryApplication.dscdEnvironmentalObservations_Groups(); objDataSetTemp2 = new NBADWDataEntryApplication.dscdEnvironmentalObservations(); objDataSetTemp3 = new NBADWDataEntryApplication.dstblEnvironmentalObservations(); try { // Attempt to fill the temporary dataset. this.FillDataSets(objDataSetTemp1, objDataSetTemp2, objDataSetTemp3); } catch (System.Exception eFillDataSet) { // Add your error handling code here. throw eFillDataSet; } try { // Empty the old records from the dataset. objdscdEnvironmentalObservations_Groups.Clear(); objdscdEnvironmentalObservations.Clear(); objdstblEnvironmentalObservations.Clear(); // Merge the records into the main dataset. objdscdEnvironmentalObservations_Groups.Merge(objDataSetTemp1); objdscdEnvironmentalObservations.Merge(objDataSetTemp2); objdstblEnvironmentalObservations.Merge(objDataSetTemp3); } catch (System.Exception eLoadMerge) { // Add your error handling code here. throw eLoadMerge; } }