//for state combo box private void cmbCountry_SelectedIndexChanged(object sender, EventArgs e) { int id = (int)cmbCountry.SelectedValue; cmbStateId.DisplayMember = "StateName"; cmbStateId.ValueMember = "PKStateId"; cmbStateId.DataSource = stateDB.FilteredState(id); }
//for filtering the data public List <State> FilterState(int Id) { StateDB = new StateDB(); return(StateDB.FilteredState(Id)); }