/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.dvSearchSites = new System.Data.DataView(); this.objdsSiteUseSearch = new NBADWDataEntryApplication.dsSiteUseSearch(); this.oleDbdacdAquaticActivity = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.objdscdAquaticActivity = new NBADWDataEntryApplication.dscdAquaticActivity(); this.oleDbdaSiteUseSearch = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbdaWatersheds = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.objdsWatersheds = new NBADWDataEntryApplication.dsWatersheds(); this.oleDbdaDE_Agencies = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand6 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand6 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_Agencies = new NBADWDataEntryApplication.dsDE_Agencies(); ((System.ComponentModel.ISupportInitialize)(this.dvSearchSites)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsSiteUseSearch)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdAquaticActivity)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsWatersheds)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Agencies)).BeginInit(); this.dgResults.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgResults_PageIndexChanged); this.dgResults.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgResults_EditCommand); this.dgResults.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.dgResults_SortCommand); // // oleDbConnection1 // try { //this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Registry Path=;Data Source=""C:\Data_Warehouse\Tabular_Data\DE-HRAA.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"); } // // dvSearchSites // this.dvSearchSites.Table = this.objdsSiteUseSearch._DE_SiteSearch; // // objdsSiteUseSearch // this.objdsSiteUseSearch.DataSetName = "dsSiteUseSearch"; this.objdsSiteUseSearch.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdacdAquaticActivity // this.oleDbdacdAquaticActivity.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbdacdAquaticActivity.InsertCommand = this.oleDbInsertCommand2; this.oleDbdacdAquaticActivity.SelectCommand = this.oleDbSelectCommand2; this.oleDbdacdAquaticActivity.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cdAquaticActivity", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"), new System.Data.Common.DataColumnMapping("AquaticActivity", "AquaticActivity")})}); this.oleDbdacdAquaticActivity.UpdateCommand = this.oleDbUpdateCommand1; // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = "DELETE FROM cdAquaticActivity WHERE (AquaticActivityCd = ?) AND (AquaticActivity " + "= ? OR ? IS NULL AND AquaticActivity IS NULL)"; this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivity", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivity", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivity1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivity", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand2 // this.oleDbInsertCommand2.CommandText = "INSERT INTO cdAquaticActivity(AquaticActivityCd, AquaticActivity) VALUES (?, ?)"; this.oleDbInsertCommand2.Connection = this.oleDbConnection1; this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivity", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivity")); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT AquaticActivityCd, AquaticActivity FROM cdAquaticActivity"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = "UPDATE cdAquaticActivity SET AquaticActivityCd = ?, AquaticActivity = ? WHERE (Aq" + "uaticActivityCd = ?) AND (AquaticActivity = ? OR ? IS NULL AND AquaticActivity I" + "S NULL)"; this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivity", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivity")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivity", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivity", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivity1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivity", System.Data.DataRowVersion.Original, null)); // // objdscdAquaticActivity // this.objdscdAquaticActivity.DataSetName = "dscdAquaticActivity"; this.objdscdAquaticActivity.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaSiteUseSearch // this.oleDbdaSiteUseSearch.InsertCommand = this.oleDbInsertCommand5; this.oleDbdaSiteUseSearch.SelectCommand = this.oleDbSelectCommand5; this.oleDbdaSiteUseSearch.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-SiteSearch", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"), new System.Data.Common.DataColumnMapping("AquaticActivity", "AquaticActivity"), new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"), new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"), new System.Data.Common.DataColumnMapping("AquaticSiteName", "AquaticSiteName"), new System.Data.Common.DataColumnMapping("AquaticSiteUseID", "AquaticSiteUseID"), new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"), new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"), new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"), new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"), new System.Data.Common.DataColumnMapping("WaterBodyName_Abrev", "WaterBodyName_Abrev")})}); // // oleDbInsertCommand5 // this.oleDbInsertCommand5.CommandText = "INSERT INTO [DE-SiteSearch] (AgencyCd, AgencySiteID, AquaticActivity, AquaticActi" + "vityCd, AquaticSiteID, AquaticSiteName, DrainageCd, WaterBodyID, WaterBodyName, " + "AquaticSiteDesc, WaterBodyName_Abrev) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand5.Connection = this.oleDbConnection1; this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivity", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivity")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 55, "WaterBodyName")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName_Abrev", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName_Abrev")); // // oleDbSelectCommand5 // this.oleDbSelectCommand5.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivity, AquaticActivityCd, AquaticSiteID," + " AquaticSiteName, AquaticSiteUseID, DrainageCd, WaterBodyID, WaterBodyName, Aqua" + "ticSiteDesc, WaterBodyName_Abrev FROM [DE-SiteSearch]"; this.oleDbSelectCommand5.Connection = this.oleDbConnection1; // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = "INSERT INTO [DE-SiteSearch] (AgencyCd, AgencySiteID, AquaticActivity, AquaticActi" + "vityCd, AquaticSiteID, AquaticSiteName, DrainageCd, WaterBodyID, WaterBodyName, " + "AquaticSiteDesc) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivity", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivity")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 55, "WaterBodyName")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarChar, 150, "AquaticSiteDesc")); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivity, AquaticActivityCd, AquaticSiteID," + " AquaticSiteName, AquaticSiteUseID, DrainageCd, WaterBodyID, WaterBodyName, Aqua" + "ticSiteDesc FROM [DE-SiteSearch]"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbdaWatersheds // this.oleDbdaWatersheds.InsertCommand = this.oleDbInsertCommand3; this.oleDbdaWatersheds.SelectCommand = this.oleDbSelectCommand3; this.oleDbdaWatersheds.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-Watersheds", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"), new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"), new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd")})}); // // oleDbInsertCommand3 // this.oleDbInsertCommand3.CommandText = "INSERT INTO [DE-Watersheds] (WaterBodyID, WaterBodyName, DrainageCd) VALUES (?, ?" + ", ?)"; this.oleDbInsertCommand3.Connection = this.oleDbConnection1; this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 55, "WaterBodyName")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT WaterBodyID, WaterBodyName, DrainageCd FROM [DE-Watersheds]"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // objdsWatersheds // this.objdsWatersheds.DataSetName = "dsWatersheds"; this.objdsWatersheds.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaDE_Agencies // this.oleDbdaDE_Agencies.InsertCommand = this.oleDbInsertCommand6; this.oleDbdaDE_Agencies.SelectCommand = this.oleDbSelectCommand6; this.oleDbdaDE_Agencies.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-Agencies", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("Agency", "Agency")})}); // // oleDbDeleteCommand2 // this.oleDbDeleteCommand2.CommandText = "DELETE FROM cdAgency WHERE (AgencyCd = ?) AND (Agency = ? OR ? IS NULL AND Agency" + " IS NULL)"; this.oleDbDeleteCommand2.Connection = this.oleDbConnection1; this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency1", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand4 // this.oleDbInsertCommand4.CommandText = "INSERT INTO cdAgency(Agency, AgencyCd) VALUES (?, ?)"; this.oleDbInsertCommand4.Connection = this.oleDbConnection1; this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd")); // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT Agency, AgencyCd FROM cdAgency"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbUpdateCommand2 // this.oleDbUpdateCommand2.CommandText = "UPDATE cdAgency SET Agency = ?, AgencyCd = ? WHERE (AgencyCd = ?) AND (Agency = ?" + " OR ? IS NULL AND Agency IS NULL)"; this.oleDbUpdateCommand2.Connection = this.oleDbConnection1; this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency1", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null)); // // oleDbSelectCommand6 // this.oleDbSelectCommand6.CommandText = "SELECT AgencyCd, Agency FROM [DE-Agencies]"; this.oleDbSelectCommand6.Connection = this.oleDbConnection1; // // oleDbInsertCommand6 // this.oleDbInsertCommand6.CommandText = "INSERT INTO [DE-Agencies] (AgencyCd, Agency) VALUES (?, ?)"; this.oleDbInsertCommand6.Connection = this.oleDbConnection1; this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarChar, 60, "Agency")); // // objdsDE_Agencies // this.objdsDE_Agencies.DataSetName = "dsDE_Agencies"; this.objdsDE_Agencies.Locale = new System.Globalization.CultureInfo("en-US"); ((System.ComponentModel.ISupportInitialize)(this.dvSearchSites)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsSiteUseSearch)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdscdAquaticActivity)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsWatersheds)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Agencies)).EndInit(); }
public void LoadCodeDataSet() { // 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.dsDE_Agencies objDataSetTemp1; NBADWDataEntryApplication.dscdAquaticActivity objDataSetTemp2; objDataSetTemp1 = new NBADWDataEntryApplication.dsDE_Agencies(); objDataSetTemp2 = new NBADWDataEntryApplication.dscdAquaticActivity(); try { // Attempt to fill the temporary dataset. this.FillCodeDataSet(objDataSetTemp1, objDataSetTemp2); } catch (System.Exception eFillDataSet) { // Add your error handling code here. throw eFillDataSet; } try { // Empty the old records from the dataset. objdsDE_Agencies.Clear(); objdscdAquaticActivity.Clear(); // Merge the records into the main dataset. objdsDE_Agencies.Merge(objDataSetTemp1); objdscdAquaticActivity.Merge(objDataSetTemp2); } catch (System.Exception eLoadMerge) { // Add your error handling code here. throw eLoadMerge; } }