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