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