Create Pdf file

Question

Dear sir/ mam I want create .pdf file with the help of store procudure in sql server. How we can create???? Thanks & Regards Suraj bhoir

Manikandan Murugesan · Answer

Refer the following Link to create it: http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/

suraj Bhoir · Answer

your are right. But i want create .pdf file using only sql query . E.g i have created one store procudure. In that i want create PDF file from select query and save in perticulare location. How can i do that ?????

Purvesh Sangani · Answer

Hi Suraj! see this code! this function need two parameter gridview and filename gridview meanse your bulk data (replace this paramater and use you need DataTable Gridview Repeater Dataset Generic List Arraylist etc...) public void ExportPdf(GridView Grv string PdfName) { for (int i = 0; i { if ((Convert.ToString(Grv.Columns[i].HeaderText) == Edit) || (Convert.ToString(Grv.Columns[i].HeaderText) == Delete)) { Grv.Columns[i].Visible = false; } } System.Web.HttpContext.Current.Response.ContentType = application/pdf; System.Web.HttpContext.Current.Response.AddHeader(content-disposition attachment;filename= + PdfName + .pdf); System.Web.HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); Grv.AllowPaging = false; Grv.AllowPaging = false; Grv.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A2 7f 7f 7f 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc System.Web.HttpContext.Current.Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); System.Web.HttpContext.Current.Response.Write(pdfDoc); System.Web.HttpContext.Current.Response.End(); }

Ravi Kiran Chanduri · Answer

Hi Suraj you can refere to the following link http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/ it is already provided by Manikandan and I ahve gone through it .It fulfill you requirement. In the above URL site: provided a Stored procedure  where it can generate a pdf file in perticuler location on executing the SP.

Ankit Sharma · Answer

Please refer to this link http://www.sqlservercentral.com/columnists/mivica/sql2pdf.txt

Manikandan Murugesan · Answer

Refer the following Link : https://www.codeproject.com/Articles/621332/Building-Your-First-SSRS-Report https://www.sqlservercentral.com/Forums/14614/Creating-a-PDF-from-a-Stored-Procedure SQL Server 2008 product included one of the services called as “SQL Server Reporting Services 2008 (SSRS)”. SSRS is a full-featured application that provides report design development testing and deployment of reports by the use of Business Intelligence Development Studio (BIDS) developer tool for all its operations.