/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.oleDbdaDE_Temperature2 = 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.dvDE_Temperature2 = new System.Data.DataView(); this.objdsDE_Temperature2 = new NBADWDataEntryApplication.dsDE_Temperature2(); this.oleDbdaDE_SiteInfo = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_SiteInfo = new NBADWDataEntryApplication.dsDE_SiteInfo(); this.oleDbdaDE_Loggers = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.objdsDE_Loggers = new NBADWDataEntryApplication.dsDE_Loggers(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand5 = new System.Data.OleDb.OleDbCommand(); ((System.ComponentModel.ISupportInitialize)(this.dvDE_Temperature2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Temperature2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteInfo)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Loggers)).BeginInit(); this.dgTemperatures.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.dgTemperatures_SortCommand); // // oleDbdaDE_Temperature2 // this.oleDbdaDE_Temperature2.InsertCommand = this.oleDbInsertCommand4; this.oleDbdaDE_Temperature2.SelectCommand = this.oleDbSelectCommand4; this.oleDbdaDE_Temperature2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-Temperature2", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("84", "84"), new System.Data.Common.DataColumnMapping("85", "85"), new System.Data.Common.DataColumnMapping("86", "86"), new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("AquaticActivityStartDate", "AquaticActivityStartDate"), new System.Data.Common.DataColumnMapping("TemperatureLoggerID", "TemperatureLoggerID")})}); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = "INSERT INTO [DE-Temperature2] ([84], [85], [86], AquaticActivityID, AquaticActivi" + "tyStartDate, TemperatureLoggerID) VALUES (?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("_4", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "84", System.Data.DataRowVersion.Current, null)); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("_5", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "85", System.Data.DataRowVersion.Current, null)); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("_6", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "86", System.Data.DataRowVersion.Current, null)); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Current, null)); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarChar, 10, "AquaticActivityStartDate")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TemperatureLoggerID", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "TemperatureLoggerID", System.Data.DataRowVersion.Current, null)); // // 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 [84], [85], [86], AquaticActivityID, AquaticActivityStartDate, Temperature" + "LoggerID FROM [DE-Temperature2]"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // dvDE_Temperature2 // this.dvDE_Temperature2.Table = this.objdsDE_Temperature2._DE_Temperature2; // // objdsDE_Temperature2 // this.objdsDE_Temperature2.DataSetName = "dsDE_Temperature2"; this.objdsDE_Temperature2.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaDE_SiteInfo // this.oleDbdaDE_SiteInfo.InsertCommand = this.oleDbInsertCommand2; this.oleDbdaDE_SiteInfo.SelectCommand = this.oleDbSelectCommand2; this.oleDbdaDE_SiteInfo.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-SiteInfo", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"), 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("CoordinateSource", "CoordinateSource"), new System.Data.Common.DataColumnMapping("CoordinateSystem", "CoordinateSystem"), new System.Data.Common.DataColumnMapping("CoordinateUnits", "CoordinateUnits"), new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"), new System.Data.Common.DataColumnMapping("DrainName", "DrainName"), 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("XCoordinate", "XCoordinate"), new System.Data.Common.DataColumnMapping("YCoordinate", "YCoordinate")})}); // // oleDbInsertCommand2 // this.oleDbInsertCommand2.CommandText = @"INSERT INTO [DE-SiteInfo] (AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, DrainName, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, XCoordinate, YCoordinate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand2.Connection = this.oleDbConnection1; this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainName", System.Data.OleDb.OleDbType.VarWChar, 255, "DrainName")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSite_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSite.IncorporatedInd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSiteAgencyUse_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSiteAgencyUse.IncorporatedInd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 55, "WaterBodyName")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate")); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = @"SELECT AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, AquaticSiteUseID, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, DrainName, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, XCoordinate, YCoordinate FROM [DE-SiteInfo]"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // objdsDE_SiteInfo // this.objdsDE_SiteInfo.DataSetName = "dsDE_SiteInfo"; this.objdsDE_SiteInfo.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbdaDE_Loggers // this.oleDbdaDE_Loggers.InsertCommand = this.oleDbInsertCommand5; this.oleDbdaDE_Loggers.SelectCommand = this.oleDbSelectCommand5; this.oleDbdaDE_Loggers.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "DE-Loggers", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Accuracy", "Accuracy"), new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"), new System.Data.Common.DataColumnMapping("BrandName", "BrandName"), new System.Data.Common.DataColumnMapping("DataFileName", "DataFileName"), new System.Data.Common.DataColumnMapping("DateEntered", "DateEntered"), new System.Data.Common.DataColumnMapping("DistanceFromLeftBank_m", "DistanceFromLeftBank_m"), new System.Data.Common.DataColumnMapping("DistanceFromRightBank_m", "DistanceFromRightBank_m"), new System.Data.Common.DataColumnMapping("IncorporatedInd", "IncorporatedInd"), new System.Data.Common.DataColumnMapping("Install_AirTemp_C", "Install_AirTemp_C"), new System.Data.Common.DataColumnMapping("Install_TimeofDay", "Install_TimeofDay"), new System.Data.Common.DataColumnMapping("Install_WaterTemp_C", "Install_WaterTemp_C"), new System.Data.Common.DataColumnMapping("InstallationDate", "InstallationDate"), new System.Data.Common.DataColumnMapping("LoggerNo", "LoggerNo"), new System.Data.Common.DataColumnMapping("Model", "Model"), new System.Data.Common.DataColumnMapping("OutofWaterReadingsOccurred", "OutofWaterReadingsOccurred"), new System.Data.Common.DataColumnMapping("OutofWaterReadingsRemoved", "OutofWaterReadingsRemoved"), new System.Data.Common.DataColumnMapping("RecordingEndDate", "RecordingEndDate"), new System.Data.Common.DataColumnMapping("RecordingStartDate", "RecordingStartDate"), new System.Data.Common.DataColumnMapping("Removal_AirTemp_C", "Removal_AirTemp_C"), new System.Data.Common.DataColumnMapping("Removal_TimeofDay", "Removal_TimeofDay"), new System.Data.Common.DataColumnMapping("Removal_WaterTemp_C", "Removal_WaterTemp_C"), new System.Data.Common.DataColumnMapping("RemovalDate", "RemovalDate"), new System.Data.Common.DataColumnMapping("Resolution", "Resolution"), new System.Data.Common.DataColumnMapping("SampleInterval_min", "SampleInterval_min"), new System.Data.Common.DataColumnMapping("TemperatureLoggerID", "TemperatureLoggerID"), new System.Data.Common.DataColumnMapping("TempRange_From", "TempRange_From"), new System.Data.Common.DataColumnMapping("TempRange_To", "TempRange_To"), new System.Data.Common.DataColumnMapping("WaterDepth_cm", "WaterDepth_cm"), new System.Data.Common.DataColumnMapping("WaterLevel_Install", "WaterLevel_Install"), new System.Data.Common.DataColumnMapping("WaterLevel_Removal", "WaterLevel_Removal")})}); // // oleDbInsertCommand3 // this.oleDbInsertCommand3.CommandText = @"INSERT INTO [DE-Loggers] (Accuracy, AgencyCd, AquaticActivityID, AquaticSiteID, BrandName, DataFileName, DateEntered, DistanceFromLeftBank_m, DistanceFromRightBank_m, IncorporatedInd, Install_AirTemp_C, Install_TimeofDay, Install_WaterTemp_C, InstallationDate, LoggerID, Model, OutofWaterReadingsOccurred, OutofWaterReadingsRemoved, RecordingEndDate, RecordingStartDate, Removal_AirTemp_C, Removal_TimeofDay, Removal_WaterTemp_C, RemovalDate, Resolution, SampleInterval_min, TempRange_From, TempRange_To, WaterDepth_m, WaterLevel_Install, WaterLevel_Removal) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand3.Connection = this.oleDbConnection1; this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Accuracy", System.Data.OleDb.OleDbType.VarWChar, 20, "Accuracy")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("BrandName", System.Data.OleDb.OleDbType.VarWChar, 30, "BrandName")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataFileName", System.Data.OleDb.OleDbType.VarWChar, 30, "DataFileName")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DistanceFromLeftBank_m", System.Data.OleDb.OleDbType.Integer, 0, "DistanceFromLeftBank_m")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DistanceFromRightBank_m", System.Data.OleDb.OleDbType.Integer, 0, "DistanceFromRightBank_m")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Install_AirTemp_C")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "Install_TimeofDay")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Install_WaterTemp_C")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("InstallationDate", System.Data.OleDb.OleDbType.VarWChar, 10, "InstallationDate")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("LoggerID", System.Data.OleDb.OleDbType.VarWChar, 20, "LoggerID")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Model", System.Data.OleDb.OleDbType.VarWChar, 20, "Model")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutofWaterReadingsOccurred", System.Data.OleDb.OleDbType.Boolean, 2, "OutofWaterReadingsOccurred")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutofWaterReadingsRemoved", System.Data.OleDb.OleDbType.Boolean, 2, "OutofWaterReadingsRemoved")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecordingEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RecordingEndDate")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecordingStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RecordingStartDate")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Removal_AirTemp_C")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "Removal_TimeofDay")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Removal_WaterTemp_C")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("RemovalDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RemovalDate")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Resolution", System.Data.OleDb.OleDbType.VarWChar, 20, "Resolution")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("SampleInterval_min", System.Data.OleDb.OleDbType.Single, 0, "SampleInterval_min")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("TempRange_From", System.Data.OleDb.OleDbType.Integer, 0, "TempRange_From")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("TempRange_To", System.Data.OleDb.OleDbType.Integer, 0, "TempRange_To")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterDepth_m", System.Data.OleDb.OleDbType.Integer, 0, "WaterDepth_m")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_Install", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterLevel_Install")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_Removal", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterLevel_Removal")); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = @"SELECT Accuracy, AgencyCd, AquaticActivityID, AquaticSiteID, BrandName, DataFileName, DateEntered, DistanceFromLeftBank_m, DistanceFromRightBank_m, IncorporatedInd, Install_AirTemp_C, Install_TimeofDay, Install_WaterTemp_C, InstallationDate, LoggerID, Model, OutofWaterReadingsOccurred, OutofWaterReadingsRemoved, RecordingEndDate, RecordingStartDate, Removal_AirTemp_C, Removal_TimeofDay, Removal_WaterTemp_C, RemovalDate, Resolution, SampleInterval_min, TemperatureLoggerID, TempRange_From, TempRange_To, WaterDepth_m, WaterLevel_Install, WaterLevel_Removal FROM [DE-Loggers]"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // objdsDE_Loggers // this.objdsDE_Loggers.DataSetName = "dsDE_Loggers"; this.objdsDE_Loggers.Locale = new System.Globalization.CultureInfo("en-US"); // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT [84], [85], [86], AquaticActivityID, AquaticActivityStartDate, Temperature" + "LoggerID FROM [DE-Temperature2]"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbInsertCommand4 // this.oleDbInsertCommand4.CommandText = "INSERT INTO [DE-Temperature2] ([84], [85], [86], AquaticActivityID, AquaticActivi" + "tyStartDate, TemperatureLoggerID) VALUES (?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand4.Connection = this.oleDbConnection1; this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("_4", System.Data.OleDb.OleDbType.Single, 0, "84")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("_5", System.Data.OleDb.OleDbType.Single, 0, "85")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("_6", System.Data.OleDb.OleDbType.Single, 0, "86")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityStartDate")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("TemperatureLoggerID", System.Data.OleDb.OleDbType.Integer, 0, "TemperatureLoggerID")); // // oleDbSelectCommand5 // this.oleDbSelectCommand5.CommandText = @"SELECT Accuracy, AgencyCd, AquaticActivityID, AquaticSiteID, BrandName, DataFileName, DateEntered, DistanceFromLeftBank_m, DistanceFromRightBank_m, IncorporatedInd, Install_AirTemp_C, Install_TimeofDay, Install_WaterTemp_C, InstallationDate, LoggerNo, Model, OutofWaterReadingsOccurred, OutofWaterReadingsRemoved, RecordingEndDate, RecordingStartDate, Removal_AirTemp_C, Removal_TimeofDay, Removal_WaterTemp_C, RemovalDate, Resolution, SampleInterval_min, TemperatureLoggerID, TempRange_From, TempRange_To, WaterDepth_cm, WaterLevel_Install, WaterLevel_Removal FROM [DE-Loggers]"; this.oleDbSelectCommand5.Connection = this.oleDbConnection1; // // oleDbInsertCommand5 // this.oleDbInsertCommand5.CommandText = @"INSERT INTO [DE-Loggers] (Accuracy, AgencyCd, AquaticActivityID, AquaticSiteID, BrandName, DataFileName, DateEntered, DistanceFromLeftBank_m, DistanceFromRightBank_m, IncorporatedInd, Install_AirTemp_C, Install_TimeofDay, Install_WaterTemp_C, InstallationDate, LoggerNo, Model, OutofWaterReadingsOccurred, OutofWaterReadingsRemoved, RecordingEndDate, RecordingStartDate, Removal_AirTemp_C, Removal_TimeofDay, Removal_WaterTemp_C, RemovalDate, Resolution, SampleInterval_min, TempRange_From, TempRange_To, WaterDepth_cm, WaterLevel_Install, WaterLevel_Removal) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand5.Connection = this.oleDbConnection1; this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Accuracy", System.Data.OleDb.OleDbType.VarWChar, 20, "Accuracy")); 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("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); 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("BrandName", System.Data.OleDb.OleDbType.VarWChar, 30, "BrandName")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataFileName", System.Data.OleDb.OleDbType.VarWChar, 30, "DataFileName")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DistanceFromLeftBank_m", System.Data.OleDb.OleDbType.Integer, 0, "DistanceFromLeftBank_m")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DistanceFromRightBank_m", System.Data.OleDb.OleDbType.Integer, 0, "DistanceFromRightBank_m")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Install_AirTemp_C")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "Install_TimeofDay")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Install_WaterTemp_C")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("InstallationDate", System.Data.OleDb.OleDbType.VarWChar, 10, "InstallationDate")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("LoggerNo", System.Data.OleDb.OleDbType.VarWChar, 20, "LoggerNo")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Model", System.Data.OleDb.OleDbType.VarWChar, 20, "Model")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutofWaterReadingsOccurred", System.Data.OleDb.OleDbType.Boolean, 2, "OutofWaterReadingsOccurred")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutofWaterReadingsRemoved", System.Data.OleDb.OleDbType.Boolean, 2, "OutofWaterReadingsRemoved")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecordingEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RecordingEndDate")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecordingStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RecordingStartDate")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Removal_AirTemp_C")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "Removal_TimeofDay")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Removal_WaterTemp_C")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("RemovalDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RemovalDate")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Resolution", System.Data.OleDb.OleDbType.VarWChar, 20, "Resolution")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("SampleInterval_min", System.Data.OleDb.OleDbType.Single, 0, "SampleInterval_min")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("TempRange_From", System.Data.OleDb.OleDbType.Integer, 0, "TempRange_From")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("TempRange_To", System.Data.OleDb.OleDbType.Integer, 0, "TempRange_To")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterDepth_cm", System.Data.OleDb.OleDbType.Integer, 0, "WaterDepth_cm")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_Install", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterLevel_Install")); this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_Removal", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterLevel_Removal")); ((System.ComponentModel.ISupportInitialize)(this.dvDE_Temperature2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Temperature2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteInfo)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Loggers)).EndInit(); }
public void LoadDE_Temperature2() { // 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_Temperature2 objDataSetTemp1; objDataSetTemp1 = new NBADWDataEntryApplication.dsDE_Temperature2(); try { // Attempt to fill the temporary dataset. this.FillDE_Temperature2(objDataSetTemp1); } catch (System.Exception eFillDataSet) { // Add your error handling code here. throw eFillDataSet; } try { // Empty the old records from the dataset. objdsDE_Temperature2.Clear(); // Merge the records into the main dataset. objdsDE_Temperature2.Merge(objDataSetTemp1); } catch (System.Exception eLoadMerge) { // Add your error handling code here. throw eLoadMerge; } }