예제 #1
0
        private void LoadGrille()
        {
            dgv_liste.Rows.Clear();
            string          query = "select * from doc_stocks order by id";
            List <DocStock> l     = DocStockBLL.List(query);

            foreach (DocStock d in l)
            {
                AddRow(d);
            }
            Reset();
        }
예제 #2
0
        private void txt_search_TextChanged(object sender, EventArgs e)
        {
            string search = txt_search.Text.Trim();

            if (search.Length > 0)
            {
                dgv_liste.Rows.Clear();
                string          query = "select * from doc_stocks where reference like '" + search + "%'";
                List <DocStock> l     = DocStockBLL.List(query);
                foreach (DocStock f in l)
                {
                    AddRow(f);
                }
                Reset();
            }
            else
            {
                LoadGrille();
            }
        }