/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dvSortedSites = new System.Data.DataView();
this.objdsDE_SiteList = new NBADWDataEntryApplication.dsDE_SiteList();
this.oleDbdaSiteList = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand4 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.dvSortedSites)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteList)).BeginInit();
this.masterDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.masterDataGrid_PageIndexChanged);
this.masterDataGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.masterDataGrid_EditCommand);
this.masterDataGrid.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.masterDataGrid_SortCommand);
//
// dvSortedSites
//
this.dvSortedSites.Table = this.objdsDE_SiteList._DE_SiteList;
//
// objdsDE_SiteList
//
this.objdsDE_SiteList.DataSetName = "dsDE_SiteList";
this.objdsDE_SiteList.Locale = new System.Globalization.CultureInfo("en-US");
//
// oleDbdaSiteList
//
this.oleDbdaSiteList.InsertCommand = this.oleDbInsertCommand1;
this.oleDbdaSiteList.SelectCommand = this.oleDbSelectCommand1;
this.oleDbdaSiteList.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "DE-SiteList", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("AgencyCd", "AgencyCd"),
new System.Data.Common.DataColumnMapping("AgencySiteID", "AgencySiteID"),
new System.Data.Common.DataColumnMapping("AquaticActivityCd", "AquaticActivityCd"),
new System.Data.Common.DataColumnMapping("AquaticSiteDesc", "AquaticSiteDesc"),
new System.Data.Common.DataColumnMapping("AquaticSiteID", "AquaticSiteID"),
new System.Data.Common.DataColumnMapping("AquaticSiteName", "AquaticSiteName"),
new System.Data.Common.DataColumnMapping("AquaticSiteUseID", "AquaticSiteUseID"),
new System.Data.Common.DataColumnMapping("DrainageCd", "DrainageCd"),
new System.Data.Common.DataColumnMapping("tblAquaticSite.IncorporatedInd", "tblAquaticSite.IncorporatedInd"),
new System.Data.Common.DataColumnMapping("tblAquaticSiteAgencyUse.IncorporatedInd", "tblAquaticSiteAgencyUse.IncorporatedInd"),
new System.Data.Common.DataColumnMapping("WaterBodyID", "WaterBodyID"),
new System.Data.Common.DataColumnMapping("WaterBodyName", "WaterBodyName"),
new System.Data.Common.DataColumnMapping("WaterBodyName_Abrev", "WaterBodyName_Abrev")})});
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = @"INSERT INTO [DE-SiteList] (AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, DrainageCd, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, WaterBodyName_Abrev) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSite_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSite.IncorporatedInd"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSiteAgencyUse_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSiteAgencyUse.IncorporatedInd"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterBodyName"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName_Abrev", System.Data.OleDb.OleDbType.VarWChar, 40, "WaterBodyName_Abrev"));
//
// oleDbConnection1
//
try
{
//this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Registry Path=;Data Source=""C:\Data_Warehouse\Tabular_Data\NBAquaticDataWarehouse_DW.mdb"";Jet OLEDB:System database=;Jet OLEDB:Global Bulk Transactions=1;User ID=Admin;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:SFP=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Engine Type=5;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Global Partial Bulk Ops=2;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Create System Database=False;Jet OLEDB:Database Locking Mode=1";
this.oleDbConnection1.ConnectionString = Session["ConnectionString"].ToString();
}
catch(System.NullReferenceException)
{
Server.Transfer("Login.aspx");
}
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, AquaticSiteUseID, DrainageCd, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName, WaterBodyName_Abrev FROM [DE-SiteList]";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbInsertCommand4
//
this.oleDbInsertCommand4.CommandText = @"INSERT INTO [DE-SiteList] (AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID, AquaticSiteName, DrainageCd, [tblAquaticSite.IncorporatedInd], [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencyCd", System.Data.OleDb.OleDbType.VarWChar, 4, "AgencyCd"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AgencySiteID", System.Data.OleDb.OleDbType.VarWChar, 10, "AgencySiteID"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticActivityCd", System.Data.OleDb.OleDbType.SmallInt, 0, "AquaticActivityCd"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteDesc", System.Data.OleDb.OleDbType.VarWChar, 150, "AquaticSiteDesc"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteID", System.Data.OleDb.OleDbType.Integer, 0, "AquaticSiteID"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("AquaticSiteName", System.Data.OleDb.OleDbType.VarWChar, 100, "AquaticSiteName"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("DrainageCd", System.Data.OleDb.OleDbType.VarWChar, 17, "DrainageCd"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSite_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSite.IncorporatedInd"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("tblAquaticSiteAgencyUse_IncorporatedInd", System.Data.OleDb.OleDbType.Boolean, 2, "tblAquaticSiteAgencyUse.IncorporatedInd"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyID", System.Data.OleDb.OleDbType.Integer, 0, "WaterBodyID"));
this.oleDbInsertCommand4.Parameters.Add(new System.Data.OleDb.OleDbParameter("WaterBodyName", System.Data.OleDb.OleDbType.VarWChar, 50, "WaterBodyName"));
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT AgencyCd, AgencySiteID, AquaticActivityCd, AquaticSiteDesc, AquaticSiteID," +
" AquaticSiteName, AquaticSiteUseID, DrainageCd, [tblAquaticSite.IncorporatedInd]" +
", [tblAquaticSiteAgencyUse.IncorporatedInd], WaterBodyID, WaterBodyName FROM [DE" +
"-SiteList]";
((System.ComponentModel.ISupportInitialize)(this.dvSortedSites)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.objdsDE_SiteList)).EndInit();
}
public void LoadSiteList()
{
// Create a new dataset to hold the records returned from the call to FillDataSet.
// A temporary dataset is used because filling the existing dataset would
// require the databindings to be rebound.
//NBADWDataEntryApplication.dsTemperatureSites objDataSetTemp;
//objDataSetTemp = new NBADWDataEntryApplication.dsTemperatureSites();
NBADWDataEntryApplication.dsDE_SiteList objDataSetTemp;
objDataSetTemp = new NBADWDataEntryApplication.dsDE_SiteList();
try
{
// Attempt to fill the temporary dataset.
this.FillSiteList(objDataSetTemp);
}
catch (System.Exception eFillDataSet)
{
// Add your error handling code here.
throw eFillDataSet;
}
try
{
// Empty the old records from the dataset.
objdsDE_SiteList.Clear();
// Merge the records into the main dataset.
objdsDE_SiteList.Merge(objDataSetTemp);
}
catch (System.Exception eLoadMerge)
{
// Add your error handling code here.
throw eLoadMerge;
}
}
