Hi,How can I send data grid view data to word or pdf template I

Question

Hi, How can I send data grid view data to word or pdf template I am using c#Winform.

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/hrojasara/export-datagridview-to-excel-in-C-Sharp/ https://www.c-sharpcorner.com/blogs/export-datagridview-data-to-pdf-in-c-sharp

Amit Mohanty · Answer

Hey, check the below links https://www.c-sharpcorner.com/blogs/export-datagridview-data-to-pdf-in-c-sharp https://stackoverflow.com/questions/29729413/export-datagridview-to-word-document-c-sharp https://www.aspsnippets.com/Articles/Export-DataGridView-to-Word-in-Windows-Application-using-C-and-VBNet.aspx

Vishal Yelve · Answer

Use iTextSharp PDF Response.Clear(); Response.Buffer = true ; Response.AddHeader( "content-disposition" , "attachment;filename=GridViewExport.pdf" ); Response.Charset = "" ; Response.ContentType = "application/pdf" ; //To Export all pages. GridView1.AllowPaging = false ; this .BindGrid(); using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { GridView1.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); XMLWorkerHelper.GetInstance().ParseXHtml(writer, pdfDoc, sr); pdfDoc.Close(); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Write(pdfDoc); Response.End(); } } Word Response.Clear(); Response.Buffer = true ; Response.AddHeader( "content-disposition" , "attachment;filename=GridViewExport.doc" ); Response.Charset = "" ; Response.ContentType = "application/vnd.ms-word" ; using (StringWriter sw = new StringWriter()) { HtmlTextWriter hw = new HtmlTextWriter(sw); //To Export all pages. GridView1.AllowPaging = false ; this .BindGrid(); GridView1.HeaderRow.BackColor = Color.White; foreach (TableCell cell in GridView1.HeaderRow.Cells) { cell.BackColor = GridView1.HeaderStyle.BackColor; } foreach (GridViewRow row in GridView1.Rows) { row.BackColor = Color.White; foreach (TableCell cell in row.Cells) { if (row.RowIndex % 2 == 0) { cell.BackColor = GridView1.AlternatingRowStyle.BackColor; } else { cell.BackColor = GridView1.RowStyle.BackColor; } } } GridView1.RenderControl(hw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); }

Pushpendra Shukla · Answer

Step 1 To a create database and also create a table. create database school; use school; create table student(id int primary key , name varchar (50), class varchar (50), marks int ); select * from student; Insert data into a student table. Step 2 In our C# windows project double click on the form1 page and write a code under the form1load function. private void Form1_Load( object sender, EventArgs e) { SqlConnection Con; string connstring = null ; string sqlQuery = null ; connstring = "Data Source=LAPTOP-4G5ST718; Initial Catalog=school; Integrated Security=ture;" ; Con = new SqlConnection(connstring); Con.Open(); sqlQuery = "Select * from student" ; SqlDataAdapter Da = new SqlDataAdapter(sqlQuery, Con); DataTable Dt = new DataTable(); dscmd.Fill(Dt); dataGridView1.DataSource = Dt; } and create a button to convert data into pdf private void btn_Click( object sender, EventArgs e) { if (dataGridView1.Rows.Count > 0) { SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = "PDF (*.pdf)|*.pdf" ; sfd.FileName = "Sample.pdf" ; bool fileError = false ; if (sfd.ShowDialog() == DialogResult.OK) { if (File.Exists(sfd.FileName)) { try { File.Delete(sfd.FileName); } catch (IOException ex) { fileError = true ; MessageBox.Show( "It wasn't possible to write the data to the disk." + ex.Message); } } if (!fileError) { try { PdfPTable pdfTable = new PdfPTable(dataGridView1.Columns.Count); pdfTable.DefaultCell.Padding = 3; pdfTable.WidthPercentage = 100; pdfTable.HorizontalAlignment = Element.ALIGN_LEFT; foreach (DataGridViewColumn column in dataGridView1.Columns) { PdfPCell cell = new PdfPCell( new Phrase(column.HeaderText)); pdfTable.AddCell(cell); } foreach (DataGridViewRow row in dataGridView1.Rows) { foreach (DataGridViewCell cell in row.Cells) { pdfTable.AddCell(cell.Value.ToString()); } } using (FileStream stream = new FileStream(sfd.FileName, FileMode.Create)) { Document pdfDoc = new Document(PageSize.A4); PdfWriter.GetInstance(pdfDoc, stream); pdfDoc.Open(); pdfDoc.Add(pdfTable); pdfDoc.Close(); stream.Close(); } MessageBox.Show( "Data Exported Successfully !!!" , "Info" ); } catch (Exception ex) { MessageBox.Show( "Error :" + ex.Message); } } } } else { MessageBox.Show( "No Record To Export !!!" , "Info" ); } }

Hi,How can I send data grid view data to word or pdf template I

Answers (4)