/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.dvSortedSites = new System.Data.DataView(); this.objdsDE_SiteList = new NBADWDataEntryApplication.dsDE_SiteList(); this.oleDbdaSiteList = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); ((System.ComponentModel.ISupportInitialize)(this.dvSortedSites)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteList)).BeginInit(); this.masterDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.masterDataGrid_PageIndexChanged); this.masterDataGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.masterDataGrid_EditCommand); this.masterDataGrid.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.masterDataGrid_SortCommand); // // dvSortedSites // this.dvSortedSites.Table = this.objdsDE_SiteList._DE_SiteList; // // objdsDE_SiteList // this.objdsDE_SiteList.DataSetName = "dsDE_SiteList"; this.objdsDE_SiteList.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaSiteList // this.oleDbdaSiteList.InsertCommand = this.oleDbInsertCommand1; this.oleDbdaSiteList.SelectCommand = this.oleDbSelectCommand1; this.oleDbdaSiteList.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-SiteList", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"), new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"), new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"), 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("tblAquaticSite.IncorporatedInd", "tblAquaticSite.IncorporatedInd"), new System.Data.Common.DataColumnMapping("tblAquaticSiteAgencyUse.IncorporatedInd", "tblAquaticSiteAgencyUse.IncorporatedInd"), new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"), new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"), new System.Data.Common.DataColumnMapping("WaterBodyName_Abrev", "WaterBodyName_Abrev")})}); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = @"INSERT INTO [DE-SiteList] (AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, DrainageCd, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, WaterBodyName_Abrev) 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("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc")); 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("tblAquaticSite_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSite.IncorporatedInd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSiteAgencyUse_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSiteAgencyUse.IncorporatedInd")); 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, 50, "WaterBodyName")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName_Abrev", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName_Abrev")); // // 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"); } // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, AquaticSiteUseID, DrainageCd, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, WaterBodyName_Abrev FROM [DE-SiteList]"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbInsertCommand4 // this.oleDbInsertCommand4.CommandText = @"INSERT INTO [DE-SiteList] (AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, DrainageCd, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSite_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSite.IncorporatedInd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSiteAgencyUse_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSiteAgencyUse.IncorporatedInd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterBodyName")); // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID," + " AquaticSiteName, AquaticSiteUseID, DrainageCd, [tblAquaticSite.IncorporatedInd]" + ", [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName FROM [DE" + "-SiteList]"; ((System.ComponentModel.ISupportInitialize)(this.dvSortedSites)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteList)).EndInit(); }
public void LoadSiteList() { // 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.dsTemperatureSites objDataSetTemp; //objDataSetTemp = new NBADWDataEntryApplication.dsTemperatureSites(); NBADWDataEntryApplication.dsDE_SiteList objDataSetTemp; objDataSetTemp = new NBADWDataEntryApplication.dsDE_SiteList(); try { // Attempt to fill the temporary dataset. this.FillSiteList(objDataSetTemp); } catch (System.Exception eFillDataSet) { // Add your error handling code here. throw eFillDataSet; } try { // Empty the old records from the dataset. objdsDE_SiteList.Clear(); // Merge the records into the main dataset. objdsDE_SiteList.Merge(objDataSetTemp); } catch (System.Exception eLoadMerge) { // Add your error handling code here. throw eLoadMerge; } }