private void FlightConnectionForm_Load(object sender, EventArgs e) { #region populate combobox travel agency SAPRefTravelAgencyReadWrite travelAgency = new SAPRefTravelAgencyReadWrite(Config._dbConnectionName); SAPDataSetRefTravelAgency.RefTravelAgencyDataTable dt = travelAgency.SelectAll().RefTravelAgency; comboBoxTravelAgency.DataSource = dt; comboBoxTravelAgency.DisplayMember = SAPRefTravelAgencyReadWrite._agencyNameColumnName; comboBoxTravelAgency.ValueMember = SAPRefTravelAgencyReadWrite._agencyNumberColumnName; comboBoxTravelAgency.SelectedValue = "00000110"; //Bavarian Castle #endregion #region populate combobox carrier SAPRefCarrierReadWrite carrier = new SAPRefCarrierReadWrite(Config._dbConnectionName); SAPDataSetRefCarrier.RefCarrierDataTable dtCarrier = carrier.SelectAll().RefCarrier; SAPDataSetRefCarrier.RefCarrierRow rowCarrier = dtCarrier.NewRefCarrierRow(); rowCarrier.CarrID = string.Empty; rowCarrier.CarrName = string.Empty; rowCarrier.CurrCode = string.Empty; dtCarrier.Rows.InsertAt(rowCarrier, 0); comboBoxAirline.DataSource = dtCarrier; comboBoxAirline.DisplayMember = SAPRefCarrierReadWrite._carrNameColumnName; comboBoxAirline.ValueMember = SAPRefCarrierReadWrite._carrIDColumnName; #endregion #region populate city SAPRefFlightCityReadWrite flightCity = new SAPRefFlightCityReadWrite(Config._dbConnectionName); //SAPDataSetRefFlightCity.RefFlightCityDataTable dtFlightCityFrom = // flightCity.SelectAll().RefFlightCity; SAPDataSetRefFlightCity.RefFlightCityDataTable dtFlightCityTo = flightCity.SelectAll().RefFlightCity; //(SAPDataSetRefFlightCity.RefFlightCityDataTable)dtFlightCityFrom.Copy(); //comboBoxFrom.DataSource = dtFlightCityFrom; //comboBoxFrom.DisplayMember = SAPRefFlightCityReadWrite._cityNameColumnName; comboBoxTo.DataSource = dtFlightCityTo; comboBoxTo.DisplayMember = SAPRefFlightCityReadWrite._cityNameColumnName; comboBoxTo.Text = _flightCityTo; //comboBoxFrom.Text = _flightCityFrom; textBoxCity.Text = _flightCityFrom; #endregion }
private void PackageListControl_Load(object sender, EventArgs e) { SAPRefTravelAgencyReadWrite agency = new SAPRefTravelAgencyReadWrite(Config._dbConnectionName); SAPDataSetRefTravelAgency.RefTravelAgencyDataTable agencyData = agency.SelectAll().RefTravelAgency; SAPDataSetRefTravelAgency.RefTravelAgencyRow agencyRow = agencyData.NewRefTravelAgencyRow(); agencyRow.AgencyNumber = "0"; agencyRow.AgencyName = "All"; agencyData.Rows.InsertAt(agencyRow, 0); comboBoxAgency.DisplayMember = SAPRefTravelAgencyReadWrite._agencyNameColumnName; comboBoxAgency.ValueMember = SAPRefTravelAgencyReadWrite._agencyNumberColumnName; comboBoxAgency.DataSource = agencyData; comboBoxAgency.SelectedValue = "00000110"; //Bavarian Castle RefreshData(comboBoxAgency.SelectedValue.ToString()); }