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.
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.
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
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.
<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>
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.
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();
}
Its time to check our code, Click on Export to Word button. I have attached snapshot of Firefox because it prompts user.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
Hello! I simply wish to give a huge thumbs
ReplyDeleteup 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 ... 網路設計