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

Daanish G

4y922Windows Forms

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Yelve4y ago
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();
}
+1
Rajanikant Hawaldar4y ago
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
+1
Pushpendra Shukla4y ago
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");
    }
}
+1
Amit Mohanty4y ago
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
+1