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

Export to Word from GridView in ASP.NET

by John Bhatt
727 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.

Export to Word from GridView in ASP.NET 1

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.

Export to Word from GridView in ASP.NET 2

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.

Export to Word from GridView in ASP.NET 3

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

Export to Word from GridView in ASP.NET 4

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

Related Articles

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