private void ReportLoad()
{
//try
//{
Facture rpt = new Facture();
SqlCommand cmd = new SqlCommand(@"SELECT personne.nom, personne.postnom, personne.prenom, personne.sexe,
Article.designation AS Article, Article.pu,paiement.qte_vendue AS [Quantité vendu], paiement.qte_vendue * Article.pu AS [Prix total], paiement.date_paiement
FROM paiement INNER JOIN Article ON paiement.id_article = Article.id INNER JOIN client ON
paiement.id_client = client.id INNER JOIN personne ON client.id_personne = personne.id where client.id=@id", Factory.Instance.connectDB());
SqlDataAdapter sa = new SqlDataAdapter(cmd);
SqlParameter paramId = cmd.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = ((Client)cboClient.SelectedItem).Id;
cmd.Parameters.Add(paramId);
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
sa.Fill(ds, "doc");
rpt.SetDataSource(ds.Tables["doc"]);
rptvFacture.ReportSource = rpt;
rptvFacture.Refresh();
sa.Dispose();
ds.Dispose();
cmd.Dispose();
//}
//catch (Exception exc)
//{
// MessageBox.Show(exc.Message, "Erreur de l'afichage du rapport", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
//}
}
