Home ProgrammingASP.NET Export to Word from GridView in ASP.NET

Export to Word from GridView in ASP.NET

by John Bhatt
688 views
Hi,Today, I am going to continue our GridView tricks series ahead and posting a nice and useful feature. For all list of GridView articles we have written here, you can search for GridView in search box. As I have previously written about Exporting data to Excel from GridView, this is about exporting GridView to Microsoft Word which is another most used document format and needed in most cases.
Lets create a design as below.

I have just dragged and dropped a gridview control and used autoformat to make GridView look some better.
[html]
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
text-align: justify;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1 class="auto-style1">
Export to Word
</h1>
<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Width="590px">
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
<br />
<asp:Button ID="Button1" runat="server" Font-Bold="True" OnClick="Button1_Click" Text="Export to Word" />
</div>
</form>
</body>
</html>

[/html]
Now bind data to this gridview from backend.
[csharp]
protected void Page_Load(object sender, EventArgs e)
{
string ConString = "Server=.sqldb;database=Store;integrated security=true;";
SqlConnection con = new SqlConnection(ConString);
string QueryText = "SELECT DISTINCT Products.ProductName, Brands.BrandName, Category.CategoryName,
Products.UnitPrice, Products.UnitsInStock from products,brands,Suppliers,Category
where Products.BrandID=Brands.BrandID and Products.CategoryID=Category.CategoryID;";

SqlDataAdapter adp = new SqlDataAdapter(QueryText, con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}[/csharp]
Let’s view page in Browser. You must see data from your database. Mine query has resulted below data in grid.

Perfect, now its time to do the important stuff. Lets write code for Export Button. Double click in button to create a method and automatically bind event with control. Now write below code in backend.
[csharp]

public override void VerifyRenderingInServerForm(Control control)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment;filename=Products.doc"));
Response.ContentType = "application/vnd.ms-word ";
StringWriter WriterForWord = new StringWriter();
HtmlTextWriter HTMLWriter = new HtmlTextWriter(WriterForWord);
GridView1.AllowPaging = false;
GridView1.DataBind();
GridView1.RenderControl(HTMLWriter);
Response.Output.Write(WriterForWord.ToString());
Response.Flush();
Response.End();
}
[/csharp]
Its time to check our code, Click on Export to Word button. I have attached snapshot of Firefox because it prompts user.

You can save file or just click on Open with your word processor software. I am using Microsoft Word here.

Did you read our previous Export to Excel tutorial? What are the similarities between exporting to Word and Excel?
I am leaving with a question, if you know, leave a reply below.
Thanks for reading . Do not forget to say thanks or plus1 or provide feedback.
+John Bhatt

You may also like

1 comment

Anonymous March 6, 2014 - 8:43 pm

Hello! I simply wish to give a huge thumbs
up for the great info you will have right here on this post.
I might be coming back to your weblog for more soon.

Here is my web site … 網路設計

Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Export to Word from GridView in ASP.NET

by John Bhatt time to read: 3 min
1