public void FilltblEnvironmentalSurveyFieldMeasures(NBADWDataEntryApplication.dstblEnvironmentalSurveyFieldMeasures dataSet)
 {
     // Turn off constraint checking before the dataset is filled.
     // This allows the adapters to fill the dataset without concern
     // for dependencies between the tables.
     dataSet.EnforceConstraints = false;
     try
     {
         // Open the connection.
         this.oleDbConnection1.Open();
         // Attempt to fill the dataset through the OleDbDataAdapter1.
         this.oleDbdatblEnvironmentalSurveyFieldMeasures.Fill(dataSet);
     }
     catch (System.Exception fillException)
     {
         // Add your error handling code here.
         throw fillException;
     }
     finally
     {
         // Turn constraint checking back on.
         dataSet.EnforceConstraints = true;
         // Close the connection whether or not the exception was thrown.
         this.oleDbConnection1.Close();
     }
 }
Пример #2
0
 public void FillDataSet(NBADWDataEntryApplication.dsSiteUseSearch dataSet1)
 {
     // Turn off constraint checking before the dataset is filled.
     // This allows the adapters to fill the dataset without concern
     // for dependencies between the tables.
     dataSet1.EnforceConstraints = false;
     //dataSet2.EnforceConstraints = false;
     try
     {
         // Open the connection.
         this.oleDbConnection1.Open();
         // Attempt to fill the dataset through the OleDbDataAdapter1.
         this.oleDbdaSiteUseSearch.Fill(dataSet1);
         //this.oleDbdacdAquaticActivity.Fill(dataSet2);
     }
     catch (System.Exception fillException)
     {
         // Add your error handling code here.
         throw fillException;
     }
     finally
     {
         // Turn constraint checking back on.
         dataSet1.EnforceConstraints = true;
         //dataSet2.EnforceConstraints = true;
         // Close the connection whether or not the exception was thrown.
         this.oleDbConnection1.Close();
     }
 }
Пример #3
0
        public void FillDataSets(NBADWDataEntryApplication.dsDE_ESAFSiteList dataSet1)
        {
            // Turn off constraint checking before the dataset is filled.
            // This allows the adapters to fill the dataset without concern
            // for dependencies between the tables.
            dataSet1.EnforceConstraints = false;
            try
            {
                // Open the connection.
                this.oleDbConnection1.Open();
                // Attempt to fill the dataset through the OleDbDataAdapter1.
                this.oleDbdaDE_ESAFSiteList.Fill(dataSet1);
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }
            finally
            {
                // Turn constraint checking back on.
                dataSet1.EnforceConstraints = true;
                // Close the connection whether or not the exception was thrown.
                this.oleDbConnection1.Close();

                System.IO.StringWriter sw1 = new System.IO.StringWriter();

                // Write the DataSet to the ViewState property.
                dataSet1.WriteXml(sw1);
                ViewState["dSet1"] = sw1.ToString();
            }
        }
        public void FillDataSets(NBADWDataEntryApplication.dscdEnvironmentalObservations_Groups dataSet1, NBADWDataEntryApplication.dscdEnvironmentalObservations dataSet2, NBADWDataEntryApplication.dstblEnvironmentalObservations dataSet3)
        {
            // Turn off constraint checking before the dataset is filled.
            // This allows the adapters to fill the dataset without concern
            // for dependencies between the tables.
            dataSet1.EnforceConstraints = false;
            dataSet2.EnforceConstraints = false;
            dataSet3.EnforceConstraints = false;
            try
            {
                // Open the connection.
                this.oleDbConnection1.Open();
                // Attempt to fill the dataset through the OleDbDataAdapter1.
                this.oleDbdacdEnvironmentalObservations_Groups.Fill(dataSet1);
                this.oleDbdacdEnvironmentalObservations.Fill(dataSet2);
                this.oleDbdatblEnvironmentalObservations.Fill(dataSet3);
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }
            finally
            {
                // Turn constraint checking back on.
                dataSet1.EnforceConstraints = true;
                dataSet2.EnforceConstraints = true;
                dataSet3.EnforceConstraints = true;
                // Close the connection whether or not the exception was thrown.
                this.oleDbConnection1.Close();

                System.IO.StringWriter sw1 = new System.IO.StringWriter();
                System.IO.StringWriter sw2 = new System.IO.StringWriter();
                //System.IO.StringWriter sw3 = new System.IO.StringWriter();

                // Write the DataSet to the ViewState property.
                dataSet1.WriteXml(sw1);
                dataSet2.WriteXml(sw2);
                //dataSet3.WriteXml(sw3);
                ViewState["dSet1"] = sw1.ToString();
                ViewState["dSet2"] = sw2.ToString();
                //ViewState["dSet3"] = sw3.ToString();

                //tEO = objdstblEnvironmentalObservations.Tables["tblEnvironmentalObservations"];
            }
        }
Пример #5
0
        public void FillMeasurementInstrumentCodes(NBADWDataEntryApplication.dsDE_OandM_Instrument dataSet1, NBADWDataEntryApplication.dscdOandM dataSet2)
        {
            // Turn off constraint checking before the dataset is filled.
            // This allows the adapters to fill the dataset without concern
            // for dependencies between the tables.
            dataSet1.EnforceConstraints = false;
            dataSet2.EnforceConstraints = false;

            try
            {
                // Open the connection.
                this.oleDbConnection1.Open();
                // Attempt to fill the dataset through the OleDbDataAdapter1.
                this.oleDbdaDE_OandM_Instrument.Fill(dataSet1);
                this.oleDbdacdOandM.Fill(dataSet2);
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }
            finally
            {
                // Turn constraint checking back on.
                dataSet1.EnforceConstraints = true;
                dataSet2.EnforceConstraints = true;
                // Close the connection whether or not the exception was thrown.
                this.oleDbConnection1.Close();
            }
        }
Пример #6
0
        public void FillWaterTemperatureLogger(NBADWDataEntryApplication.dsqryWaterTemperatureLoggerDetails dataSet1, NBADWDataEntryApplication.dsqryWaterTemperatureLoggerMeasurements dataSet2, NBADWDataEntryApplication.dsqryWaterTemperatureLoggerSites dataSet3)
        {
            // Turn off constraint checking before the dataset is filled.
            // This allows the adapters to fill the dataset without concern
            // for dependencies between the tables.
            dataSet1.EnforceConstraints = false;
            dataSet2.EnforceConstraints = false;
            dataSet3.EnforceConstraints = false;

            try
            {
                // Open the connection.
                this.oleDbConnection1.Open();

                this.oleDbdaqryWaterTemperatureLoggerDetails.Fill(dataSet1);
                this.oleDbdaqryWaterTemperatureLoggerMeasurements.Fill(dataSet2);
                this.oleDbdaqryWaterTemperatureLoggerSites.Fill(dataSet3);
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }
            finally
            {
                // Turn constraint checking back on.
                dataSet1.EnforceConstraints = true;
                dataSet2.EnforceConstraints = true;
                dataSet3.EnforceConstraints = true;
                // Close the connection whether or not the exception was thrown.
                this.oleDbConnection1.Close();
            }
        }
Пример #7
0
        public void FillElectrofishing(NBADWDataEntryApplication.dsqryElectrofishingDataPlusEstimates dataSet1, NBADWDataEntryApplication.dsqryElectrofishingMarkRecaptureDataPlusEstimates dataSet2, NBADWDataEntryApplication.dsqryElectrofishingMethodDetails dataSet3, NBADWDataEntryApplication.dsqryElectrofishingSiteMeasurements dataSet4, NBADWDataEntryApplication.dsqryElectrofishingSites dataSet5, NBADWDataEntryApplication.dsqryElectrofishingWaterMeasurements dataSet6)
        {
            // Turn off constraint checking before the dataset is filled.
            // This allows the adapters to fill the dataset without concern
            // for dependencies between the tables.
            dataSet1.EnforceConstraints = false;
            dataSet2.EnforceConstraints = false;
            dataSet3.EnforceConstraints = false;
            dataSet4.EnforceConstraints = false;
            dataSet5.EnforceConstraints = false;
            dataSet6.EnforceConstraints = false;

            try
            {
                // Open the connection.
                this.oleDbConnection1.Open();

                this.oleDbdaqryElectrofishingDataPlusEstimates.Fill(dataSet1);
                this.oleDbdaqryElectrofishingMarkRecaptureDataPlusEstimates.Fill(dataSet2);
                this.oleDbdaqryElectrofishingMethodDetails.Fill(dataSet3);
                this.oleDbdaqryElectrofishingSiteMeasurements.Fill(dataSet4);
                this.oleDbdaqryElectrofishingSites.Fill(dataSet5);
                this.oleDbdaqryElectrofishingWaterMeasurements.Fill(dataSet6);
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }
            finally
            {
                // Turn constraint checking back on.
                dataSet1.EnforceConstraints = true;
                dataSet2.EnforceConstraints = true;
                dataSet3.EnforceConstraints = true;
                dataSet4.EnforceConstraints = true;
                dataSet5.EnforceConstraints = true;
                dataSet6.EnforceConstraints = true;
                // Close the connection whether or not the exception was thrown.
                this.oleDbConnection1.Close();
            }
        }
Пример #8
0
        public void FillCodeDataSets(NBADWDataEntryApplication.dsDE_Hatcheries dataSet1, NBADWDataEntryApplication.dscdFishSpecies dataSet2, /*NBADWDataEntryApplication.dsDE_FishStock dataSet3, */NBADWDataEntryApplication.dscdFishAgeClass dataSet4, NBADWDataEntryApplication.dscdFishMark dataSet5)
        {
            // Turn off constraint checking before the dataset is filled.
            // This allows the adapters to fill the dataset without concern
            // for dependencies between the tables.
            try
            {
                dataSet1.EnforceConstraints = false;
                dataSet2.EnforceConstraints = false;
                //dataSet3.EnforceConstraints = false;
                dataSet4.EnforceConstraints = false;
                dataSet5.EnforceConstraints = false;
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }

            try
            {
                // Open the connection.
                this.oleDbConnection1.Open();

                // Attempt to fill the dataset through the OleDbDataAdapter1.
                this.oleDbdaDE_Hatcheries.Fill(dataSet1);
                this.oleDbdacdFishSpecies.Fill(dataSet2);
                //this.oleDbdaDE_FishStock.Fill(dataSet3);
                this.oleDbdacdFishAgeClass.Fill(dataSet4);
                this.oleDbdacdFishMark.Fill(dataSet5);
            }
            catch (System.Exception fillException)
            {
                // Add your error handling code here.
                throw fillException;
            }
            finally
            {
                // Turn constraint checking back on.
                dataSet1.EnforceConstraints = true;
                dataSet2.EnforceConstraints = true;
                //dataSet3.EnforceConstraints = true;
                dataSet4.EnforceConstraints = true;
                dataSet5.EnforceConstraints = true;
                // Close the connection whether or not the exception was thrown.
                this.oleDbConnection1.Close();
            }
        }