Home ProgrammingASP.NET Export to Word from GridView in ASP.NET, How to Export GridView data to MS Word in C#?

Export to Word from GridView in ASP.NET, How to Export GridView data to MS Word in C#?

by John Bhatt
764 views
Learn how to Export GridView Data to Word using ASP.NET C#

Today, I am going to continue our GridView tricks series ahead and posting a nice and useful feature. We will learn Export to Word in ASP.NET GridView data.

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. Let’s create a design as below.

Export to Word: GridView Design & HTML

Export to Word from GridView - Design

I have just dragged and dropped a gridview control and used autoformat to make GridView look some better.

<div>
	<h1> 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>

Code for DataBind (C#)

Now bind data to this GridView from backend.

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();
}

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

Perfect, now it’s time to do the important stuff. Let’s 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.

Export Button Code (C#)

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();
	}

It’s 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 – Output

Export to Word Click Result

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 - Output

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 have read carefully, leave a reply below. You can learn Excel in Hindi on our YouTube channel. Subscribe by clicking here.

Thanks for reading. Do not forget to say thanks by sharing with friends.

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

Do NOT follow this link or you will be banned from the site!