1.5K

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.

Export GridView to Excel in ASP.NET

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

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.

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

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