private void cb_CarBrand_SelectedIndexChanged(object sender, EventArgs e) { try { cb_area.DataSource = area.SelectAllByCity(int.Parse(cb_CarBrand.SelectedValue.ToString())); //cb_area.DataSource = area.SelectAll(); cb_area.DisplayMember = "AreaName"; cb_area.ValueMember = "ID"; cb_area.SelectedIndex = -1; if (cb_area.Items.Count == 0) { cb_area.DataSource = null; } } catch { } }
private void Fill() { #region cars brand cb_CarBrand.DataSource = brands.SelectAll(); cb_CarBrand.DisplayMember = "BrandName"; cb_CarBrand.ValueMember = "ID"; cb_CarBrand.SelectedIndex = -1; #endregion #region client Category // ComboBox cb_CarBrand = this.Owner.Controls.Find("cb_cat", true).First() as ComboBox; cb_cat.DataSource = cat.SelectAll(); cb_cat.DisplayMember = "Client_Category"; cb_cat.ValueMember = "ID"; cb_cat.SelectedIndex = -1; #endregion #region Colors cb_colors.DataSource = colors.SelectAll(); cb_colors.DisplayMember = "ColorName"; cb_colors.ValueMember = "ID"; cb_colors.SelectedIndex = -1; #endregion #region City cb_City.DataSource = city.SelectAll(); cb_City.DisplayMember = "CityName"; cb_City.ValueMember = "ID"; cb_City.SelectedValue = 2; cb_area.DataSource = area.SelectAllByCity(2); cb_area.DisplayMember = "AreaName"; cb_area.ValueMember = "ID"; cb_area.SelectedValue = 5; #endregion #region ads cmb_ads.DataSource = how.SelectAll(); cmb_ads.DisplayMember = "HowDidYouUS"; cmb_ads.ValueMember = "ID"; cmb_ads.SelectedIndex = -1; #endregion #region branches cb_branches.DataSource = branch.SelectAll(); cb_branches.DisplayMember = "BranchName"; cb_branches.ValueMember = "ID"; cb_branches.SelectedValue = 2; #endregion }
private void cb_CarBrand_SelectedIndexChanged(object sender, EventArgs e) { // Select Area by city try { dataGridView1.DataSource = brands.SelectAllByCity(int.Parse(cb_CarBrand.SelectedValue.ToString())); } catch{ } }