public void LoadDataSet() { // 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.dstblAquaticSite objDataSetTemp1; NBADWDataEntryApplication.dstblAquaticSiteAgencyUse objDataSetTemp2; NBADWDataEntryApplication.dsWatersheds objDataSetTemp3; objDataSetTemp1 = new NBADWDataEntryApplication.dstblAquaticSite(); objDataSetTemp2 = new NBADWDataEntryApplication.dstblAquaticSiteAgencyUse(); objDataSetTemp3 = new NBADWDataEntryApplication.dsWatersheds(); try { // Attempt to fill the temporary dataset. this.FillDataSet(objDataSetTemp1, objDataSetTemp2, objDataSetTemp3); } catch (System.Exception eFillDataSet) { // Add your error handling code here. throw eFillDataSet; } try { // Empty the old records from the dataset. objdstblAquaticSite.Clear(); objdstblAquaticSiteAgencyUse.Clear(); objdsWatersheds.Clear(); // Merge the records into the main dataset. objdstblAquaticSite.Merge(objDataSetTemp1); objdstblAquaticSiteAgencyUse.Merge(objDataSetTemp2); objdsWatersheds.Merge(objDataSetTemp3); } catch (System.Exception eLoadMerge) { // Add your error handling code here. throw eLoadMerge; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.oleDbdatblAquaticSite = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbdatblAquaticSiteAgencyUse = 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.oleDbdaWatersheds = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbInsertCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.objdstblAquaticSite = new NBADWDataEntryApplication.dstblAquaticSite(); this.objdstblAquaticSiteAgencyUse = new NBADWDataEntryApplication.dstblAquaticSiteAgencyUse(); this.objdsWatersheds = new NBADWDataEntryApplication.dsWatersheds(); this.dvtblAquaticActivity = new System.Data.DataView(); this.oleDbdatblAquaticActivity = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand3 = new System.Data.OleDb.OleDbCommand(); this.objdstblAquaticActivity = new NBADWDataEntryApplication.dstblAquaticActivity(); this.dvtblAquaticSiteAgencyUse = new System.Data.DataView(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticSite)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticSiteAgencyUse)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsWatersheds)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblAquaticActivity)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticActivity)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblAquaticSiteAgencyUse)).BeginInit(); // // oleDbdatblAquaticSite // this.oleDbdatblAquaticSite.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbdatblAquaticSite.InsertCommand = this.oleDbInsertCommand1; this.oleDbdatblAquaticSite.SelectCommand = this.oleDbSelectCommand1; this.oleDbdatblAquaticSite.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblAquaticSite", new System.Data.Common.DataColumnMapping[] { 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("CoordinateSource", "CoordinateSource"), new System.Data.Common.DataColumnMapping("CoordinateSystem", "CoordinateSystem"), new System.Data.Common.DataColumnMapping("CoordinateUnits", "CoordinateUnits"), new System.Data.Common.DataColumnMapping("DateEntered", "DateEntered"), new System.Data.Common.DataColumnMapping("EndDesc", "EndDesc"), new System.Data.Common.DataColumnMapping("EndRouteMeas", "EndRouteMeas"), new System.Data.Common.DataColumnMapping("GeoReferencedInd", "GeoReferencedInd"), new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"), new System.Data.Common.DataColumnMapping("IncorporatedInd", "IncorporatedInd"), new System.Data.Common.DataColumnMapping("oldAquaticSiteID", "oldAquaticSiteID"), new System.Data.Common.DataColumnMapping("ReachNo", "ReachNo"), new System.Data.Common.DataColumnMapping("RiverSystemID", "RiverSystemID"), new System.Data.Common.DataColumnMapping("SpecificSiteInd", "SpecificSiteInd"), new System.Data.Common.DataColumnMapping("StartDesc", "StartDesc"), new System.Data.Common.DataColumnMapping("StartRouteMeas", "StartRouteMeas"), 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")})}); this.oleDbdatblAquaticSite.UpdateCommand = this.oleDbUpdateCommand1; // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = @"DELETE FROM tblAquaticSite WHERE (AquaticSiteID = ?) AND (AquaticSiteDesc = ? OR ? IS NULL AND AquaticSiteDesc IS NULL) AND (AquaticSiteName = ? OR ? IS NULL AND AquaticSiteName IS NULL) AND (CoordinateSource = ? OR ? IS NULL AND CoordinateSource IS NULL) AND (CoordinateSystem = ? OR ? IS NULL AND CoordinateSystem IS NULL) AND (CoordinateUnits = ? OR ? IS NULL AND CoordinateUnits IS NULL) AND (DateEntered = ? OR ? IS NULL AND DateEntered IS NULL) AND (EndDesc = ? OR ? IS NULL AND EndDesc IS NULL) AND (EndRouteMeas = ? OR ? IS NULL AND EndRouteMeas IS NULL) AND (GeoReferencedInd = ? OR ? IS NULL AND GeoReferencedInd IS NULL) AND (HabitatDesc = ? OR ? IS NULL AND HabitatDesc IS NULL) AND (IncorporatedInd = ?) AND (ReachNo = ? OR ? IS NULL AND ReachNo IS NULL) AND (RiverSystemID = ? OR ? IS NULL AND RiverSystemID IS NULL) AND (SpecificSiteInd = ? OR ? IS NULL AND SpecificSiteInd IS NULL) AND (StartDesc = ? OR ? IS NULL AND StartDesc IS NULL) AND (StartRouteMeas = ? OR ? IS NULL AND StartRouteMeas IS NULL) AND (WaterBodyID = ? OR ? IS NULL AND WaterBodyID IS NULL) AND (WaterBodyName = ? OR ? IS NULL AND WaterBodyName IS NULL) AND (XCoordinate = ? OR ? IS NULL AND XCoordinate IS NULL) AND (YCoordinate = ? OR ? IS NULL AND YCoordinate IS NULL) AND (oldAquaticSiteID = ? OR ? IS NULL AND oldAquaticSiteID IS NULL)"; this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteDesc1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteName", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteName1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteName", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSource", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSource1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSource", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSystem", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSystem1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSystem", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateUnits", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateUnits1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateUnits", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndDesc", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndDesc1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndRouteMeas", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndRouteMeas1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_GeoReferencedInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "GeoReferencedInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_GeoReferencedInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "GeoReferencedInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "HabitatDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_HabitatDesc1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "HabitatDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ReachNo", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReachNo", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ReachNo1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReachNo", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_RiverSystemID", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RiverSystemID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_RiverSystemID1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RiverSystemID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SpecificSiteInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SpecificSiteInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SpecificSiteInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SpecificSiteInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartDesc", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartDesc1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartDesc", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartRouteMeas", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartRouteMeas1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyName", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyName", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "XCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_XCoordinate1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "XCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YCoordinate1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, 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"); } // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = @"INSERT INTO tblAquaticSite(AquaticSiteDesc, AquaticSiteID, AquaticSiteName, CoordinateSource, CoordinateSystem, CoordinateUnits, DateEntered, EndDesc, EndRouteMeas, GeoReferencedInd, HabitatDesc, IncorporatedInd, oldAquaticSiteID, ReachNo, RiverSystemID, SpecificSiteInd, StartDesc, StartRouteMeas, WaterBodyID, WaterBodyName, XCoordinate, YCoordinate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; 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("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("EndDesc", System.Data.OleDb.OleDbType.VarWChar, 100, "EndDesc")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("EndRouteMeas", System.Data.OleDb.OleDbType.Double, 0, "EndRouteMeas")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("GeoReferencedInd", System.Data.OleDb.OleDbType.VarWChar, 1, "GeoReferencedInd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticSiteID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ReachNo", System.Data.OleDb.OleDbType.Integer, 0, "ReachNo")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("RiverSystemID", System.Data.OleDb.OleDbType.SmallInt, 0, "RiverSystemID")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("SpecificSiteInd", System.Data.OleDb.OleDbType.VarWChar, 1, "SpecificSiteInd")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("StartDesc", System.Data.OleDb.OleDbType.VarWChar, 100, "StartDesc")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("StartRouteMeas", System.Data.OleDb.OleDbType.Double, 0, "StartRouteMeas")); 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("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate")); this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate")); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT AquaticSiteDesc, AquaticSiteID, AquaticSiteName, CoordinateSource, CoordinateSystem, CoordinateUnits, DateEntered, EndDesc, EndRouteMeas, GeoReferencedInd, HabitatDesc, IncorporatedInd, oldAquaticSiteID, ReachNo, RiverSystemID, SpecificSiteInd, StartDesc, StartRouteMeas, WaterBodyID, WaterBodyName, XCoordinate, YCoordinate FROM tblAquaticSite"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = "UPDATE tblAquaticSite SET AquaticSiteDesc = ?, AquaticSiteID = ?, AquaticSiteName" + " = ?, CoordinateSource = ?, CoordinateSystem = ?, CoordinateUnits = ?, DateEnter" + "ed = ?, EndDesc = ?, EndRouteMeas = ?, GeoReferencedInd = ?, HabitatDesc = ?, In" + "corporatedInd = ?, oldAquaticSiteID = ?, ReachNo = ?, RiverSystemID = ?, Specifi" + "cSiteInd = ?, StartDesc = ?, StartRouteMeas = ?, WaterBodyID = ?, WaterBodyName " + "= ?, XCoordinate = ?, YCoordinate = ? WHERE (AquaticSiteID = ?) AND (AquaticSite" + "Desc = ? OR ? IS NULL AND AquaticSiteDesc IS NULL) AND (AquaticSiteName = ? OR ?" + " IS NULL AND AquaticSiteName IS NULL) AND (CoordinateSource = ? OR ? IS NULL AND" + " CoordinateSource IS NULL) AND (CoordinateSystem = ? OR ? IS NULL AND Coordinate" + "System IS NULL) AND (CoordinateUnits = ? OR ? IS NULL AND CoordinateUnits IS NUL" + "L) AND (DateEntered = ? OR ? IS NULL AND DateEntered IS NULL) AND (EndDesc = ? O" + "R ? IS NULL AND EndDesc IS NULL) AND (EndRouteMeas = ? OR ? IS NULL AND EndRoute" + "Meas IS NULL) AND (GeoReferencedInd = ? OR ? IS NULL AND GeoReferencedInd IS NUL" + "L) AND (HabitatDesc = ? OR ? IS NULL AND HabitatDesc IS NULL) AND (IncorporatedI" + "nd = ?) AND (ReachNo = ? OR ? IS NULL AND ReachNo IS NULL) AND (RiverSystemID = " + "? OR ? IS NULL AND RiverSystemID IS NULL) AND (SpecificSiteInd = ? OR ? IS NULL " + "AND SpecificSiteInd IS NULL) AND (StartDesc = ? OR ? IS NULL AND StartDesc IS NU" + "LL) AND (StartRouteMeas = ? OR ? IS NULL AND StartRouteMeas IS NULL) AND (WaterB" + "odyID = ? OR ? IS NULL AND WaterBodyID IS NULL) AND (WaterBodyName = ? OR ? IS N" + "ULL AND WaterBodyName IS NULL) AND (XCoordinate = ? OR ? IS NULL AND XCoordinate" + " IS NULL) AND (YCoordinate = ? OR ? IS NULL AND YCoordinate IS NULL) AND (oldAqu" + "aticSiteID = ? OR ? IS NULL AND oldAquaticSiteID IS NULL)"; this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("EndDesc", System.Data.OleDb.OleDbType.VarWChar, 100, "EndDesc")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("EndRouteMeas", System.Data.OleDb.OleDbType.Double, 0, "EndRouteMeas")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("GeoReferencedInd", System.Data.OleDb.OleDbType.VarWChar, 1, "GeoReferencedInd")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticSiteID")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ReachNo", System.Data.OleDb.OleDbType.Integer, 0, "ReachNo")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("RiverSystemID", System.Data.OleDb.OleDbType.SmallInt, 0, "RiverSystemID")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("SpecificSiteInd", System.Data.OleDb.OleDbType.VarWChar, 1, "SpecificSiteInd")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("StartDesc", System.Data.OleDb.OleDbType.VarWChar, 100, "StartDesc")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("StartRouteMeas", System.Data.OleDb.OleDbType.Double, 0, "StartRouteMeas")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterBodyName")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate")); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteDesc1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteName", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteName1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteName", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSource", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSource1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSource", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSystem", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateSystem1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateSystem", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateUnits", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CoordinateUnits1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CoordinateUnits", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered1", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndDesc", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndDesc1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndRouteMeas", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndRouteMeas1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_GeoReferencedInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "GeoReferencedInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_GeoReferencedInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "GeoReferencedInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "HabitatDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_HabitatDesc1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "HabitatDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ReachNo", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReachNo", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ReachNo1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReachNo", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_RiverSystemID", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RiverSystemID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_RiverSystemID1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RiverSystemID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SpecificSiteInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SpecificSiteInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_SpecificSiteInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SpecificSiteInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartDesc", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartDesc1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartDesc", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartRouteMeas", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartRouteMeas1", System.Data.OleDb.OleDbType.Double, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartRouteMeas", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyName", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterBodyName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterBodyName", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "XCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_XCoordinate1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "XCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YCoordinate1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YCoordinate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); // // oleDbdatblAquaticSiteAgencyUse // this.oleDbdatblAquaticSiteAgencyUse.DeleteCommand = this.oleDbDeleteCommand2; this.oleDbdatblAquaticSiteAgencyUse.InsertCommand = this.oleDbInsertCommand2; this.oleDbdatblAquaticSiteAgencyUse.SelectCommand = this.oleDbSelectCommand2; this.oleDbdatblAquaticSiteAgencyUse.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblAquaticSiteAgencyUse", 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("AquaticSiteID", "AquaticSiteID"), new System.Data.Common.DataColumnMapping("AquaticSiteType", "AquaticSiteType"), new System.Data.Common.DataColumnMapping("AquaticSiteUseID", "AquaticSiteUseID"), new System.Data.Common.DataColumnMapping("EndYear", "EndYear"), new System.Data.Common.DataColumnMapping("IncorporatedInd", "IncorporatedInd"), new System.Data.Common.DataColumnMapping("StartYear", "StartYear"), new System.Data.Common.DataColumnMapping("YearsActive", "YearsActive")})}); this.oleDbdatblAquaticSiteAgencyUse.UpdateCommand = this.oleDbUpdateCommand2; // // oleDbDeleteCommand2 // this.oleDbDeleteCommand2.CommandText = @"DELETE FROM tblAquaticSiteAgencyUse WHERE (AquaticSiteUseID = ?) AND (AgencyCd = ? OR ? IS NULL AND AgencyCd IS NULL) AND (AgencySiteID = ? OR ? IS NULL AND AgencySiteID IS NULL) AND (AquaticActivityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AND (AquaticSiteID = ? OR ? IS NULL AND AquaticSiteID IS NULL) AND (AquaticSiteType = ? OR ? IS NULL AND AquaticSiteType IS NULL) AND (EndYear = ? OR ? IS NULL AND EndYear IS NULL) AND (IncorporatedInd = ?) AND (StartYear = ? OR ? IS NULL AND StartYear IS NULL) AND (YearsActive = ? OR ? IS NULL AND YearsActive IS NULL)"; this.oleDbDeleteCommand2.Connection = this.oleDbConnection1; this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteUseID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteUseID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, 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_AgencyCd1", System.Data.OleDb.OleDbType.VarWChar, 4, 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_AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencySiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencySiteID1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencySiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.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.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteType", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteType", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteType1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteType", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndYear", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndYear", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndYear1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndYear", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartYear", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartYear", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartYear1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartYear", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YearsActive", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YearsActive", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YearsActive1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YearsActive", System.Data.DataRowVersion.Original, null)); // // oleDbInsertCommand2 // this.oleDbInsertCommand2.CommandText = "INSERT INTO tblAquaticSiteAgencyUse(AgencyCd, AgencySiteID, AquaticActivityCd, Aq" + "uaticSiteID, AquaticSiteType, EndYear, IncorporatedInd, StartYear, YearsActive) " + "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("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); 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("AquaticSiteType", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticSiteType")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("EndYear", System.Data.OleDb.OleDbType.VarWChar, 4, "EndYear")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("StartYear", System.Data.OleDb.OleDbType.VarWChar, 4, "StartYear")); this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("YearsActive", System.Data.OleDb.OleDbType.VarWChar, 20, "YearsActive")); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteID, AquaticSiteType," + " AquaticSiteUseID, EndYear, IncorporatedInd, StartYear, YearsActive FROM tblAqua" + "ticSiteAgencyUse"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbUpdateCommand2 // this.oleDbUpdateCommand2.CommandText = @"UPDATE tblAquaticSiteAgencyUse SET AgencyCd = ?, AgencySiteID = ?, AquaticActivityCd = ?, AquaticSiteID = ?, AquaticSiteType = ?, EndYear = ?, IncorporatedInd = ?, StartYear = ?, YearsActive = ? WHERE (AquaticSiteUseID = ?) AND (AgencyCd = ? OR ? IS NULL AND AgencyCd IS NULL) AND (AgencySiteID = ? OR ? IS NULL AND AgencySiteID IS NULL) AND (AquaticActivityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AND (AquaticSiteID = ? OR ? IS NULL AND AquaticSiteID IS NULL) AND (AquaticSiteType = ? OR ? IS NULL AND AquaticSiteType IS NULL) AND (EndYear = ? OR ? IS NULL AND EndYear IS NULL) AND (IncorporatedInd = ?) AND (StartYear = ? OR ? IS NULL AND StartYear IS NULL) AND (YearsActive = ? OR ? IS NULL AND YearsActive IS NULL)"; this.oleDbUpdateCommand2.Connection = this.oleDbConnection1; this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteType", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticSiteType")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("EndYear", System.Data.OleDb.OleDbType.VarWChar, 4, "EndYear")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("StartYear", System.Data.OleDb.OleDbType.VarWChar, 4, "StartYear")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("YearsActive", System.Data.OleDb.OleDbType.VarWChar, 20, "YearsActive")); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteUseID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteUseID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, 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_AgencyCd1", System.Data.OleDb.OleDbType.VarWChar, 4, 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_AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencySiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencySiteID1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencySiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.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.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteType", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteType", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteType1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteType", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndYear", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndYear", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EndYear1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EndYear", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartYear", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartYear", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_StartYear1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StartYear", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YearsActive", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YearsActive", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_YearsActive1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "YearsActive", System.Data.DataRowVersion.Original, null)); // // 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("DrainageCd", "DrainageCd"), new System.Data.Common.DataColumnMapping("DrainName", "DrainName"), new System.Data.Common.DataColumnMapping("Level1Name", "Level1Name"), new System.Data.Common.DataColumnMapping("Level2Name", "Level2Name"), new System.Data.Common.DataColumnMapping("Level3Name", "Level3Name"), new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"), new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName")})}); // // oleDbInsertCommand3 // this.oleDbInsertCommand3.CommandText = "INSERT INTO [DE-Watersheds] (DrainageCd, DrainName, Level1Name, Level2Name, Level" + "3Name, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand3.Connection = this.oleDbConnection1; this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainName", System.Data.OleDb.OleDbType.VarWChar, 255, "DrainName")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Level1Name", System.Data.OleDb.OleDbType.VarWChar, 40, "Level1Name")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Level2Name", System.Data.OleDb.OleDbType.VarWChar, 50, "Level2Name")); this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Level3Name", System.Data.OleDb.OleDbType.VarWChar, 50, "Level3Name")); 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")); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT DrainageCd, DrainName, Level1Name, Level2Name, Level3Name, WaterBodyID, Wa" + "terBodyName FROM [DE-Watersheds]"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // objdstblAquaticSite // this.objdstblAquaticSite.DataSetName = "dstblAquaticSite"; this.objdstblAquaticSite.Locale = new System.Globalization.CultureInfo("en-US"); // // objdstblAquaticSiteAgencyUse // this.objdstblAquaticSiteAgencyUse.DataSetName = "dstblAquaticSiteAgencyUse"; this.objdstblAquaticSiteAgencyUse.Locale = new System.Globalization.CultureInfo("en-US"); // // objdsWatersheds // this.objdsWatersheds.DataSetName = "dsWatersheds"; this.objdsWatersheds.Locale = new System.Globalization.CultureInfo("en-US"); // // dvtblAquaticActivity // this.dvtblAquaticActivity.Table = this.objdstblAquaticActivity.tblAquaticActivity; // // oleDbdatblAquaticActivity // this.oleDbdatblAquaticActivity.DeleteCommand = this.oleDbDeleteCommand3; this.oleDbdatblAquaticActivity.InsertCommand = this.oleDbInsertCommand4; this.oleDbdatblAquaticActivity.SelectCommand = this.oleDbSelectCommand4; this.oleDbdatblAquaticActivity.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tblAquaticActivity", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"), new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"), new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"), new System.Data.Common.DataColumnMapping("AquaticActivityEndDate", "AquaticActivityEndDate"), new System.Data.Common.DataColumnMapping("AquaticActivityEndTime", "AquaticActivityEndTime"), new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"), new System.Data.Common.DataColumnMapping("AquaticActivityLeader", "AquaticActivityLeader"), new System.Data.Common.DataColumnMapping("AquaticActivityStartDate", "AquaticActivityStartDate"), new System.Data.Common.DataColumnMapping("AquaticActivityStartTime", "AquaticActivityStartTime"), new System.Data.Common.DataColumnMapping("AquaticMethodCd", "AquaticMethodCd"), new System.Data.Common.DataColumnMapping("AquaticProgramID", "AquaticProgramID"), new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"), new System.Data.Common.DataColumnMapping("Comments", "Comments"), new System.Data.Common.DataColumnMapping("Crew", "Crew"), new System.Data.Common.DataColumnMapping("DateEntered", "DateEntered"), new System.Data.Common.DataColumnMapping("IncorporatedInd", "IncorporatedInd"), new System.Data.Common.DataColumnMapping("OldAquaticActivityID", "OldAquaticActivityID"), new System.Data.Common.DataColumnMapping("oldAquaticSiteID", "oldAquaticSiteID"), new System.Data.Common.DataColumnMapping("PrimaryActivityInd", "PrimaryActivityInd"), new System.Data.Common.DataColumnMapping("project", "project"), new System.Data.Common.DataColumnMapping("Siltation", "Siltation"), new System.Data.Common.DataColumnMapping("WaterLevel", "WaterLevel"), new System.Data.Common.DataColumnMapping("WaterLevel_AM_cm", "WaterLevel_AM_cm"), new System.Data.Common.DataColumnMapping("WaterLevel_cm", "WaterLevel_cm"), new System.Data.Common.DataColumnMapping("WaterLevel_PM_cm", "WaterLevel_PM_cm"), new System.Data.Common.DataColumnMapping("WeatherConditions", "WeatherConditions"), new System.Data.Common.DataColumnMapping("Year", "Year")})}); this.oleDbdatblAquaticActivity.UpdateCommand = this.oleDbUpdateCommand3; // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = @"SELECT Agency2Cd, AgencyCd, AquaticActivityCd, AquaticActivityEndDate, AquaticActivityEndTime, AquaticActivityID, AquaticActivityLeader, AquaticActivityStartDate, AquaticActivityStartTime, AquaticMethodCd, AquaticProgramID, AquaticSiteID, Comments, Crew, DateEntered, IncorporatedInd, OldAquaticActivityID, oldAquaticSiteID, PrimaryActivityInd, project, Siltation, WaterLevel, WaterLevel_AM_cm, WaterLevel_cm, WaterLevel_PM_cm, WeatherConditions, Year FROM tblAquaticActivity"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbInsertCommand4 // this.oleDbInsertCommand4.CommandText = @"INSERT INTO tblAquaticActivity(Agency2Cd, AgencyCd, AquaticActivityCd, AquaticActivityEndDate, AquaticActivityEndTime, AquaticActivityID, AquaticActivityLeader, AquaticActivityStartDate, AquaticActivityStartTime, AquaticMethodCd, AquaticProgramID, AquaticSiteID, Comments, Crew, DateEntered, IncorporatedInd, OldAquaticActivityID, oldAquaticSiteID, PrimaryActivityInd, project, Siltation, WaterLevel, WaterLevel_AM_cm, WaterLevel_cm, WaterLevel_PM_cm, WeatherConditions, Year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand4.Connection = this.oleDbConnection1; this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd")); 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("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityEndDate")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityEndTime")); 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("AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivityLeader")); 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("AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityStartTime")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticMethodCd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticProgramID")); 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("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Crew", System.Data.OleDb.OleDbType.VarWChar, 50, "Crew")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "OldAquaticActivityID")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticSiteID")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, "PrimaryActivityInd")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("project", System.Data.OleDb.OleDbType.VarWChar, 50, "project")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, "Siltation")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, "WaterLevel")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_AM_cm")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_cm")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_PM_cm")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, "WeatherConditions")); this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Year", System.Data.OleDb.OleDbType.VarWChar, 4, "Year")); // // oleDbUpdateCommand3 // this.oleDbUpdateCommand3.CommandText = "UPDATE tblAquaticActivity SET Agency2Cd = ?, AgencyCd = ?, AquaticActivityCd = ?," + " AquaticActivityEndDate = ?, AquaticActivityEndTime = ?, AquaticActivityID = ?, " + "AquaticActivityLeader = ?, AquaticActivityStartDate = ?, AquaticActivityStartTim" + "e = ?, AquaticMethodCd = ?, AquaticProgramID = ?, AquaticSiteID = ?, Comments = " + "?, Crew = ?, DateEntered = ?, IncorporatedInd = ?, OldAquaticActivityID = ?, old" + "AquaticSiteID = ?, PrimaryActivityInd = ?, project = ?, Siltation = ?, WaterLeve" + "l = ?, WaterLevel_AM_cm = ?, WaterLevel_cm = ?, WaterLevel_PM_cm = ?, WeatherCon" + "ditions = ?, Year = ? WHERE (AquaticActivityID = ?) AND (Agency2Cd = ? OR ? IS N" + "ULL AND Agency2Cd IS NULL) AND (AgencyCd = ? OR ? IS NULL AND AgencyCd IS NULL) " + "AND (AquaticActivityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) AND (Aqua" + "ticActivityEndDate = ? OR ? IS NULL AND AquaticActivityEndDate IS NULL) AND (Aqu" + "aticActivityEndTime = ? OR ? IS NULL AND AquaticActivityEndTime IS NULL) AND (Aq" + "uaticActivityLeader = ? OR ? IS NULL AND AquaticActivityLeader IS NULL) AND (Aqu" + "aticActivityStartDate = ? OR ? IS NULL AND AquaticActivityStartDate IS NULL) AND" + " (AquaticActivityStartTime = ? OR ? IS NULL AND AquaticActivityStartTime IS NULL" + ") AND (AquaticMethodCd = ? OR ? IS NULL AND AquaticMethodCd IS NULL) AND (Aquati" + "cProgramID = ? OR ? IS NULL AND AquaticProgramID IS NULL) AND (AquaticSiteID = ?" + " OR ? IS NULL AND AquaticSiteID IS NULL) AND (Comments = ? OR ? IS NULL AND Comm" + "ents IS NULL) AND (Crew = ? OR ? IS NULL AND Crew IS NULL) AND (DateEntered = ?)" + " AND (IncorporatedInd = ?) AND (OldAquaticActivityID = ? OR ? IS NULL AND OldAqu" + "aticActivityID IS NULL) AND (PrimaryActivityInd = ?) AND (Siltation = ? OR ? IS " + "NULL AND Siltation IS NULL) AND (WaterLevel = ? OR ? IS NULL AND WaterLevel IS N" + "ULL) AND (WaterLevel_AM_cm = ? OR ? IS NULL AND WaterLevel_AM_cm IS NULL) AND (W" + "aterLevel_PM_cm = ? OR ? IS NULL AND WaterLevel_PM_cm IS NULL) AND (WaterLevel_c" + "m = ? OR ? IS NULL AND WaterLevel_cm IS NULL) AND (WeatherConditions = ? OR ? IS" + " NULL AND WeatherConditions IS NULL) AND (Year = ? OR ? IS NULL AND Year IS NULL" + ") AND (oldAquaticSiteID = ? OR ? IS NULL AND oldAquaticSiteID IS NULL) AND (proj" + "ect = ? OR ? IS NULL AND project IS NULL)"; this.oleDbUpdateCommand3.Connection = this.oleDbConnection1; this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityEndDate")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityEndTime")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, "AquaticActivityLeader")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "AquaticActivityStartDate")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, "AquaticActivityStartTime")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticMethodCd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticProgramID")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Crew", System.Data.OleDb.OleDbType.VarWChar, 50, "Crew")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, "DateEntered")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "IncorporatedInd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "OldAquaticActivityID")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "oldAquaticSiteID")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, "PrimaryActivityInd")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("project", System.Data.OleDb.OleDbType.VarWChar, 50, "project")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, "Siltation")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, "WaterLevel")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_AM_cm")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_cm")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterLevel_PM_cm")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, "WeatherConditions")); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Year", System.Data.OleDb.OleDbType.VarWChar, 4, "Year")); this.oleDbUpdateCommand3.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.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.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.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments1", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PrimaryActivityInd", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_project", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "project", System.Data.DataRowVersion.Original, null)); this.oleDbUpdateCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_project1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "project", System.Data.DataRowVersion.Original, null)); // // oleDbDeleteCommand3 // this.oleDbDeleteCommand3.CommandText = "DELETE FROM tblAquaticActivity WHERE (AquaticActivityID = ?) AND (Agency2Cd = ? O" + "R ? IS NULL AND Agency2Cd IS NULL) AND (AgencyCd = ? OR ? IS NULL AND AgencyCd I" + "S NULL) AND (AquaticActivityCd = ? OR ? IS NULL AND AquaticActivityCd IS NULL) A" + "ND (AquaticActivityEndDate = ? OR ? IS NULL AND AquaticActivityEndDate IS NULL) " + "AND (AquaticActivityEndTime = ? OR ? IS NULL AND AquaticActivityEndTime IS NULL)" + " AND (AquaticActivityLeader = ? OR ? IS NULL AND AquaticActivityLeader IS NULL) " + "AND (AquaticActivityStartDate = ? OR ? IS NULL AND AquaticActivityStartDate IS N" + "ULL) AND (AquaticActivityStartTime = ? OR ? IS NULL AND AquaticActivityStartTime" + " IS NULL) AND (AquaticMethodCd = ? OR ? IS NULL AND AquaticMethodCd IS NULL) AND" + " (AquaticProgramID = ? OR ? IS NULL AND AquaticProgramID IS NULL) AND (AquaticSi" + "teID = ? OR ? IS NULL AND AquaticSiteID IS NULL) AND (Comments = ? OR ? IS NULL " + "AND Comments IS NULL) AND (Crew = ? OR ? IS NULL AND Crew IS NULL) AND (DateEnte" + "red = ?) AND (IncorporatedInd = ?) AND (OldAquaticActivityID = ? OR ? IS NULL AN" + "D OldAquaticActivityID IS NULL) AND (PrimaryActivityInd = ?) AND (Siltation = ? " + "OR ? IS NULL AND Siltation IS NULL) AND (WaterLevel = ? OR ? IS NULL AND WaterLe" + "vel IS NULL) AND (WaterLevel_AM_cm = ? OR ? IS NULL AND WaterLevel_AM_cm IS NULL" + ") AND (WaterLevel_PM_cm = ? OR ? IS NULL AND WaterLevel_PM_cm IS NULL) AND (Wate" + "rLevel_cm = ? OR ? IS NULL AND WaterLevel_cm IS NULL) AND (WeatherConditions = ?" + " OR ? IS NULL AND WeatherConditions IS NULL) AND (Year = ? OR ? IS NULL AND Year" + " IS NULL) AND (oldAquaticSiteID = ? OR ? IS NULL AND oldAquaticSiteID IS NULL) A" + "ND (project = ? OR ? IS NULL AND project IS NULL)"; this.oleDbDeleteCommand3.Connection = this.oleDbConnection1; this.oleDbDeleteCommand3.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.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency2Cd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency2Cd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.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.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndDate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityEndTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityEndTime", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityLeader1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityLeader", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartDate1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartDate", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticActivityStartTime1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticActivityStartTime", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticMethodCd1", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticMethodCd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticProgramID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticProgramID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Comments1", System.Data.OleDb.OleDbType.VarWChar, 250, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Comments", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Crew1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Crew", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DateEntered", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateEntered", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncorporatedInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OldAquaticActivityID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OldAquaticActivityID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_PrimaryActivityInd", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PrimaryActivityInd", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Siltation1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Siltation", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_AM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_AM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_PM_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_PM_cm", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WaterLevel_cm1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WaterLevel_cm", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_WeatherConditions1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "WeatherConditions", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Year1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Year", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_oldAquaticSiteID1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "oldAquaticSiteID", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_project", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "project", System.Data.DataRowVersion.Original, null)); this.oleDbDeleteCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_project1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "project", System.Data.DataRowVersion.Original, null)); // // objdstblAquaticActivity // this.objdstblAquaticActivity.DataSetName = "dstblAquaticActivity"; this.objdstblAquaticActivity.Locale = new System.Globalization.CultureInfo("en-US"); // // dvtblAquaticSiteAgencyUse // this.dvtblAquaticSiteAgencyUse.Table = this.objdstblAquaticSiteAgencyUse.tblAquaticSiteAgencyUse; ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticSite)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticSiteAgencyUse)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdsWatersheds)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblAquaticActivity)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.objdstblAquaticActivity)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dvtblAquaticSiteAgencyUse)).EndInit(); }