/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
//CommonFunctions.Connection = new System.Data.SqlClient.SqlConnection();
this.GetStateProvinces = new System.Data.SqlClient.SqlDataAdapter();
this.GetCountries = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.CountriesStates = new Vacations.CountriesStates();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.CountriesStates)).BeginInit();
//
// CommonFunctions.Connection
//
//CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
//"rsist security info=False;initial catalog=Vacations";
//
// GetStateProvinces
//
this.GetStateProvinces.SelectCommand = this.sqlSelectCommand1;
this.GetStateProvinces.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// GetCountries
//
this.GetCountries.SelectCommand = this.sqlSelectCommand2;
this.GetCountries.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// sqlSelectCommand2
//
//this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND NOT EXISTS (SELECT * FROM Auctions WHERE PropertyID = Properties.ID)) ORDER BY Country";
this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) ) ORDER BY Country";
this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
//
// CountriesStates
//
this.CountriesStates.DataSetName = "CountriesStates";
this.CountriesStates.Locale = new System.Globalization.CultureInfo("en-US");
//
// sqlSelectCommand1
//
//this.sqlSelectCommand1.CommandText = @"SELECT StateProvinces.ID, StateProvinces.CountryID, StateProvinces.StateProvince, Countries.Country FROM StateProvinces INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID WHERE (Countries.RegionID = @RegionID) AND EXISTS (SELECT * FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID WHERE (Cities.StateProvinceID = StateProvinces.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND NOT EXISTS (SELECT * FROM Auctions WHERE PropertyID = Properties.ID)) ORDER BY StateProvinces.StateProvince";
this.sqlSelectCommand1.CommandText = @"SELECT StateProvinces.ID, StateProvinces.CountryID, StateProvinces.StateProvince, Countries.Country FROM StateProvinces INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID WHERE (Countries.RegionID = @RegionID) AND EXISTS (SELECT * FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID WHERE (Cities.StateProvinceID = StateProvinces.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1)) ORDER BY StateProvinces.StateProvince";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
((System.ComponentModel.ISupportInitialize)(this.CountriesStates)).EndInit();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
//CommonFunctions.Connection = new System.Data.SqlClient.SqlConnection();
this.RegionsSet = new Vacations.RegionsDataset();
this.StateProvincesSet = new Vacations.StateProvincesDataset();
this.AmenitiesSet = new Vacations.AmenitiesDataset();
this.CountriesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand();
this.AmenitiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.RegionsAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
this.AttractionsAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.CitiesSet = new Vacations.CitiesDataset();
this.CountriesSet = new Vacations.CountriesDataset();
this.StateProvincesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.AttractionsSet = new Vacations.AttractionsDataset();
this.CitiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand();
this.PropertiesFullSet = new Vacations.PropertiesFullDataset();
this.PropertiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand();
this.CountriesSet2 = new Vacations.CountriesDataset();
((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).BeginInit();
//
// CommonFunctions.Connection
//
//CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
//"rsist security info=False;initial catalog=Vacations";
//
// RegionsSet
//
this.RegionsSet.DataSetName = "RegionsDataset";
this.RegionsSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// StateProvincesSet
//
this.StateProvincesSet.DataSetName = "StateProvincesDataset";
this.StateProvincesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// AmenitiesSet
//
this.AmenitiesSet.DataSetName = "AmenitiesDataset";
this.AmenitiesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// CountriesAdapter
//
this.CountriesAdapter.SelectCommand = this.sqlSelectCommand4;
this.CountriesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// sqlSelectCommand4
//
this.sqlSelectCommand4.CommandText = "CountryDistinctList";
this.sqlSelectCommand4.CommandType = CommandType.StoredProcedure;
this.sqlSelectCommand4.Connection = CommonFunctions.GetConnection();
//
// AmenitiesAdapter
//
this.AmenitiesAdapter.InsertCommand = this.sqlInsertCommand5;
this.AmenitiesAdapter.SelectCommand = this.sqlSelectCommand3;
this.AmenitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Amenities", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("Amenity", "Amenity")
})
});
//
// sqlInsertCommand5
//
this.sqlInsertCommand5.CommandText = "INSERT INTO Amenities(ID, Amenity) VALUES (@ID, @Amenity)";
this.sqlInsertCommand5.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Amenity", System.Data.SqlDbType.NVarChar, 300, "Amenity"));
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "AmenityDistinctList";
this.sqlSelectCommand3.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand3.CommandType = CommandType.StoredProcedure;
//
// RegionsAdapter
//
this.RegionsAdapter.InsertCommand = this.sqlInsertCommand6;
this.RegionsAdapter.SelectCommand = this.sqlSelectCommand5;
this.RegionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Regions", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("Region", "Region")
})
});
//
// sqlInsertCommand6
//
this.sqlInsertCommand6.CommandText = "INSERT INTO Regions(Region) VALUES (@Region)";
this.sqlInsertCommand6.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 300, "Region"));
//
// sqlSelectCommand5
//
this.sqlSelectCommand5.CommandText = "RegionDistinctList";
this.sqlSelectCommand5.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand5.CommandType = CommandType.StoredProcedure;
//
// AttractionsAdapter
//
this.AttractionsAdapter.InsertCommand = this.sqlInsertCommand4;
this.AttractionsAdapter.SelectCommand = this.sqlSelectCommand1;
this.AttractionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Attractions", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("Attraction", "Attraction")
})
});
//
// sqlInsertCommand4
//
this.sqlInsertCommand4.CommandText = "INSERT INTO Attractions(ID, Attraction) VALUES (@ID, @Attraction)";
this.sqlInsertCommand4.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Attraction", System.Data.SqlDbType.NVarChar, 300, "Attraction"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "AttractionsDistinctList";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand1.CommandType = CommandType.StoredProcedure;
//
// CitiesSet
//
this.CitiesSet.DataSetName = "CitiesDataset";
this.CitiesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// CountriesSet
//
this.CountriesSet.DataSetName = "CountriesDataset";
this.CountriesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// StateProvincesAdapter
//
this.StateProvincesAdapter.InsertCommand = this.sqlInsertCommand3;
this.StateProvincesAdapter.SelectCommand = this.sqlSelectCommand2;
this.StateProvincesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince")
})
});
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.CommandText = "INSERT INTO StateProvinces(CountryID, StateProvince) VALUES (@CountryID, @StateProvince)";
this.sqlInsertCommand3.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "CountryID"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvince", System.Data.SqlDbType.NVarChar, 300, "StateProvince"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "StateProvinceDistinctList";
this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand2.CommandType = CommandType.StoredProcedure;
//
// AttractionsSet
//
this.AttractionsSet.DataSetName = "AttractionsDataset";
this.AttractionsSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// CitiesAdapter
//
this.CitiesAdapter.InsertCommand = this.sqlInsertCommand1;
this.CitiesAdapter.SelectCommand = this.sqlSelectCommand7;
this.CitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Cities", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("StateProvinceID", "StateProvinceID"),
new System.Data.Common.DataColumnMapping("City", "City")
})
});
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO Cities(StateProvinceID, City) VALUES (@StateProvinceID, @City)";
this.sqlInsertCommand1.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "StateProvinceID"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 300, "City"));
//
// sqlSelectCommand7
//
this.sqlSelectCommand7.CommandText = @"SELECT DISTINCT Cities.ID, Cities.StateProvinceID, Cities.City FROM Cities INNER JOIN Properties ON Cities.ID=Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) UNION SELECT -1, -1, ' Include All' ORDER BY City";
this.sqlSelectCommand7.Connection = CommonFunctions.GetConnection();
//
// PropertiesFullSet
//
this.PropertiesFullSet.DataSetName = "PropertiesFullDataset";
this.PropertiesFullSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// PropertiesAdapter
//
this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand6;
this.PropertiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Properties", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("MinimumNightlyRental", "MinimumNightlyRental"),
new System.Data.Common.DataColumnMapping("TaxIncluded", "TaxIncluded")
})
});
//
// sqlSelectCommand6
//
this.sqlSelectCommand6.CommandText = "TopThreePropertiesList";
this.sqlSelectCommand6.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand6.CommandType = CommandType.StoredProcedure;
//
// CountriesSet2
//
this.CountriesSet2.DataSetName = "CountriesDataset";
this.CountriesSet2.Locale = new System.Globalization.CultureInfo("en-US");
this.CountriesStates = new Vacations.CountriesStates();
this.GetStateProvinces = new System.Data.SqlClient.SqlDataAdapter();
this.GetCountries = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.CountriesStates = new Vacations.CountriesStates();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.CountriesStates)).BeginInit();
//
// CommonFunctions.Connection
//
//CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
//"rsist security info=False;initial catalog=Vacations";
//
// GetStateProvinces
//
this.GetStateProvinces.SelectCommand = this.sqlSelectCommand1;
this.GetStateProvinces.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// GetCountries
//
this.GetCountries.SelectCommand = this.sqlSelectCommand2;
this.GetCountries.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// sqlSelectCommand2
//
//this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND NOT EXISTS (SELECT * FROM Auctions WHERE PropertyID = Properties.ID)) ORDER BY Country";
this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) ) ORDER BY Country";
this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
this.sqlSelectCommand1.CommandText = @"SELECT StateProvinces.ID, StateProvinces.CountryID, StateProvinces.StateProvince, Countries.Country FROM StateProvinces INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID WHERE (Countries.RegionID = @RegionID) AND EXISTS (SELECT * FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID WHERE (Cities.StateProvinceID = StateProvinces.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1)) ORDER BY StateProvinces.StateProvince";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
//
// CountriesStates
//
this.CountriesStates.DataSetName = "CountriesStates";
this.CountriesStates.Locale = new System.Globalization.CultureInfo("en-US");
//GetStateProvinces = new System.Data.SqlClient.SqlDataAdapter();
//System.Data.SqlClient.SqlDataAdapter GetCountries= new System.Data.SqlClient.SqlDataAdapter();
this.GetCountries.SelectCommand.Parameters["@RegionID"].Value = 6;
this.GetStateProvinces.SelectCommand.Parameters["@RegionID"].Value = 6;
////lock (CommonFunctions.Connection)
this.GetCountries.Fill(this.CountriesStates);
////lock (CommonFunctions.Connection)
this.GetStateProvinces.Fill(this.CountriesStates);
this.CountriesStates.Relations.Add("CountriesStates", this.CountriesStates.Tables["Countries"].Columns["ID"],
this.CountriesStates.Tables["StateProvinces"].Columns["CountryID"]);
//ltlAsia.Text = ds.Tables[0].Rows[1]["RegionTextValue"].ToString();
//ltlEurope.Text = ds.Tables[0].Rows[2]["RegionTextValue"].ToString();
//ltlNorthAmerica.Text = ds.Tables[0].Rows[3]["RegionTextValue"].ToString();
//ltlSouthAmerica.Text = ds.Tables[0].Rows[4]["RegionTextValue"].ToString();
//ltlOceania.Text = ds.Tables[0].Rows[5]["RegionTextValue"].ToString();
//ltlAsiaList.Text = GenerateCountryLinks("2");
//ltlOceaniaList.Text = GenerateCountryLinks("3");
//ltlSouthAmericaList.Text = GenerateCountryLinks("9");
//ltlEuropeList.Text = GenerateCountryLinks("6");
//ltlNorthAmericaList.Text = GenerateCountryLinks("8");
((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).EndInit();
}
