1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| /***********Fonction retournant une dataset
public static DataSet CustomerDataSet(string code)
{ string req = "select * from facture_cl where code_fac='" + code + "'";
string strconnection = @"Data Source=CIEL-6448344C8F\CIELSERVER;Initial Catalog=ERP;User ID=fa;Password=fa";
string table = "facture";
CustomerDataSetSchema dataSet = new CustomerDataSetSchema();
SqlConnection conn = new SqlConnection(strconnection);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(req , conn);
da.Fill(dataSet,table );
return dataSet;
}
///************************************
private void button_imp_Click(object sender, EventArgs e)
{
imp_fac imp_f = new imp_fac();
CrystalReport_fac crf_fac = new CrystalReport_fac ();
imp_f.Show();
DataSet dss =list_fac_cl.CustomerDataSet(code_fac );
DataTable df = dss.Tables["facture"];
imp_f.crystalReportViewer_fac.Visible = true;
crf_fac.SetDataSource(dss );
imp_f.crystalReportViewer_fac.ReportSource = crf_fac;
imp_f.crystalReportViewer_fac.Refresh();
} |
Partager