HiHow 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