private void listerFactures() { MonDataSet monDataSet = new MonDataSet(); SqlCommand maCommande = new SqlCommand(); maCommande.CommandText = "listerFactures"; maCommande.CommandType = CommandType.StoredProcedure; maCommande.Connection = conn; SqlDataAdapter dataAdapter = new SqlDataAdapter(maCommande); dataAdapter.Fill(monDataSet, "Item"); if (DGV_Liste.BindingContext[monDataSet].Count > 0) { BindingSource source = new BindingSource(monDataSet, "Item"); DGV_Liste.DataSource = source; } else { MessageBox.Show("Il n'y a pas de factures"); } }
private void listerClientFact() { MonDataSet monDataSet = new MonDataSet(); SqlCommand maCommande = new SqlCommand(); maCommande.CommandText = "listerClientFact"; maCommande.CommandType = CommandType.StoredProcedure; maCommande.Connection = conn; maCommande.Parameters.Add(new SqlParameter("@NomClient", SqlDbType.VarChar, 50)).Direction = ParameterDirection.Input; maCommande.Parameters["@NomClient"].Value = CB_Client.Text; SqlDataAdapter dataAdapter = new SqlDataAdapter(maCommande); dataAdapter.Fill(monDataSet, "Item"); if (DGV_Liste.BindingContext[monDataSet].Count > 0) { BindingSource source = new BindingSource(monDataSet, "Item"); DGV_Liste.DataSource = source; } else { MessageBox.Show("Il n'y a pas de factures"); } }