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();
}
}
