Create Pdf file

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 < Grv.Columns.Count; 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();
} 

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.

Please refer to this link

 

http://www.sqlservercentral.com/columnists/mivica/sql2pdf.txt 

Refer the following Link to create it:

 

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 ?????

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.