private void LoadGrille_() { dgv_liste_.Rows.Clear(); string query = "select * from marque order by id"; List <Marque> l = MarqueBLL.List(query); foreach (Marque f in l) { AddRow_(f); } Reset_(); }
private void txt_search__TextChanged(object sender, EventArgs e) { string search = txt_search_.Text.Trim(); dgv_liste_.Rows.Clear(); string query = "select * from marque where reference like '" + search + "%' or designation like '" + search + "%' or description like '" + search + "%'"; List <Marque> l = MarqueBLL.List(query); foreach (Marque f in l) { AddRow_(f); } Reset_(); }
private void LoadAllMarques() { marques.Clear(); string query = "select * from marque order by id"; marques = MarqueBLL.List(query); com_marque.DisplayMember = "Designation"; com_marque.ValueMember = "Id"; com_marque.DataSource = new BindingSource(marques, null); foreach (Marque f in marques) { com_marque.AutoCompleteCustomSource.Add(f.Designation); } com_marque.AutoCompleteMode = AutoCompleteMode.SuggestAppend; com_marque.AutoCompleteSource = AutoCompleteSource.CustomSource; if (current != null ? current.Id > 0 : false) { com_marque.ResetText(); } }