Exemplo n.º 1
0
        public void LoadElectrofishing()
        {
            // 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.dsqryElectrofishingDataPlusEstimates objDataSetTemp1;
            NBADWDataEntryApplication.dsqryElectrofishingMarkRecaptureDataPlusEstimates objDataSetTemp2;
            NBADWDataEntryApplication.dsqryElectrofishingMethodDetails objDataSetTemp3;
            NBADWDataEntryApplication.dsqryElectrofishingSiteMeasurements objDataSetTemp4;
            NBADWDataEntryApplication.dsqryElectrofishingSites objDataSetTemp5;
            NBADWDataEntryApplication.dsqryElectrofishingWaterMeasurements objDataSetTemp6;

            objDataSetTemp1 = new NBADWDataEntryApplication.dsqryElectrofishingDataPlusEstimates();
            objDataSetTemp2 = new NBADWDataEntryApplication.dsqryElectrofishingMarkRecaptureDataPlusEstimates();
            objDataSetTemp3 = new NBADWDataEntryApplication.dsqryElectrofishingMethodDetails();
            objDataSetTemp4 = new NBADWDataEntryApplication.dsqryElectrofishingSiteMeasurements();
            objDataSetTemp5 = new NBADWDataEntryApplication.dsqryElectrofishingSites();
            objDataSetTemp6 = new NBADWDataEntryApplication.dsqryElectrofishingWaterMeasurements();

            try
            {
                // Attempt to fill the temporary dataset.
                this.FillElectrofishing(objDataSetTemp1,objDataSetTemp2, objDataSetTemp3, objDataSetTemp4, objDataSetTemp5, objDataSetTemp6);
            }
            catch (System.Exception eFillDataSet)
            {
                // Add your error handling code here.
                throw eFillDataSet;
            }
            try
            {
                // Empty the old records from the dataset.
                this.objdsqryElectrofishingDataPlusEstimates.Clear();
                this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates.Clear();
                this.objdsqryElectrofishingMethodDetails.Clear();
                this.objdsqryElectrofishingSiteMeasurements.Clear();
                this.objdsqryElectrofishingSites.Clear();
                this.objdsqryElectrofishingWaterMeasurements.Clear();

                // Merge the records into the main dataset.
                this.objdsqryElectrofishingDataPlusEstimates.Merge(objDataSetTemp1);
                this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates.Merge(objDataSetTemp2);
                this.objdsqryElectrofishingMethodDetails.Merge(objDataSetTemp3);
                this.objdsqryElectrofishingSiteMeasurements.Merge(objDataSetTemp4);
                this.objdsqryElectrofishingSites.Merge(objDataSetTemp5);
                this.objdsqryElectrofishingWaterMeasurements.Merge(objDataSetTemp6);
            }
            catch (System.Exception eLoadMerge)
            {
                // Add your error handling code here.
                throw eLoadMerge;
            }
        }
Exemplo n.º 2
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.dvqryElectrofishingMethodDetails = new System.Data.DataView();
     this.objdsqryElectrofishingMethodDetails = new NBADWDataEntryApplication.dsqryElectrofishingMethodDetails();
     this.oleDbdaqryElectrofishingSiteMeasurements = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand5 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryElectrofishingDataPlusEstimates = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand20 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand20 = new System.Data.OleDb.OleDbCommand();
     this.dvqryElectrofishingWaterMeasurements = new System.Data.DataView();
     this.objdsqryElectrofishingWaterMeasurements = new NBADWDataEntryApplication.dsqryElectrofishingWaterMeasurements();
     this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates = new NBADWDataEntryApplication.dsqryElectrofishingMarkRecaptureDataPlusEstimates();
     this.oleDbdaDE_Agencies = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
     this.objdsqryElectrofishingDataPlusEstimates = new NBADWDataEntryApplication.dsqryElectrofishingDataPlusEstimates();
     this.oleDbdaqryElectrofishingMethodDetails = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand3 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
     this.objdsqryElectrofishingSiteMeasurements = new NBADWDataEntryApplication.dsqryElectrofishingSiteMeasurements();
     this.dvqryElectrofishingSiteMeasurements = new System.Data.DataView();
     this.oleDbdaqryElectrofishingSites = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand18 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand18 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryElectrofishingMarkRecaptureDataPlusEstimates = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand10 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand10 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand17 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand17 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryElectrofishingWaterMeasurements = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand6 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand6 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryFishStockingSites = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand19 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand19 = new System.Data.OleDb.OleDbCommand();
     this.dvqryElectrofishingSites = new System.Data.DataView();
     this.objdsqryElectrofishingSites = new NBADWDataEntryApplication.dsqryElectrofishingSites();
     this.dvqryElectrofishingDataPlusEstimates = new System.Data.DataView();
     this.dvqryElectrofishingMarkRecaptureDataPlusEstimates = new System.Data.DataView();
     this.oleDbdaqryESASiteMeasurements = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand9 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand9 = new System.Data.OleDb.OleDbCommand();
     this.dvqryESAPlanning = new System.Data.DataView();
     this.objdsqryESAPlanning = new NBADWDataEntryApplication.dsqryESAPlanning();
     this.oleDbdaqryESAObservations = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand7 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand7 = new System.Data.OleDb.OleDbCommand();
     this.dvqryESASites = new System.Data.DataView();
     this.objdsqryESASites = new NBADWDataEntryApplication.dsqryESASites();
     this.objdsqryESAObservations = new NBADWDataEntryApplication.dsqryESAObservations();
     this.oleDbdaqryESASites = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand21 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand21 = new System.Data.OleDb.OleDbCommand();
     this.objdsqryESASiteMeasurements = new NBADWDataEntryApplication.dsqryESASiteMeasurements();
     this.dvqryESASiteMeasurements = new System.Data.DataView();
     this.dvqryESAObservations = new System.Data.DataView();
     this.oleDbdaqryESAPlanning = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand8 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand8 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryFishStocking = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand11 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand11 = new System.Data.OleDb.OleDbCommand();
     this.dvqryFishStockingSites = new System.Data.DataView();
     this.objdsqryFishStockingSites = new NBADWDataEntryApplication.dsqryFishStockingSites();
     this.objdsqryFishStocking = new NBADWDataEntryApplication.dsqryFishStocking();
     this.dvqryFishStocking = new System.Data.DataView();
     this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryWaterTemperatureLoggerDetails = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand13 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand13 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryWaterTemperatureLoggerSites = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand22 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand22 = new System.Data.OleDb.OleDbCommand();
     this.oleDbdaqryWaterTemperatureLoggerMeasurements = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbInsertCommand14 = new System.Data.OleDb.OleDbCommand();
     this.oleDbSelectCommand14 = new System.Data.OleDb.OleDbCommand();
     this.dvqryWaterTemperatureLoggerDetails = new System.Data.DataView();
     this.objdsqryWaterTemperatureLoggerDetails = new NBADWDataEntryApplication.dsqryWaterTemperatureLoggerDetails();
     this.dvqryWaterTemperatureLoggerMeasurements = new System.Data.DataView();
     this.objdsqryWaterTemperatureLoggerMeasurements = new NBADWDataEntryApplication.dsqryWaterTemperatureLoggerMeasurements();
     this.objdsqryWaterTemperatureLoggerSites = new NBADWDataEntryApplication.dsqryWaterTemperatureLoggerSites();
     this.dvqryWaterTemperatureLoggerSites = new System.Data.DataView();
     this.oleDbSelectCommand12 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand12 = new System.Data.OleDb.OleDbCommand();
     this.objdsDE_Agencies = new NBADWDataEntryApplication.dsDE_Agencies();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingMethodDetails)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingMethodDetails)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingWaterMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingWaterMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingDataPlusEstimates)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingSiteMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingSiteMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingSites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingSites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingDataPlusEstimates)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingMarkRecaptureDataPlusEstimates)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESAPlanning)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESAPlanning)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESASites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESASites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESAObservations)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESASiteMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESASiteMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESAObservations)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryFishStockingSites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryFishStockingSites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryFishStocking)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryFishStocking)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryWaterTemperatureLoggerDetails)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryWaterTemperatureLoggerDetails)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryWaterTemperatureLoggerMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryWaterTemperatureLoggerMeasurements)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryWaterTemperatureLoggerSites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryWaterTemperatureLoggerSites)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Agencies)).BeginInit();
     //
     // 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");
     }
     //
     // dvqryElectrofishingMethodDetails
     //
     this.dvqryElectrofishingMethodDetails.Table = this.objdsqryElectrofishingMethodDetails.qryElectrofishingMethodDetails;
     //
     // objdsqryElectrofishingMethodDetails
     //
     this.objdsqryElectrofishingMethodDetails.DataSetName = "dsqryElectrofishingMethodDetails";
     this.objdsqryElectrofishingMethodDetails.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // oleDbdaqryElectrofishingSiteMeasurements
     //
     this.oleDbdaqryElectrofishingSiteMeasurements.InsertCommand = this.oleDbInsertCommand5;
     this.oleDbdaqryElectrofishingSiteMeasurements.SelectCommand = this.oleDbSelectCommand5;
     this.oleDbdaqryElectrofishingSiteMeasurements.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                        new System.Data.Common.DataTableMapping("Table", "qryElectrofishingSiteMeasurements", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Agency2SiteID", "Agency2SiteID"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("AquaticMethod", "AquaticMethod"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Bank", "Bank"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Comments", "Comments"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Instrument", "Instrument"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Measure", "Measure"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Measurement", "Measurement"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("SiteMeasurementID", "SiteMeasurementID"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Time", "Time"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("UnitOfMeasure", "UnitOfMeasure"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
                                                                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("Category", "Category")})});
     //
     // oleDbInsertCommand5
     //
     this.oleDbInsertCommand5.CommandText = @"INSERT INTO qryElectrofishingSiteMeasurements(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Bank, Comments, [Date], DrainageCd, Instrument, Measure, Measurement, [Time], UnitOfMeasure, WaterBodyID, WaterBodyName, AquaticSiteDesc, Category) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand5.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 16, "Agency2SiteID"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 16, "AgencySiteID"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Bank", System.Data.OleDb.OleDbType.VarWChar, 10, "Bank"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarWChar, 50, "Instrument"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measure", System.Data.OleDb.OleDbType.VarWChar, 50, "Measure"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measurement", System.Data.OleDb.OleDbType.Double, 0, "Measurement"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Time", System.Data.OleDb.OleDbType.VarWChar, 6, "Time"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "UnitOfMeasure"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 250, "AquaticSiteDesc"));
     this.oleDbInsertCommand5.Parameters.Add(new System.Data.OleDb.OleDbParameter("Category", System.Data.OleDb.OleDbType.VarWChar, 50, "Category"));
     //
     // oleDbSelectCommand5
     //
     this.oleDbSelectCommand5.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Bank, Comments, [Date], DrainageCd, Instrument, Measure, Measurement, SiteMeasurementID, [Time], UnitOfMeasure, WaterBodyID, WaterBodyName, AquaticSiteDesc, Category FROM qryElectrofishingSiteMeasurements";
     this.oleDbSelectCommand5.Connection = this.oleDbConnection1;
     //
     // oleDbInsertCommand4
     //
     this.oleDbInsertCommand4.CommandText = @"INSERT INTO qryElectrofishingSiteMeasurements(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Bank, Comments, [Date], DrainageCd, Instrument, Measure, Measurement, OtherMeasure, [Time], UnitOfMeasure, WaterBodyID, WaterBodyName) 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("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "Agency2SiteID"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod"));
     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("Bank", System.Data.OleDb.OleDbType.VarWChar, 10, "Bank"));
     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("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarWChar, 50, "Instrument"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measure", System.Data.OleDb.OleDbType.VarWChar, 50, "Measure"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measurement", System.Data.OleDb.OleDbType.Double, 0, "Measurement"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherMeasure", System.Data.OleDb.OleDbType.VarWChar, 20, "OtherMeasure"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("Time", System.Data.OleDb.OleDbType.VarWChar, 6, "Time"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "UnitOfMeasure"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand4
     //
     this.oleDbSelectCommand4.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Bank, Comments, [Date], DrainageCd, Instrument, Measure, Measurement, OtherMeasure, SiteMeasurementID, [Time], UnitOfMeasure, WaterBodyID, WaterBodyName FROM qryElectrofishingSiteMeasurements";
     this.oleDbSelectCommand4.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryElectrofishingDataPlusEstimates
     //
     this.oleDbdaqryElectrofishingDataPlusEstimates.InsertCommand = this.oleDbInsertCommand20;
     this.oleDbdaqryElectrofishingDataPlusEstimates.SelectCommand = this.oleDbSelectCommand20;
     this.oleDbdaqryElectrofishingDataPlusEstimates.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                         new System.Data.Common.DataTableMapping("Table", "qryElectrofishingDataPlusEstimates", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Agency2SiteID", "Agency2SiteID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Area_m2", "Area_m2"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AutoCalculatedInd", "AutoCalculatedInd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AveForkLength_cm", "AveForkLength_cm"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AveTotalLength_cm", "AveTotalLength_cm"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AveWeight_gm", "AveWeight_gm"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Biomass", "Biomass"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Comments", "Comments"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Density", "Density"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("EFDataID", "EFDataID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("FishSpecies", "FishSpecies"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Formula", "Formula"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Method", "Method"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("NoSweeps", "NoSweeps"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("PercentClipped", "PercentClipped"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("PermitNo", "PermitNo"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("PHS", "PHS"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("RelativeSizeClass", "RelativeSizeClass"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep1NoFish", "Sweep1NoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep1Time_s", "Sweep1Time_s"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep2NoFish", "Sweep2NoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep2Time_s", "Sweep2Time_s"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep3NoFish", "Sweep3NoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep3Time_s", "Sweep3Time_s"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep4NoFish", "Sweep4NoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep4Time_s", "Sweep4Time_s"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep5NoFish", "Sweep5NoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep5Time_s", "Sweep5Time_s"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep6NoFish", "Sweep6NoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Sweep6Time_s", "Sweep6Time_s"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("TotalNoFish", "TotalNoFish"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName")})});
     //
     // oleDbInsertCommand20
     //
     this.oleDbInsertCommand20.CommandText = @"INSERT INTO qryElectrofishingDataPlusEstimates(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteDesc, AquaticSiteID, Area_m2, AutoCalculatedInd, AveForkLength_cm, AveTotalLength_cm, AveWeight_gm, Biomass, Comments, [Date], Density, DrainageCd, FishAgeClass, FishSpecies, FishSpeciesCd, Formula, HabitatDesc, Method, NoSweeps, PercentClipped, PermitNo, PHS, RelativeSizeClass, Sweep1NoFish, Sweep1Time_s, Sweep2NoFish, Sweep2Time_s, Sweep3NoFish, Sweep3Time_s, Sweep4NoFish, Sweep4Time_s, Sweep5NoFish, Sweep5Time_s, Sweep6NoFish, Sweep6Time_s, TotalNoFish, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand20.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "Agency2SiteID"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Area_m2", System.Data.OleDb.OleDbType.Single, 0, "Area_m2"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AutoCalculatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "AutoCalculatedInd"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveForkLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveForkLength_cm"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveTotalLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveTotalLength_cm"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Biomass", System.Data.OleDb.OleDbType.Double, 0, "Biomass"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 100, "Comments"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Density", System.Data.OleDb.OleDbType.Double, 0, "Density"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 25, "FishAgeClass"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Formula", System.Data.OleDb.OleDbType.VarWChar, 50, "Formula"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Method", System.Data.OleDb.OleDbType.VarWChar, 30, "Method"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoSweeps", System.Data.OleDb.OleDbType.SmallInt, 0, "NoSweeps"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("PercentClipped", System.Data.OleDb.OleDbType.Double, 0, "PercentClipped"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("PermitNo", System.Data.OleDb.OleDbType.VarWChar, 20, "PermitNo"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("PHS", System.Data.OleDb.OleDbType.Double, 0, "PHS"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("RelativeSizeClass", System.Data.OleDb.OleDbType.VarWChar, 10, "RelativeSizeClass"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep1NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep1NoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep1Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep1Time_s"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep2NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep2NoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep2Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep2Time_s"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep3NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep3NoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep3Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep3Time_s"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep4NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep4NoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep4Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep4Time_s"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep5NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep5NoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep5Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep5Time_s"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep6NoFish", System.Data.OleDb.OleDbType.Double, 0, "Sweep6NoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sweep6Time_s", System.Data.OleDb.OleDbType.Double, 0, "Sweep6Time_s"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("TotalNoFish", System.Data.OleDb.OleDbType.Double, 0, "TotalNoFish"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand20.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand20
     //
     this.oleDbSelectCommand20.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteDesc, AquaticSiteID, Area_m2, AutoCalculatedInd, AveForkLength_cm, AveTotalLength_cm, AveWeight_gm, Biomass, Comments, [Date], Density, DrainageCd, EFDataID, FishAgeClass, FishSpecies, FishSpeciesCd, Formula, HabitatDesc, Method, NoSweeps, PercentClipped, PermitNo, PHS, RelativeSizeClass, Sweep1NoFish, Sweep1Time_s, Sweep2NoFish, Sweep2Time_s, Sweep3NoFish, Sweep3Time_s, Sweep4NoFish, Sweep4Time_s, Sweep5NoFish, Sweep5Time_s, Sweep6NoFish, Sweep6Time_s, TotalNoFish, WaterBodyID, WaterBodyName FROM qryElectrofishingDataPlusEstimates";
     this.oleDbSelectCommand20.Connection = this.oleDbConnection1;
     //
     // dvqryElectrofishingWaterMeasurements
     //
     this.dvqryElectrofishingWaterMeasurements.Table = this.objdsqryElectrofishingWaterMeasurements.qryElectrofishingWaterMeasurements;
     //
     // objdsqryElectrofishingWaterMeasurements
     //
     this.objdsqryElectrofishingWaterMeasurements.DataSetName = "dsqryElectrofishingWaterMeasurements";
     this.objdsqryElectrofishingWaterMeasurements.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // objdsqryElectrofishingMarkRecaptureDataPlusEstimates
     //
     this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates.DataSetName = "dsqryElectrofishingMarkRecaptureDataPlusEstimates";
     this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // oleDbdaDE_Agencies
     //
     this.oleDbdaDE_Agencies.InsertCommand = this.oleDbInsertCommand12;
     this.oleDbdaDE_Agencies.SelectCommand = this.oleDbSelectCommand12;
     this.oleDbdaDE_Agencies.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                  new System.Data.Common.DataTableMapping("Table", "DE-Agencies", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("Agency", "Agency"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd")})});
     //
     // oleDbDeleteCommand1
     //
     this.oleDbDeleteCommand1.CommandText = "DELETE FROM cdAgency WHERE (AgencyCd = ?) AND (Agency = ? OR ? IS NULL AND Agency" +
         " IS NULL) AND (DataRulesInd = ? OR ? IS NULL AND DataRulesInd IS NULL)";
     this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
     this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null));
     this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null));
     this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency1", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null));
     this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null));
     this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null));
     //
     // oleDbInsertCommand2
     //
     this.oleDbInsertCommand2.CommandText = "INSERT INTO cdAgency(Agency, AgencyCd, DataRulesInd) VALUES (?, ?, ?)";
     this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency"));
     this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd"));
     this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, "DataRulesInd"));
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT Agency, AgencyCd, DataRulesInd FROM cdAgency";
     this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
     //
     // oleDbUpdateCommand1
     //
     this.oleDbUpdateCommand1.CommandText = "UPDATE cdAgency SET Agency = ?, AgencyCd = ?, DataRulesInd = ? WHERE (AgencyCd = " +
         "?) AND (Agency = ? OR ? IS NULL AND Agency IS NULL) AND (DataRulesInd = ? OR ? I" +
         "S NULL AND DataRulesInd IS NULL)";
     this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency"));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd"));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, "DataRulesInd"));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AgencyCd", System.Data.DataRowVersion.Original, null));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Agency1", System.Data.OleDb.OleDbType.VarWChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Agency", System.Data.DataRowVersion.Original, null));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null));
     this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_DataRulesInd1", System.Data.OleDb.OleDbType.VarWChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DataRulesInd", System.Data.DataRowVersion.Original, null));
     //
     // objdsqryElectrofishingDataPlusEstimates
     //
     this.objdsqryElectrofishingDataPlusEstimates.DataSetName = "dsqryElectrofishingDataPlusEstimates";
     this.objdsqryElectrofishingDataPlusEstimates.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // oleDbdaqryElectrofishingMethodDetails
     //
     this.oleDbdaqryElectrofishingMethodDetails.InsertCommand = this.oleDbInsertCommand3;
     this.oleDbdaqryElectrofishingMethodDetails.SelectCommand = this.oleDbSelectCommand3;
     this.oleDbdaqryElectrofishingMethodDetails.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                     new System.Data.Common.DataTableMapping("Table", "qryElectrofishingMethodDetails", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Agency2SiteID", "Agency2SiteID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticMethod", "AquaticMethod"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Area_m2", "Area_m2"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Comments", "Comments"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Device", "Device"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DutyCycle", "DutyCycle"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Frequency_Hz", "Frequency_Hz"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("NoSweeps", "NoSweeps"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("POWSetting", "POWSetting"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("SiteSetup", "SiteSetup"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("StreamLength_m", "StreamLength_m"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Time", "Time"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Voltage", "Voltage"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName")})});
     //
     // oleDbInsertCommand3
     //
     this.oleDbInsertCommand3.CommandText = @"INSERT INTO qryElectrofishingMethodDetails(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Area_m2, Comments, [Date], Device, DrainageCd, DutyCycle, Frequency_Hz, HabitatDesc, NoSweeps, POWSetting, SiteSetup, StreamLength_m, [Time], Voltage, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand3.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "Agency2SiteID"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Area_m2", System.Data.OleDb.OleDbType.Single, 0, "Area_m2"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Device", System.Data.OleDb.OleDbType.VarWChar, 15, "Device"));
     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("DutyCycle", System.Data.OleDb.OleDbType.Double, 0, "DutyCycle"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Frequency_Hz", System.Data.OleDb.OleDbType.Double, 0, "Frequency_Hz"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoSweeps", System.Data.OleDb.OleDbType.SmallInt, 0, "NoSweeps"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("POWSetting", System.Data.OleDb.OleDbType.Double, 0, "POWSetting"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("SiteSetup", System.Data.OleDb.OleDbType.VarWChar, 6, "SiteSetup"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("StreamLength_m", System.Data.OleDb.OleDbType.Single, 0, "StreamLength_m"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Time", System.Data.OleDb.OleDbType.VarWChar, 6, "Time"));
     this.oleDbInsertCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("Voltage", System.Data.OleDb.OleDbType.Double, 0, "Voltage"));
     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, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand3
     //
     this.oleDbSelectCommand3.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Area_m2, Comments, [Date], Device, DrainageCd, DutyCycle, Frequency_Hz, HabitatDesc, NoSweeps, POWSetting, SiteSetup, StreamLength_m, [Time], Voltage, WaterBodyID, WaterBodyName FROM qryElectrofishingMethodDetails";
     this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
     //
     // objdsqryElectrofishingSiteMeasurements
     //
     this.objdsqryElectrofishingSiteMeasurements.DataSetName = "dsqryElectrofishingSiteMeasurements";
     this.objdsqryElectrofishingSiteMeasurements.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // dvqryElectrofishingSiteMeasurements
     //
     this.dvqryElectrofishingSiteMeasurements.Table = this.objdsqryElectrofishingSiteMeasurements.qryElectrofishingSiteMeasurements;
     //
     // oleDbdaqryElectrofishingSites
     //
     this.oleDbdaqryElectrofishingSites.InsertCommand = this.oleDbInsertCommand18;
     this.oleDbdaqryElectrofishingSites.SelectCommand = this.oleDbSelectCommand18;
     this.oleDbdaqryElectrofishingSites.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                             new System.Data.Common.DataTableMapping("Table", "qryElectrofishingSites", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CoordinateSource", "CoordinateSource"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CoordinateSystem", "CoordinateSystem"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CoordinateUnits", "CoordinateUnits"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                       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"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DataBegins", "DataBegins"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DataEnds", "DataEnds")})});
     //
     // oleDbInsertCommand18
     //
     this.oleDbInsertCommand18.CommandText = @"INSERT INTO qryElectrofishingSites(AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, WaterBodyID, WaterBodyName, XCoordinate, YCoordinate, DataBegins, DataEnds) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand18.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataBegins", System.Data.OleDb.OleDbType.VarChar, 255, "DataBegins"));
     this.oleDbInsertCommand18.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataEnds", System.Data.OleDb.OleDbType.VarChar, 255, "DataEnds"));
     //
     // oleDbSelectCommand18
     //
     this.oleDbSelectCommand18.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, " +
         "CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, WaterBodyID, WaterBo" +
         "dyName, XCoordinate, YCoordinate, DataBegins, DataEnds FROM qryElectrofishingSit" +
         "es";
     this.oleDbSelectCommand18.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryElectrofishingMarkRecaptureDataPlusEstimates
     //
     this.oleDbdaqryElectrofishingMarkRecaptureDataPlusEstimates.InsertCommand = this.oleDbInsertCommand10;
     this.oleDbdaqryElectrofishingMarkRecaptureDataPlusEstimates.SelectCommand = this.oleDbSelectCommand10;
     this.oleDbdaqryElectrofishingMarkRecaptureDataPlusEstimates.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                                      new System.Data.Common.DataTableMapping("Table", "qryElectrofishingMarkRecaptureDataPlusEstimates", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Agency2SiteID", "Agency2SiteID"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Area_m2", "Area_m2"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AutoCalculatedInd", "AutoCalculatedInd"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AveForkLength_cm", "AveForkLength_cm"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AveTotalLength_cm", "AveTotalLength_cm"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AveWeight_gm", "AveWeight_gm"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Biomass", "Biomass"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Comments", "Comments"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Density", "Density"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("EFMRDataID", "EFMRDataID"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishSpecies", "FishSpecies"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Formula", "Formula"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("MarkCount", "MarkCount"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("MarkEfficiency", "MarkEfficiency"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("MarkMarked", "MarkMarked"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("MarkMorts", "MarkMorts"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Method", "Method"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("PHS", "PHS"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("RecaptureCount", "RecaptureCount"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("RecaptureMarked", "RecaptureMarked"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("RecaptureMorts", "RecaptureMorts"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("RecaptureTime", "RecaptureTime"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("RecaptureUnmarked", "RecaptureUnmarked"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
                                                                                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd")})});
     //
     // oleDbInsertCommand10
     //
     this.oleDbInsertCommand10.CommandText = @"INSERT INTO qryElectrofishingMarkRecaptureDataPlusEstimates(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, Area_m2, AutoCalculatedInd, AveForkLength_cm, AveTotalLength_cm, AveWeight_gm, Biomass, Comments, [Date], Density, DrainageCd, FishAgeClass, FishSpecies, Formula, HabitatDesc, MarkCount, MarkEfficiency, MarkMarked, MarkMorts, Method, PHS, RecaptureCount, RecaptureMarked, RecaptureMorts, RecaptureTime, RecaptureUnmarked, WaterBodyID, WaterBodyName, AquaticSiteDesc, FishSpeciesCd) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand10.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarChar, 16, "Agency2SiteID"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarChar, 4, "AgencyCd"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarChar, 16, "AgencySiteID"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "AquaticActivityID", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "AquaticSiteID", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Area_m2", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Area_m2", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AutoCalculatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "AutoCalculatedInd"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveForkLength_cm", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "AveForkLength_cm", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveTotalLength_cm", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "AveTotalLength_cm", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "AveWeight_gm", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Biomass", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Biomass", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarChar, 100, "Comments"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarChar, 10, "Date"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Density", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "Density", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarChar, 17, "DrainageCd"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarChar, 10, "FishAgeClass"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarChar, 30, "FishSpecies"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Formula", System.Data.OleDb.OleDbType.VarChar, 26, "Formula"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkCount", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "MarkCount", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkEfficiency", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "MarkEfficiency", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkMarked", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "MarkMarked", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkMorts", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "MarkMorts", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("Method", System.Data.OleDb.OleDbType.VarChar, 30, "Method"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("PHS", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "PHS", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureCount", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "RecaptureCount", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureMarked", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "RecaptureMarked", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureMorts", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "RecaptureMorts", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureTime", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(0)), "RecaptureTime", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureUnmarked", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "RecaptureUnmarked", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "WaterBodyID", System.Data.DataRowVersion.Current, null));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarChar, 250, "AquaticSiteDesc"));
     this.oleDbInsertCommand10.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarChar, 2, "FishSpeciesCd"));
     //
     // oleDbSelectCommand10
     //
     this.oleDbSelectCommand10.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, Area_m2, AutoCalculatedInd, AveForkLength_cm, AveTotalLength_cm, AveWeight_gm, Biomass, Comments, [Date], Density, DrainageCd, EFMRDataID, FishAgeClass, FishSpecies, Formula, HabitatDesc, MarkCount, MarkEfficiency, MarkMarked, MarkMorts, Method, PHS, RecaptureCount, RecaptureMarked, RecaptureMorts, RecaptureTime, RecaptureUnmarked, WaterBodyID, WaterBodyName, AquaticSiteDesc, FishSpeciesCd FROM qryElectrofishingMarkRecaptureDataPlusEstimates";
     this.oleDbSelectCommand10.Connection = this.oleDbConnection1;
     //
     // oleDbInsertCommand17
     //
     this.oleDbInsertCommand17.CommandText = @"INSERT INTO qryElectrofishingMarkRecaptureDataPlusEstimates(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, Area_m2, AutoCalculatedInd, AveForkLength_cm, AveTotalLenght_cm, AveWeight_gm, Biomass, Comments, [Date], Density, DrainageCd, FishAgeClass, FishSpecies, Formula, HabitatDesc, MarkCount, MarkEfficiency, MarkMarked, MarkMorts, Method, PHS, RecaptureCount, RecaptureMarked, RecaptureMorts, RecaptureTime, RecaptureUnmarked, WaterBodyID, WaterBodyName, AquaticSiteDesc, FishSpeciesCd) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand17.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "Agency2SiteID"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Area_m2", System.Data.OleDb.OleDbType.Single, 0, "Area_m2"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AutoCalculatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "AutoCalculatedInd"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveForkLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveForkLength_cm"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveTotalLenght_cm", System.Data.OleDb.OleDbType.Double, 0, "AveTotalLenght_cm"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Biomass", System.Data.OleDb.OleDbType.Double, 0, "Biomass"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 100, "Comments"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Density", System.Data.OleDb.OleDbType.Double, 0, "Density"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 10, "FishAgeClass"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Formula", System.Data.OleDb.OleDbType.VarWChar, 50, "Formula"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkCount", System.Data.OleDb.OleDbType.Double, 0, "MarkCount"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkEfficiency", System.Data.OleDb.OleDbType.Double, 0, "MarkEfficiency"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkMarked", System.Data.OleDb.OleDbType.Double, 0, "MarkMarked"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("MarkMorts", System.Data.OleDb.OleDbType.Double, 0, "MarkMorts"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("Method", System.Data.OleDb.OleDbType.VarWChar, 30, "Method"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("PHS", System.Data.OleDb.OleDbType.Double, 0, "PHS"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureCount", System.Data.OleDb.OleDbType.Double, 0, "RecaptureCount"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureMarked", System.Data.OleDb.OleDbType.Double, 0, "RecaptureMarked"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureMorts", System.Data.OleDb.OleDbType.Double, 0, "RecaptureMorts"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureTime", System.Data.OleDb.OleDbType.SmallInt, 0, "RecaptureTime"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecaptureUnmarked", System.Data.OleDb.OleDbType.Double, 0, "RecaptureUnmarked"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
     this.oleDbInsertCommand17.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
     //
     // oleDbSelectCommand17
     //
     this.oleDbSelectCommand17.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, Area_m2, AutoCalculatedInd, AveForkLength_cm, AveTotalLenght_cm, AveWeight_gm, Biomass, Comments, [Date], Density, DrainageCd, EFMRDataID, FishAgeClass, FishSpecies, Formula, HabitatDesc, MarkCount, MarkEfficiency, MarkMarked, MarkMorts, Method, PHS, RecaptureCount, RecaptureMarked, RecaptureMorts, RecaptureTime, RecaptureUnmarked, WaterBodyID, WaterBodyName, AquaticSiteDesc, FishSpeciesCd FROM qryElectrofishingMarkRecaptureDataPlusEstimates";
     this.oleDbSelectCommand17.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryElectrofishingWaterMeasurements
     //
     this.oleDbdaqryElectrofishingWaterMeasurements.InsertCommand = this.oleDbInsertCommand1;
     this.oleDbdaqryElectrofishingWaterMeasurements.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbdaqryElectrofishingWaterMeasurements.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                         new System.Data.Common.DataTableMapping("Table", "qryElectrofishingWaterMeasurements", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Agency2SiteID", "Agency2SiteID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticMethod", "AquaticMethod"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Comments", "Comments"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Instrument", "Instrument"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Measure", "Measure"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("TimeofDay", "TimeofDay"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("UnitOfMeasure", "UnitOfMeasure"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterMeasurementID", "WaterMeasurementID"),
                                                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Measurement", "Measurement")})});
     //
     // oleDbInsertCommand1
     //
     this.oleDbInsertCommand1.CommandText = @"INSERT INTO qryElectrofishingWaterMeasurements(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Comments, [Date], DrainageCd, Instrument, Measure, TimeofDay, UnitOfMeasure, WaterBodyID, WaterBodyName, Measurement) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 16, "Agency2SiteID"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 16, "AgencySiteID"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod"));
     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("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarWChar, 50, "Instrument"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measure", System.Data.OleDb.OleDbType.VarWChar, 50, "Measure"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "TimeofDay"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "UnitOfMeasure"));
     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, 40, "WaterBodyName"));
     this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measurement", System.Data.OleDb.OleDbType.Single, 0, "Measurement"));
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Comments, [Date], DrainageCd, Instrument, Measure, TimeofDay, UnitOfMeasure, WaterBodyID, WaterBodyName, WaterMeasurementID, Measurement FROM qryElectrofishingWaterMeasurements";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbInsertCommand6
     //
     this.oleDbInsertCommand6.CommandText = @"INSERT INTO qryElectrofishingWaterMeasurements(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Comments, [Date], DrainageCd, Instrument, Measure, TimeofDay, UnitOfMeasure, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand6.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "Agency2SiteID"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticMethod", System.Data.OleDb.OleDbType.VarWChar, 30, "AquaticMethod"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Instrument", System.Data.OleDb.OleDbType.VarWChar, 50, "Instrument"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("Measure", System.Data.OleDb.OleDbType.VarWChar, 50, "Measure"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "TimeofDay"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("UnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "UnitOfMeasure"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand6.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand6
     //
     this.oleDbSelectCommand6.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AquaticActivityID, AquaticMethod, AquaticSiteID, Comments, [Date], DrainageCd, Instrument, Measure, TimeofDay, UnitOfMeasure, WaterBodyID, WaterBodyName, WaterMeasurementID FROM qryElectrofishingWaterMeasurements";
     this.oleDbSelectCommand6.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryFishStockingSites
     //
     this.oleDbdaqryFishStockingSites.InsertCommand = this.oleDbInsertCommand19;
     this.oleDbdaqryFishStockingSites.SelectCommand = this.oleDbSelectCommand19;
     this.oleDbdaqryFishStockingSites.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                           new System.Data.Common.DataTableMapping("Table", "qryFishStockingSites", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("CoordinateSource", "CoordinateSource"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("CoordinateSystem", "CoordinateSystem"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("CoordinateUnits", "CoordinateUnits"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("Location", "Location"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("XCoordinate", "XCoordinate"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("YCoordinate", "YCoordinate"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("DataBegins", "DataBegins"),
                                                                                                                                                                                                                                   new System.Data.Common.DataColumnMapping("DataEnds", "DataEnds")})});
     //
     // oleDbInsertCommand19
     //
     this.oleDbInsertCommand19.CommandText = @"INSERT INTO qryFishStockingSites(AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, Location, WaterBodyID, XCoordinate, YCoordinate, DataBegins, DataEnds) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand19.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("Location", System.Data.OleDb.OleDbType.VarWChar, 100, "Location"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataBegins", System.Data.OleDb.OleDbType.VarChar, 255, "DataBegins"));
     this.oleDbInsertCommand19.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataEnds", System.Data.OleDb.OleDbType.VarChar, 255, "DataEnds"));
     //
     // oleDbSelectCommand19
     //
     this.oleDbSelectCommand19.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, " +
         "CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, Location, WaterBodyI" +
         "D, XCoordinate, YCoordinate, DataBegins, DataEnds FROM qryFishStockingSites";
     this.oleDbSelectCommand19.Connection = this.oleDbConnection1;
     //
     // dvqryElectrofishingSites
     //
     this.dvqryElectrofishingSites.Table = this.objdsqryElectrofishingSites.qryElectrofishingSites;
     //
     // objdsqryElectrofishingSites
     //
     this.objdsqryElectrofishingSites.DataSetName = "dsqryElectrofishingSites";
     this.objdsqryElectrofishingSites.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // dvqryElectrofishingDataPlusEstimates
     //
     this.dvqryElectrofishingDataPlusEstimates.Table = this.objdsqryElectrofishingDataPlusEstimates.qryElectrofishingDataPlusEstimates;
     //
     // dvqryElectrofishingMarkRecaptureDataPlusEstimates
     //
     this.dvqryElectrofishingMarkRecaptureDataPlusEstimates.Table = this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates.qryElectrofishingMarkRecaptureDataPlusEstimates;
     //
     // oleDbdaqryESASiteMeasurements
     //
     this.oleDbdaqryESASiteMeasurements.InsertCommand = this.oleDbInsertCommand9;
     this.oleDbdaqryESASiteMeasurements.SelectCommand = this.oleDbSelectCommand9;
     this.oleDbdaqryESASiteMeasurements.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                             new System.Data.Common.DataTableMapping("Table", "qryESASiteMeasurements", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Algae", "Algae"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticPlants", "AquaticPlants"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AveDepth_m", "AveDepth_m"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AveWidth_m", "AveWidth_m"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("BankSlope_Lt", "BankSlope_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("BankSlope_Rt", "BankSlope_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("BankStability", "BankStability"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Comments", "Comments"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DeadFish", "DeadFish"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("EmbeddedSub", "EmbeddedSub"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("FieldMeasureID", "FieldMeasureID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Foam", "Foam"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_AirTemp_C", "GW1_AirTemp_C"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_Conductivity", "GW1_Conductivity"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_DELGFieldNo", "GW1_DELGFieldNo"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_DissOxygen", "GW1_DissOxygen"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_Flow_cms", "GW1_Flow_cms"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_pH", "GW1_pH"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_TimeofDay", "GW1_TimeofDay"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW1_WaterTemp_C", "GW1_WaterTemp_C"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_AirTemp_C", "GW2_AirTemp_C"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_Conductivity", "GW2_Conductivity"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_DELGFieldNo", "GW2_DELGFieldNo"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_DissOxygen", "GW2_DissOxygen"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_Flow_cms", "GW2_Flow_cms"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_pH", "GW2_pH"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_TimeofDay", "GW2_TimeofDay"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("GW2_WaterTemp_C", "GW2_WaterTemp_C"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Length_m", "Length_m"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Odor", "Odor"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Other", "Other"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("OtherStreamType", "OtherStreamType"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("OtherSupp", "OtherSupp"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Petroleum", "Petroleum"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Altered_Lt", "RZ_Altered_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Altered_Rt", "RZ_Altered_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_ForageCrop_Lt", "RZ_ForageCrop_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_ForageCrop_Rt", "RZ_ForageCrop_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Hardwood_Lt", "RZ_Hardwood_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Hardwood_Rt", "RZ_Hardwood_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Lawn_Lt", "RZ_Lawn_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Lawn_Rt", "RZ_Lawn_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Meadow_Lt", "RZ_Meadow_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Meadow_Rt", "RZ_Meadow_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Mixed_Lt", "RZ_Mixed_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Mixed_Rt", "RZ_Mixed_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_RowCrop_Lt", "RZ_RowCrop_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_RowCrop_Rt", "RZ_RowCrop_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Shrubs_Lt", "RZ_Shrubs_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Shrubs_Rt", "RZ_Shrubs_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Softwood_Lt", "RZ_Softwood_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Softwood_Rt", "RZ_Softwood_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Wetland_Lt", "RZ_Wetland_Lt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("RZ_Wetland_Rt", "RZ_Wetland_Rt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_AirTemp_C", "ST_AirTemp_C"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_Conductivity", "ST_Conductivity"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_DELGFieldNo", "ST_DELGFieldNo"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_DissOxygen", "ST_DissOxygen"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_Flow_cms", "ST_Flow_cms"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_pH", "ST_pH"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_TimeofDay", "ST_TimeofDay"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ST_WaterTemp_C", "ST_WaterTemp_C"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("StreamCover", "StreamCover"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("StreamType", "StreamType"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("SuspendedSilt", "SuspendedSilt"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Velocity_mpers", "Velocity_mpers"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterClarity", "WaterClarity"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterColor", "WaterColor"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Weather_Current", "Weather_Current"),
                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Weather_Past", "Weather_Past")})});
     //
     // oleDbInsertCommand9
     //
     this.oleDbInsertCommand9.CommandText = @"INSERT INTO qryESASiteMeasurements(AgencyCd, AgencySiteID, Algae, AquaticActivityID, AquaticPlants, AquaticSiteID, AveDepth_m, AveWidth_m, BankSlope_Lt, BankSlope_Rt, BankStability, Comments, [Date], DeadFish, DrainageCd, EmbeddedSub, Foam, GW1_AirTemp_C, GW1_Conductivity, GW1_DELGFieldNo, GW1_DissOxygen, GW1_Flow_cms, GW1_pH, GW1_TimeofDay, GW1_WaterTemp_C, GW2_AirTemp_C, GW2_Conductivity, GW2_DELGFieldNo, GW2_DissOxygen, GW2_Flow_cms, GW2_pH, GW2_TimeofDay, GW2_WaterTemp_C, Length_m, Odor, Other, OtherStreamType, OtherSupp, Petroleum, RZ_Altered_Lt, RZ_Altered_Rt, RZ_ForageCrop_Lt, RZ_ForageCrop_Rt, RZ_Hardwood_Lt, RZ_Hardwood_Rt, RZ_Lawn_Lt, RZ_Lawn_Rt, RZ_Meadow_Lt, RZ_Meadow_Rt, RZ_Mixed_Lt, RZ_Mixed_Rt, RZ_RowCrop_Lt, RZ_RowCrop_Rt, RZ_Shrubs_Lt, RZ_Shrubs_Rt, RZ_Softwood_Lt, RZ_Softwood_Rt, RZ_Wetland_Lt, RZ_Wetland_Rt, ST_AirTemp_C, ST_Conductivity, ST_DELGFieldNo, ST_DissOxygen, ST_Flow_cms, ST_pH, ST_TimeofDay, ST_WaterTemp_C, StreamCover, StreamType, SuspendedSilt, Velocity_mpers, WaterBodyID, WaterBodyName, WaterClarity, WaterColor, Weather_Current, Weather_Past) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand9.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Algae", System.Data.OleDb.OleDbType.Boolean, 2, "Algae"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticPlants", System.Data.OleDb.OleDbType.Boolean, 2, "AquaticPlants"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveDepth_m", System.Data.OleDb.OleDbType.Single, 0, "AveDepth_m"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWidth_m", System.Data.OleDb.OleDbType.Single, 0, "AveWidth_m"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("BankSlope_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "BankSlope_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("BankSlope_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "BankSlope_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("BankStability", System.Data.OleDb.OleDbType.VarWChar, 20, "BankStability"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Comments", System.Data.OleDb.OleDbType.VarWChar, 250, "Comments"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("DeadFish", System.Data.OleDb.OleDbType.Boolean, 2, "DeadFish"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("EmbeddedSub", System.Data.OleDb.OleDbType.Boolean, 2, "EmbeddedSub"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Foam", System.Data.OleDb.OleDbType.Boolean, 2, "Foam"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "GW1_AirTemp_C"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_Conductivity", System.Data.OleDb.OleDbType.Single, 0, "GW1_Conductivity"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_DELGFieldNo", System.Data.OleDb.OleDbType.VarWChar, 50, "GW1_DELGFieldNo"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_DissOxygen", System.Data.OleDb.OleDbType.Single, 0, "GW1_DissOxygen"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_Flow_cms", System.Data.OleDb.OleDbType.Single, 0, "GW1_Flow_cms"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_pH", System.Data.OleDb.OleDbType.Single, 0, "GW1_pH"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "GW1_TimeofDay"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW1_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "GW1_WaterTemp_C"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "GW2_AirTemp_C"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_Conductivity", System.Data.OleDb.OleDbType.Single, 0, "GW2_Conductivity"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_DELGFieldNo", System.Data.OleDb.OleDbType.VarWChar, 50, "GW2_DELGFieldNo"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_DissOxygen", System.Data.OleDb.OleDbType.Single, 0, "GW2_DissOxygen"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_Flow_cms", System.Data.OleDb.OleDbType.Single, 0, "GW2_Flow_cms"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_pH", System.Data.OleDb.OleDbType.Single, 0, "GW2_pH"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "GW2_TimeofDay"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("GW2_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "GW2_WaterTemp_C"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Length_m", System.Data.OleDb.OleDbType.Single, 0, "Length_m"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Odor", System.Data.OleDb.OleDbType.Boolean, 2, "Odor"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Other", System.Data.OleDb.OleDbType.Boolean, 2, "Other"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherStreamType", System.Data.OleDb.OleDbType.VarWChar, 30, "OtherStreamType"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherSupp", System.Data.OleDb.OleDbType.VarWChar, 50, "OtherSupp"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Petroleum", System.Data.OleDb.OleDbType.Boolean, 2, "Petroleum"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Altered_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Altered_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Altered_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Altered_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_ForageCrop_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_ForageCrop_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_ForageCrop_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_ForageCrop_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Hardwood_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Hardwood_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Hardwood_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Hardwood_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Lawn_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Lawn_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Lawn_Rt", System.Data.OleDb.OleDbType.Single, 0, "RZ_Lawn_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Meadow_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Meadow_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Meadow_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Meadow_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Mixed_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Mixed_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Mixed_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Mixed_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_RowCrop_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_RowCrop_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_RowCrop_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_RowCrop_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Shrubs_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Shrubs_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Shrubs_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Shrubs_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Softwood_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Softwood_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Softwood_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Softwood_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Wetland_Lt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Wetland_Lt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("RZ_Wetland_Rt", System.Data.OleDb.OleDbType.SmallInt, 0, "RZ_Wetland_Rt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "ST_AirTemp_C"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_Conductivity", System.Data.OleDb.OleDbType.Single, 0, "ST_Conductivity"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_DELGFieldNo", System.Data.OleDb.OleDbType.VarWChar, 50, "ST_DELGFieldNo"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_DissOxygen", System.Data.OleDb.OleDbType.Single, 0, "ST_DissOxygen"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_Flow_cms", System.Data.OleDb.OleDbType.Single, 0, "ST_Flow_cms"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_pH", System.Data.OleDb.OleDbType.Single, 0, "ST_pH"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "ST_TimeofDay"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("ST_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "ST_WaterTemp_C"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("StreamCover", System.Data.OleDb.OleDbType.VarWChar, 10, "StreamCover"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("StreamType", System.Data.OleDb.OleDbType.VarWChar, 10, "StreamType"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("SuspendedSilt", System.Data.OleDb.OleDbType.Boolean, 2, "SuspendedSilt"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Velocity_mpers", System.Data.OleDb.OleDbType.Single, 0, "Velocity_mpers"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterClarity", System.Data.OleDb.OleDbType.VarWChar, 16, "WaterClarity"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterColor", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterColor"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Weather_Current", System.Data.OleDb.OleDbType.VarWChar, 20, "Weather_Current"));
     this.oleDbInsertCommand9.Parameters.Add(new System.Data.OleDb.OleDbParameter("Weather_Past", System.Data.OleDb.OleDbType.VarWChar, 20, "Weather_Past"));
     //
     // oleDbSelectCommand9
     //
     this.oleDbSelectCommand9.CommandText = @"SELECT AgencyCd, AgencySiteID, Algae, AquaticActivityID, AquaticPlants, AquaticSiteID, AveDepth_m, AveWidth_m, BankSlope_Lt, BankSlope_Rt, BankStability, Comments, [Date], DeadFish, DrainageCd, EmbeddedSub, FieldMeasureID, Foam, GW1_AirTemp_C, GW1_Conductivity, GW1_DELGFieldNo, GW1_DissOxygen, GW1_Flow_cms, GW1_pH, GW1_TimeofDay, GW1_WaterTemp_C, GW2_AirTemp_C, GW2_Conductivity, GW2_DELGFieldNo, GW2_DissOxygen, GW2_Flow_cms, GW2_pH, GW2_TimeofDay, GW2_WaterTemp_C, Length_m, Odor, Other, OtherStreamType, OtherSupp, Petroleum, RZ_Altered_Lt, RZ_Altered_Rt, RZ_ForageCrop_Lt, RZ_ForageCrop_Rt, RZ_Hardwood_Lt, RZ_Hardwood_Rt, RZ_Lawn_Lt, RZ_Lawn_Rt, RZ_Meadow_Lt, RZ_Meadow_Rt, RZ_Mixed_Lt, RZ_Mixed_Rt, RZ_RowCrop_Lt, RZ_RowCrop_Rt, RZ_Shrubs_Lt, RZ_Shrubs_Rt, RZ_Softwood_Lt, RZ_Softwood_Rt, RZ_Wetland_Lt, RZ_Wetland_Rt, ST_AirTemp_C, ST_Conductivity, ST_DELGFieldNo, ST_DissOxygen, ST_Flow_cms, ST_pH, ST_TimeofDay, ST_WaterTemp_C, StreamCover, StreamType, SuspendedSilt, Velocity_mpers, WaterBodyID, WaterBodyName, WaterClarity, WaterColor, Weather_Current, Weather_Past FROM qryESASiteMeasurements";
     this.oleDbSelectCommand9.Connection = this.oleDbConnection1;
     //
     // dvqryESAPlanning
     //
     this.dvqryESAPlanning.Table = this.objdsqryESAPlanning.qryESAPlanning;
     //
     // objdsqryESAPlanning
     //
     this.objdsqryESAPlanning.DataSetName = "dsqryESAPlanning";
     this.objdsqryESAPlanning.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // oleDbdaqryESAObservations
     //
     this.oleDbdaqryESAObservations.InsertCommand = this.oleDbInsertCommand7;
     this.oleDbdaqryESAObservations.SelectCommand = this.oleDbSelectCommand7;
     this.oleDbdaqryESAObservations.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                         new System.Data.Common.DataTableMapping("Table", "qryESAObservations", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("EnvObservationID", "EnvObservationID"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("FishPassageObstructionInd", "FishPassageObstructionInd"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("Observation", "Observation"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("ObservationGroup", "ObservationGroup"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("OtherObservation", "OtherObservation"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("PipeSize_cm", "PipeSize_cm"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                               new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName")})});
     //
     // oleDbInsertCommand7
     //
     this.oleDbInsertCommand7.CommandText = @"INSERT INTO qryESAObservations(AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, [Date], DrainageCd, FishPassageObstructionInd, Observation, ObservationGroup, OtherObservation, PipeSize_cm, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand7.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishPassageObstructionInd", System.Data.OleDb.OleDbType.Boolean, 2, "FishPassageObstructionInd"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("Observation", System.Data.OleDb.OleDbType.VarWChar, 50, "Observation"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("ObservationGroup", System.Data.OleDb.OleDbType.VarWChar, 50, "ObservationGroup"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("OtherObservation", System.Data.OleDb.OleDbType.VarWChar, 50, "OtherObservation"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("PipeSize_cm", System.Data.OleDb.OleDbType.Integer, 0, "PipeSize_cm"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand7.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand7
     //
     this.oleDbSelectCommand7.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, [Date], Drainage" +
         "Cd, EnvObservationID, FishPassageObstructionInd, Observation, ObservationGroup, " +
         "OtherObservation, PipeSize_cm, WaterBodyID, WaterBodyName FROM qryESAObservation" +
         "s";
     this.oleDbSelectCommand7.Connection = this.oleDbConnection1;
     //
     // dvqryESASites
     //
     this.dvqryESASites.Table = this.objdsqryESASites.qryESASites;
     //
     // objdsqryESASites
     //
     this.objdsqryESASites.DataSetName = "dsqryESASites";
     this.objdsqryESASites.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // objdsqryESAObservations
     //
     this.objdsqryESAObservations.DataSetName = "dsqryESAObservations";
     this.objdsqryESAObservations.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // oleDbdaqryESASites
     //
     this.oleDbdaqryESASites.InsertCommand = this.oleDbInsertCommand21;
     this.oleDbdaqryESASites.SelectCommand = this.oleDbSelectCommand21;
     this.oleDbdaqryESASites.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                  new System.Data.Common.DataTableMapping("Table", "qryESASites", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                 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("Date", "Date"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("NoActionItems", "NoActionItems"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("NoCompleted", "NoCompleted"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("NoFollowUp", "NoFollowUp"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("SiteType", "SiteType"),
                                                                                                                                                                                                                 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"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("DataBegins", "DataBegins"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("DataEnds", "DataEnds")})});
     //
     // oleDbInsertCommand21
     //
     this.oleDbInsertCommand21.CommandText = @"INSERT INTO qryESASites(AgencyCd, AgencySiteID, AquaticSiteID, CoordinateSource, CoordinateSystem, CoordinateUnits, [Date], DrainageCd, NoActionItems, NoCompleted, NoFollowUp, SiteType, WaterBodyID, WaterBodyName, XCoordinate, YCoordinate, DataBegins, DataEnds) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand21.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoActionItems", System.Data.OleDb.OleDbType.Integer, 0, "NoActionItems"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoCompleted", System.Data.OleDb.OleDbType.Integer, 0, "NoCompleted"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoFollowUp", System.Data.OleDb.OleDbType.Integer, 0, "NoFollowUp"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("SiteType", System.Data.OleDb.OleDbType.VarWChar, 40, "SiteType"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataBegins", System.Data.OleDb.OleDbType.VarWChar, 255, "DataBegins"));
     this.oleDbInsertCommand21.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataEnds", System.Data.OleDb.OleDbType.VarWChar, 255, "DataEnds"));
     //
     // oleDbSelectCommand21
     //
     this.oleDbSelectCommand21.CommandText = @"SELECT AgencyCd, AgencySiteID, AquaticSiteID, CoordinateSource, CoordinateSystem, CoordinateUnits, [Date], DrainageCd, NoActionItems, NoCompleted, NoFollowUp, SiteType, WaterBodyID, WaterBodyName, XCoordinate, YCoordinate, DataBegins, DataEnds FROM qryESASites";
     this.oleDbSelectCommand21.Connection = this.oleDbConnection1;
     //
     // objdsqryESASiteMeasurements
     //
     this.objdsqryESASiteMeasurements.DataSetName = "dsqryESASiteMeasurements";
     this.objdsqryESASiteMeasurements.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // dvqryESASiteMeasurements
     //
     this.dvqryESASiteMeasurements.Table = this.objdsqryESASiteMeasurements.qryESASiteMeasurements;
     //
     // dvqryESAObservations
     //
     this.dvqryESAObservations.Table = this.objdsqryESAObservations.qryESAObservations;
     //
     // oleDbdaqryESAPlanning
     //
     this.oleDbdaqryESAPlanning.InsertCommand = this.oleDbInsertCommand8;
     this.oleDbdaqryESAPlanning.SelectCommand = this.oleDbSelectCommand8;
     this.oleDbdaqryESAPlanning.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                     new System.Data.Common.DataTableMapping("Table", "qryESAPlanning", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ActionCompletionDate", "ActionCompletionDate"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ActionPriority", "ActionPriority"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ActionRequired", "ActionRequired"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ActionTargetDate", "ActionTargetDate"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("EnvPlanningID", "EnvPlanningID"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("FollowUpCompletionDate", "FollowUpCompletionDate"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("FollowUpRequired", "FollowUpRequired"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("FollowUpTargetDate", "FollowUpTargetDate"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("Issue", "Issue"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("IssueCategory", "IssueCategory"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName")})});
     //
     // oleDbInsertCommand8
     //
     this.oleDbInsertCommand8.CommandText = @"INSERT INTO qryESAPlanning(ActionCompletionDate, ActionPriority, ActionRequired, ActionTargetDate, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, [Date], DrainageCd, FollowUpCompletionDate, FollowUpRequired, FollowUpTargetDate, Issue, IssueCategory, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand8.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActionCompletionDate", System.Data.OleDb.OleDbType.DBDate, 0, "ActionCompletionDate"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActionPriority", System.Data.OleDb.OleDbType.SmallInt, 0, "ActionPriority"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActionRequired", System.Data.OleDb.OleDbType.VarWChar, 250, "ActionRequired"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActionTargetDate", System.Data.OleDb.OleDbType.DBDate, 0, "ActionTargetDate"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("FollowUpCompletionDate", System.Data.OleDb.OleDbType.DBDate, 0, "FollowUpCompletionDate"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("FollowUpRequired", System.Data.OleDb.OleDbType.Boolean, 2, "FollowUpRequired"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("FollowUpTargetDate", System.Data.OleDb.OleDbType.DBDate, 0, "FollowUpTargetDate"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("Issue", System.Data.OleDb.OleDbType.VarWChar, 250, "Issue"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("IssueCategory", System.Data.OleDb.OleDbType.VarWChar, 50, "IssueCategory"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand8.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand8
     //
     this.oleDbSelectCommand8.CommandText = @"SELECT ActionCompletionDate, ActionPriority, ActionRequired, ActionTargetDate, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, [Date], DrainageCd, EnvPlanningID, FollowUpCompletionDate, FollowUpRequired, FollowUpTargetDate, Issue, IssueCategory, WaterBodyID, WaterBodyName FROM qryESAPlanning";
     this.oleDbSelectCommand8.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryFishStocking
     //
     this.oleDbdaqryFishStocking.InsertCommand = this.oleDbInsertCommand11;
     this.oleDbdaqryFishStocking.SelectCommand = this.oleDbSelectCommand11;
     this.oleDbdaqryFishStocking.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                      new System.Data.Common.DataTableMapping("Table", "qryFishStocking", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Agency2Cd", "Agency2Cd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Agency2Contact", "Agency2Contact"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Agency2SiteID", "Agency2SiteID"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AgeUnitOfMeasure", "AgeUnitOfMeasure"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AirTemp_C", "AirTemp_C"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AppliedMarkCd", "AppliedMarkCd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AveLength_cm", "AveLength_cm"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("AveWeight_gm", "AveWeight_gm"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("BroodstockInd", "BroodstockInd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Crew", "Crew"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishAge", "FishAge"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishAgeClass", "FishAgeClass"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishMark", "FishMark"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishSpecies", "FishSpecies"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishSpeciesCd", "FishSpeciesCd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishStockingID", "FishStockingID"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishStockName", "FishStockName"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("FishTankNo", "FishTankNo"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("LengthRange_cm", "LengthRange_cm"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Location", "Location"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("NoFish", "NoFish"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("PermitNo", "PermitNo"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("SatelliteRearedInd", "SatelliteRearedInd"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Source", "Source"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("TimeofDay", "TimeofDay"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("WaterLevel", "WaterLevel"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("WaterTemp_C", "WaterTemp_C"),
                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("WeightRange_gm", "WeightRange_gm")})});
     //
     // oleDbInsertCommand11
     //
     this.oleDbInsertCommand11.CommandText = @"INSERT INTO qryFishStocking(Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AgeUnitOfMeasure, AirTemp_C, AppliedMarkCd, AquaticSiteID, AveLength_cm, AveWeight_gm, BroodstockInd, Crew, [Date], DrainageCd, FishAge, FishAgeClass, FishMark, FishSpecies, FishSpeciesCd, FishStockName, FishTankNo, LengthRange_cm, Location, NoFish, PermitNo, SatelliteRearedInd, Source, TimeofDay, WaterBodyID, WaterLevel, WaterTemp_C, WeightRange_gm) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand11.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Cd", System.Data.OleDb.OleDbType.VarWChar, 4, "Agency2Cd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2Contact", System.Data.OleDb.OleDbType.VarWChar, 50, "Agency2Contact"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency2SiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "Agency2SiteID"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgeUnitOfMeasure", System.Data.OleDb.OleDbType.VarWChar, 10, "AgeUnitOfMeasure"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "AirTemp_C"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AppliedMarkCd", System.Data.OleDb.OleDbType.Integer, 0, "AppliedMarkCd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveLength_cm", System.Data.OleDb.OleDbType.Double, 0, "AveLength_cm"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveWeight_gm", System.Data.OleDb.OleDbType.Double, 0, "AveWeight_gm"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("BroodstockInd", System.Data.OleDb.OleDbType.Boolean, 2, "BroodstockInd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Crew", System.Data.OleDb.OleDbType.VarWChar, 50, "Crew"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAge", System.Data.OleDb.OleDbType.VarWChar, 10, "FishAge"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishAgeClass", System.Data.OleDb.OleDbType.VarWChar, 20, "FishAgeClass"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishMark", System.Data.OleDb.OleDbType.VarWChar, 50, "FishMark"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpecies", System.Data.OleDb.OleDbType.VarWChar, 30, "FishSpecies"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishSpeciesCd", System.Data.OleDb.OleDbType.VarWChar, 2, "FishSpeciesCd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishStockName", System.Data.OleDb.OleDbType.VarWChar, 150, "FishStockName"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("FishTankNo", System.Data.OleDb.OleDbType.VarWChar, 2, "FishTankNo"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("LengthRange_cm", System.Data.OleDb.OleDbType.VarWChar, 20, "LengthRange_cm"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Location", System.Data.OleDb.OleDbType.VarWChar, 100, "Location"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("NoFish", System.Data.OleDb.OleDbType.Integer, 0, "NoFish"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("PermitNo", System.Data.OleDb.OleDbType.VarWChar, 20, "PermitNo"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("SatelliteRearedInd", System.Data.OleDb.OleDbType.Boolean, 2, "SatelliteRearedInd"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("Source", System.Data.OleDb.OleDbType.VarWChar, 50, "Source"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 6, "TimeofDay"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel", System.Data.OleDb.OleDbType.VarWChar, 6, "WaterLevel"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "WaterTemp_C"));
     this.oleDbInsertCommand11.Parameters.Add(new System.Data.OleDb.OleDbParameter("WeightRange_gm", System.Data.OleDb.OleDbType.VarWChar, 20, "WeightRange_gm"));
     //
     // oleDbSelectCommand11
     //
     this.oleDbSelectCommand11.CommandText = @"SELECT Agency2Cd, Agency2Contact, Agency2SiteID, AgencyCd, AgencySiteID, AgeUnitOfMeasure, AirTemp_C, AppliedMarkCd, AquaticSiteID, AveLength_cm, AveWeight_gm, BroodstockInd, Crew, [Date], DrainageCd, FishAge, FishAgeClass, FishMark, FishSpecies, FishSpeciesCd, FishStockingID, FishStockName, FishTankNo, LengthRange_cm, Location, NoFish, PermitNo, SatelliteRearedInd, Source, TimeofDay, WaterBodyID, WaterLevel, WaterTemp_C, WeightRange_gm FROM qryFishStocking";
     this.oleDbSelectCommand11.Connection = this.oleDbConnection1;
     //
     // dvqryFishStockingSites
     //
     this.dvqryFishStockingSites.Table = this.objdsqryFishStockingSites.qryFishStockingSites;
     //
     // objdsqryFishStockingSites
     //
     this.objdsqryFishStockingSites.DataSetName = "dsqryFishStockingSites";
     this.objdsqryFishStockingSites.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // objdsqryFishStocking
     //
     this.objdsqryFishStocking.DataSetName = "dsqryFishStocking";
     this.objdsqryFishStocking.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // dvqryFishStocking
     //
     this.dvqryFishStocking.Table = this.objdsqryFishStocking.qryFishStocking;
     //
     // oleDbCommand1
     //
     this.oleDbCommand1.CommandText = @"INSERT INTO qryFishStockingSites(AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, Location, WaterBodyID, XCoordinate, YCoordinate, DataBegins, DataEnds) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbCommand1.Connection = this.oleDbConnection1;
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Location", System.Data.OleDb.OleDbType.VarWChar, 100, "Location"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataBegins", System.Data.OleDb.OleDbType.VarChar, 255, "DataBegins"));
     this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataEnds", System.Data.OleDb.OleDbType.VarChar, 255, "DataEnds"));
     //
     // oleDbCommand2
     //
     this.oleDbCommand2.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, " +
         "CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, Location, WaterBodyI" +
         "D, XCoordinate, YCoordinate, DataBegins, DataEnds FROM qryFishStockingSites";
     this.oleDbCommand2.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryWaterTemperatureLoggerDetails
     //
     this.oleDbdaqryWaterTemperatureLoggerDetails.InsertCommand = this.oleDbInsertCommand13;
     this.oleDbdaqryWaterTemperatureLoggerDetails.SelectCommand = this.oleDbSelectCommand13;
     this.oleDbdaqryWaterTemperatureLoggerDetails.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                       new System.Data.Common.DataTableMapping("Table", "qryWaterTemperatureLoggerDetails", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Accuracy", "Accuracy"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("AquaticSiteName", "AquaticSiteName"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("BrandName", "BrandName"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("DataFileName", "DataFileName"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("DistanceFromLeftBank_m", "DistanceFromLeftBank_m"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("DistanceFromRightBank_m", "DistanceFromRightBank_m"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Install_AirTemp_C", "Install_AirTemp_C"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Install_TimeofDay", "Install_TimeofDay"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Install_WaterTemp_C", "Install_WaterTemp_C"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("InstallationDate", "InstallationDate"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("LoggerNo", "LoggerNo"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Model", "Model"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("RecordingEndDate", "RecordingEndDate"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("RecordingStartDate", "RecordingStartDate"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Removal_AirTemp_C", "Removal_AirTemp_C"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Removal_TimeofDay", "Removal_TimeofDay"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Removal_WaterTemp_C", "Removal_WaterTemp_C"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("RemovalDate", "RemovalDate"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("Resolution", "Resolution"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("SampleInterval_min", "SampleInterval_min"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("TemperatureLoggerID", "TemperatureLoggerID"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("TempRange_From", "TempRange_From"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("TempRange_To", "TempRange_To"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("WaterDepth_cm", "WaterDepth_cm"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("WaterLevel_Install", "WaterLevel_Install"),
                                                                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("WaterLevel_Removal", "WaterLevel_Removal")})});
     //
     // oleDbInsertCommand13
     //
     this.oleDbInsertCommand13.CommandText = @"INSERT INTO qryWaterTemperatureLoggerDetails(Accuracy, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, AquaticSiteName, BrandName, DataFileName, DistanceFromLeftBank_m, DistanceFromRightBank_m, DrainageCd, HabitatDesc, Install_AirTemp_C, Install_TimeofDay, Install_WaterTemp_C, InstallationDate, LoggerNo, Model, RecordingEndDate, RecordingStartDate, Removal_AirTemp_C, Removal_TimeofDay, Removal_WaterTemp_C, RemovalDate, Resolution, SampleInterval_min, TempRange_From, TempRange_To, WaterBodyID, WaterBodyName, WaterDepth_cm, WaterLevel_Install, WaterLevel_Removal) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand13.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Accuracy", System.Data.OleDb.OleDbType.VarWChar, 20, "Accuracy"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("BrandName", System.Data.OleDb.OleDbType.VarWChar, 30, "BrandName"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataFileName", System.Data.OleDb.OleDbType.VarWChar, 30, "DataFileName"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("DistanceFromLeftBank_m", System.Data.OleDb.OleDbType.Integer, 0, "DistanceFromLeftBank_m"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("DistanceFromRightBank_m", System.Data.OleDb.OleDbType.Integer, 0, "DistanceFromRightBank_m"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Install_AirTemp_C"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "Install_TimeofDay"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Install_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Install_WaterTemp_C"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("InstallationDate", System.Data.OleDb.OleDbType.VarWChar, 10, "InstallationDate"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("LoggerNo", System.Data.OleDb.OleDbType.VarWChar, 20, "LoggerNo"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Model", System.Data.OleDb.OleDbType.VarWChar, 20, "Model"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecordingEndDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RecordingEndDate"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("RecordingStartDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RecordingStartDate"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_AirTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Removal_AirTemp_C"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_TimeofDay", System.Data.OleDb.OleDbType.VarWChar, 5, "Removal_TimeofDay"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Removal_WaterTemp_C", System.Data.OleDb.OleDbType.Single, 0, "Removal_WaterTemp_C"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("RemovalDate", System.Data.OleDb.OleDbType.VarWChar, 10, "RemovalDate"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("Resolution", System.Data.OleDb.OleDbType.VarWChar, 20, "Resolution"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("SampleInterval_min", System.Data.OleDb.OleDbType.Single, 0, "SampleInterval_min"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("TempRange_From", System.Data.OleDb.OleDbType.Integer, 0, "TempRange_From"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("TempRange_To", System.Data.OleDb.OleDbType.Integer, 0, "TempRange_To"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 55, "WaterBodyName"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterDepth_cm", System.Data.OleDb.OleDbType.Integer, 0, "WaterDepth_cm"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_Install", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterLevel_Install"));
     this.oleDbInsertCommand13.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterLevel_Removal", System.Data.OleDb.OleDbType.VarWChar, 10, "WaterLevel_Removal"));
     //
     // oleDbSelectCommand13
     //
     this.oleDbSelectCommand13.CommandText = @"SELECT Accuracy, AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, AquaticSiteName, BrandName, DataFileName, DistanceFromLeftBank_m, DistanceFromRightBank_m, DrainageCd, HabitatDesc, Install_AirTemp_C, Install_TimeofDay, Install_WaterTemp_C, InstallationDate, LoggerNo, Model, RecordingEndDate, RecordingStartDate, Removal_AirTemp_C, Removal_TimeofDay, Removal_WaterTemp_C, RemovalDate, Resolution, SampleInterval_min, TemperatureLoggerID, TempRange_From, TempRange_To, WaterBodyID, WaterBodyName, WaterDepth_cm, WaterLevel_Install, WaterLevel_Removal FROM qryWaterTemperatureLoggerDetails";
     this.oleDbSelectCommand13.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryWaterTemperatureLoggerSites
     //
     this.oleDbdaqryWaterTemperatureLoggerSites.InsertCommand = this.oleDbInsertCommand22;
     this.oleDbdaqryWaterTemperatureLoggerSites.SelectCommand = this.oleDbSelectCommand22;
     this.oleDbdaqryWaterTemperatureLoggerSites.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                     new System.Data.Common.DataTableMapping("Table", "qryWaterTemperatureLoggerSites", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CoordinateSource", "CoordinateSource"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CoordinateSystem", "CoordinateSystem"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("CoordinateUnits", "CoordinateUnits"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("HabitatDesc", "HabitatDesc"),
                                                                                                                                                                                                                                                       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"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DataBegins", "DataBegins"),
                                                                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DataEnds", "DataEnds")})});
     //
     // oleDbInsertCommand22
     //
     this.oleDbInsertCommand22.CommandText = @"INSERT INTO qryWaterTemperatureLoggerSites(AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, WaterBodyID, WaterBodyName, XCoordinate, YCoordinate, DataBegins, DataEnds) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand22.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSource", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSource"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateSystem", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateSystem"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("CoordinateUnits", System.Data.OleDb.OleDbType.VarWChar, 50, "CoordinateUnits"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("HabitatDesc", System.Data.OleDb.OleDbType.VarWChar, 50, "HabitatDesc"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("XCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "XCoordinate"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("YCoordinate", System.Data.OleDb.OleDbType.VarWChar, 50, "YCoordinate"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataBegins", System.Data.OleDb.OleDbType.VarWChar, 255, "DataBegins"));
     this.oleDbInsertCommand22.Parameters.Add(new System.Data.OleDb.OleDbParameter("DataEnds", System.Data.OleDb.OleDbType.VarWChar, 255, "DataEnds"));
     //
     // oleDbSelectCommand22
     //
     this.oleDbSelectCommand22.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticSiteDesc, AquaticSiteID, CoordinateSource, " +
         "CoordinateSystem, CoordinateUnits, DrainageCd, HabitatDesc, WaterBodyID, WaterBo" +
         "dyName, XCoordinate, YCoordinate, DataBegins, DataEnds FROM qryWaterTemperatureL" +
         "oggerSites";
     this.oleDbSelectCommand22.Connection = this.oleDbConnection1;
     //
     // oleDbdaqryWaterTemperatureLoggerMeasurements
     //
     this.oleDbdaqryWaterTemperatureLoggerMeasurements.InsertCommand = this.oleDbInsertCommand14;
     this.oleDbdaqryWaterTemperatureLoggerMeasurements.SelectCommand = this.oleDbSelectCommand14;
     this.oleDbdaqryWaterTemperatureLoggerMeasurements.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                            new System.Data.Common.DataTableMapping("Table", "qryWaterTemperatureLoggerMeasurements", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("AquaticActivityID", "AquaticActivityID"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("AquaticSiteName", "AquaticSiteName"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("AveTemp_C", "AveTemp_C"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("Date", "Date"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("MaxTemp_C", "MaxTemp_C"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("MinTemp_C", "MinTemp_C"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("TemperatureLoggerID", "TemperatureLoggerID"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
                                                                                                                                                                                                                                                                     new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName")})});
     //
     // oleDbInsertCommand14
     //
     this.oleDbInsertCommand14.CommandText = @"INSERT INTO qryWaterTemperatureLoggerMeasurements(AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, AquaticSiteName, AveTemp_C, [Date], DrainageCd, MaxTemp_C, MinTemp_C, TemperatureLoggerID, WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     this.oleDbInsertCommand14.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticActivityID"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("AveTemp_C", System.Data.OleDb.OleDbType.Single, 0, "AveTemp_C"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date", System.Data.OleDb.OleDbType.VarWChar, 10, "Date"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("MaxTemp_C", System.Data.OleDb.OleDbType.Single, 0, "MaxTemp_C"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("MinTemp_C", System.Data.OleDb.OleDbType.Single, 0, "MinTemp_C"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("TemperatureLoggerID", System.Data.OleDb.OleDbType.Integer, 0, "TemperatureLoggerID"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
     this.oleDbInsertCommand14.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName"));
     //
     // oleDbSelectCommand14
     //
     this.oleDbSelectCommand14.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivityID, AquaticSiteID, AquaticSiteName," +
         " AveTemp_C, [Date], DrainageCd, MaxTemp_C, MinTemp_C, TemperatureLoggerID, Water" +
         "BodyID, WaterBodyName FROM qryWaterTemperatureLoggerMeasurements";
     this.oleDbSelectCommand14.Connection = this.oleDbConnection1;
     //
     // dvqryWaterTemperatureLoggerDetails
     //
     this.dvqryWaterTemperatureLoggerDetails.Table = this.objdsqryWaterTemperatureLoggerDetails.qryWaterTemperatureLoggerDetails;
     //
     // objdsqryWaterTemperatureLoggerDetails
     //
     this.objdsqryWaterTemperatureLoggerDetails.DataSetName = "dsqryWaterTemperatureLoggerDetails";
     this.objdsqryWaterTemperatureLoggerDetails.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // dvqryWaterTemperatureLoggerMeasurements
     //
     this.dvqryWaterTemperatureLoggerMeasurements.Table = this.objdsqryWaterTemperatureLoggerMeasurements.qryWaterTemperatureLoggerMeasurements;
     //
     // objdsqryWaterTemperatureLoggerMeasurements
     //
     this.objdsqryWaterTemperatureLoggerMeasurements.DataSetName = "dsqryWaterTemperatureLoggerMeasurements";
     this.objdsqryWaterTemperatureLoggerMeasurements.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // objdsqryWaterTemperatureLoggerSites
     //
     this.objdsqryWaterTemperatureLoggerSites.DataSetName = "dsqryWaterTemperatureLoggerSites";
     this.objdsqryWaterTemperatureLoggerSites.Locale = new System.Globalization.CultureInfo("en-US");
     //
     // dvqryWaterTemperatureLoggerSites
     //
     this.dvqryWaterTemperatureLoggerSites.Table = this.objdsqryWaterTemperatureLoggerSites.qryWaterTemperatureLoggerSites;
     //
     // oleDbSelectCommand12
     //
     this.oleDbSelectCommand12.CommandText = "SELECT Agency, AgencyCd FROM [DE-Agencies]";
     this.oleDbSelectCommand12.Connection = this.oleDbConnection1;
     //
     // oleDbInsertCommand12
     //
     this.oleDbInsertCommand12.CommandText = "INSERT INTO [DE-Agencies] (Agency, AgencyCd) VALUES (?, ?)";
     this.oleDbInsertCommand12.Connection = this.oleDbConnection1;
     this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("Agency", System.Data.OleDb.OleDbType.VarWChar, 60, "Agency"));
     this.oleDbInsertCommand12.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 5, "AgencyCd"));
     //
     // objdsDE_Agencies
     //
     this.objdsDE_Agencies.DataSetName = "dsDE_Agencies";
     this.objdsDE_Agencies.Locale = new System.Globalization.CultureInfo("en-US");
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingMethodDetails)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingMethodDetails)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingWaterMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingWaterMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingMarkRecaptureDataPlusEstimates)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingDataPlusEstimates)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingSiteMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingSiteMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingSites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryElectrofishingSites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingDataPlusEstimates)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryElectrofishingMarkRecaptureDataPlusEstimates)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESAPlanning)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESAPlanning)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESASites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESASites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESAObservations)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryESASiteMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESASiteMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryESAObservations)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryFishStockingSites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryFishStockingSites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryFishStocking)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryFishStocking)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryWaterTemperatureLoggerDetails)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryWaterTemperatureLoggerDetails)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryWaterTemperatureLoggerMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryWaterTemperatureLoggerMeasurements)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsqryWaterTemperatureLoggerSites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvqryWaterTemperatureLoggerSites)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.objdsDE_Agencies)).EndInit();
 }