Exporting Dataset/Gridview to pdf

Question

Hello Everyone, My name is Gangadhar, my question is how to export Dataset to PDF format with all possible properties. Kindly send me the code in c#

Rekha Singh · Answer

here's the code protected void Page_Load( object sender, EventArgs e) { if (!Page.IsPostBack) { GridView1.DataSource = BindData(); GridView1.DataBind(); } } private DataSet BindData() { // make the query string query = "SELECT * FROM test" ; SqlConnection myConnection = new SqlConnection (ConnectionString); SqlDataAdapter ad = new SqlDataAdapter (query, myConnection); DataSet ds = new DataSet (); ad.Fill(ds, "test" ); return ds; } protected void Button1_Click( object sender, EventArgs e) { Response.Clear(); Response.AddHeader( "content-disposition" , "attachment; filename=test.pdf" ); // If you want to save in Excel sheet ,just give test.xls in place of test.pdf Response.Charset = "" ; System.IO. StringWriter stringWrite = new System.IO. StringWriter (); System.Web.UI. HtmlTextWriter htmlWrite = new HtmlTextWriter (stringWrite); GridView1.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } **************************************8 if its helpful pls mark Accepted

Lalit M · Answer

show this url http://www.codeproject.com/KB/reporting-services/ReportExporters_WinForms.aspx http://www.theserverside.net/discussions/thread.tss?thread_id=34163 http://www.c-sharpcorner.com/UploadFile/DipalChoksi/ExportASPNetDataGridToExcel11222005041447AM/ExportASPNetDataGridToExcel.aspx

Chaitanya Reddy Vonaja · Answer

hi this link can help You www.completit.com