private void ImprimerAllClientCause_Load(object sender, EventArgs e)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd = new SqlCommand("Select [id_client_cause] as[مرجع],[type_client] as[النوع],[cin] as[ر.ب.و],[nom] as[الاسم],[representant_legal] as[الممثل التجاري],[registre_commerce] as[السجل التجاري],[adresse] as[العنوان] from client_cause where cin like'" + id + "%' or registre_commerce like'" + id + "%' or nom like'" + id + "%'", cn);
da = new SqlDataAdapter(cmd);
da.Fill(ds, "client");
cmd1 = new SqlCommand("select top(1)*from avocat", cn);
da1 = new SqlDataAdapter(cmd1);
da1.Fill(ds, "avocat");
reportAllclientCause i = new reportAllclientCause();
i.SetDataSource(ds);
crystalReportViewer1.ReportSource = i;
cn.Close();
//reportAllclientCause cr = new reportAllclientCause();
////crystalReportViewer1.ReportSource = cr;
////crystalReportViewer1.Refresh();
//strServer = Properties.Settings.Default.Server;
//strDatabase = Properties.Settings.Default.DataBase;
//strUserID = Properties.Settings.Default.ID;
//strPwd = Properties.Settings.Default.PassWord;
//cr.DataSourceConnections[0].IntegratedSecurity = false;
//cr.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd);
////i.SetParameterValue("id_cause", id.Trim());
//crystalReportViewer1.ReportSource = cr;
//crystalReportViewer1.Refresh();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
reportAllclientCause rpt = new reportAllclientCause();
rpt.Site = this.Site;
return(rpt);
}
