private void loadLocationComboBox() { try { DBcon.DBCON cn = new DBcon.DBCON(); locationComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; locationComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; String sql = "select * from locations where country_id = " + countryComboBox.SelectedValue + ""; //MessageBox.Show(countryComboBox.SelectedValue.ToString()); OracleDataAdapter locationAdapter = new OracleDataAdapter(sql, cn.thisCon); DataTable locationDt = new DataTable(); locationAdapter.Fill(locationDt); locationComboBox.DataSource = locationDt; locationComboBox.DisplayMember = "location_name"; locationComboBox.ValueMember = "location_id"; //loadHotelComboBox(); } catch (Exception) { // MessageBox.Show(exp.Message); } }
private void loadComboBox() { DBcon.DBCON cn = new DBcon.DBCON(); try { countryComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; countryComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; String sql1 = "select * from countries"; OracleDataAdapter countryAdapter = new OracleDataAdapter(sql1, cn.thisCon); DataTable countryDt = new DataTable(); countryAdapter.Fill(countryDt); countryComboBox.DataSource = countryDt; countryComboBox.DisplayMember = "country_name"; countryComboBox.ValueMember = "country_id"; } catch (Exception exp) { MessageBox.Show(exp.Message); } }
private void loadLocationComboBox() { try { DBcon.DBCON cn = new DBcon.DBCON(); locationComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; locationComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; String sql1 = "Select * from locations"; OracleDataAdapter locationAdapter = new OracleDataAdapter(sql1, cn.thisCon); DataTable locationDt = new DataTable(); locationAdapter.Fill(locationDt); locationComboBox.DataSource = locationDt; locationComboBox.DisplayMember = "location_name"; locationComboBox.ValueMember = "location_id"; } catch (Exception exp) { MessageBox.Show("location Combobox can not be constructed cause {0}", exp.Message); } }
private void loadTypeComboBox() { DBcon.DBCON cn = new DBcon.DBCON(); try { hotelTypeCombobox.AutoCompleteMode = AutoCompleteMode.Suggest; hotelTypeCombobox.AutoCompleteSource = AutoCompleteSource.ListItems; String sql1 = "select hotel_type from hotel_info"; OracleDataAdapter countryAdapter = new OracleDataAdapter(sql1, cn.thisCon); DataTable countryDt = new DataTable(); countryAdapter.Fill(countryDt); hotelTypeCombobox.DataSource = countryDt; hotelTypeCombobox.DisplayMember = "hotel_type"; hotelTypeCombobox.ValueMember = "hotel_type"; } catch (Exception exp) { MessageBox.Show("Country Combobox can not be constructed cause {0}", exp.Message); } }
private void loadHotelComboBox() { try { DBcon.DBCON cn = new DBcon.DBCON(); hotelComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; hotelComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; String sql = "select * from hotel_info where location_id = " + locationComboBox.SelectedValue + ""; //MessageBox.Show(locationComboBox.SelectedValue.ToString()); OracleDataAdapter hotelAdpater = new OracleDataAdapter(sql, cn.thisCon); DataTable dt = new DataTable(); hotelAdpater.Fill(dt); hotelComboBox.DataSource = dt; hotelComboBox.DisplayMember = "hotel_name"; hotelComboBox.ValueMember = "hotel_id"; } catch (Exception) { } }
private void loadCountryComboBox() { DBcon.DBCON cn = new DBcon.DBCON(); try { countryComboBox.AutoCompleteMode = AutoCompleteMode.Suggest; countryComboBox.AutoCompleteSource = AutoCompleteSource.ListItems; String sql1 = "select * from countries"; OracleDataAdapter countryAdapter = new OracleDataAdapter(sql1, cn.thisCon); DataTable countryDt = new DataTable(); countryAdapter.Fill(countryDt); countryComboBox.DataSource = countryDt; countryComboBox.DisplayMember = "country_name"; countryComboBox.ValueMember = "country_id"; //MessageBox.Show(countryComboBox.SelectedValue.ToString()); //loadLocationComboBox(); } catch (Exception) { //MessageBox.Show("Country Combobox can not be constructed cause {0}", exp.Message); } }