1 2 3 4 5 6 7 8 9
| d.connecter();
SqlDataAdapter da1 = new SqlDataAdapter("SELECT FORMAT([Dates],'dd-MM-yy') as [Dates],d.[Designation] as Agence,c.Designation as Depot,b.[Reference] as reference,b.Designation as Produit,e.[Designation] as Fournisseur,[Numpiece],[TRANSPORTEUR],[Chauffeur],[VEHICUL],[QUANTITE],[PU] as txtFournisseur from [dbo].[AchatFournisseur] a inner join [dbo].[article] b on b.Idarticle=a.Idarticle inner join [dbo].[Depot] c on c.IdDepot=a.IdDepot inner join [dbo].[Agences] d on d.IdAgences=a.IdAgences inner join [dbo].[Depot] e on e.[IdDepot]=a.[IdDepotB] where [Numpiece]='" + Session["NumerodeBon"] + "' and e.[Designation]='" + Session["DepotDepart"] + "'", d.con);
DataSet ds = new DataSet();
da1.Fill(ds, "EditbonTransfert");
d.deconnecter();
crystalReport.SetDataSource(ds);
cr.ReportSource = crystalReport;
crystalReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "Bon de transfert N°" + Session["NumerodeBon"] + "");
Response.Close(); |
Partager