Coding:

=> Demo.aspx Source code
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Demo.aspx.cs" Inherits="architecture.Demo" %>
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  4. <head runat="server">
  5. <title></title>
  6. </head>
  8. <body>
  9. <form id="form1" runat="server">
  10. <div> <br /> <br />
  11. <asp:GridView ID="gvlist" runat="server" AutoGenerateColumns="false" CellPadding="4" ForeColor="#333333">
  12. <Columns>
  13. <asp:BoundField DataField="ID" HeaderText="Id" HeaderStyle-Width="200px" />
  14. <asp:BoundField DataField="FirstName" HeaderText="First Name" HeaderStyle-Width="200px" />
  15. <asp:BoundField DataField="LastName" HeaderText="Last Name" HeaderStyle-Width="200px" /> </Columns>
  16. <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
  17. <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> </asp:GridView> <br />
  18. <asp:Button ID="btnExport" runat="server" OnClick="Button1_Click" Text="Export To Excel" /> </div> <br /> </br>
  19. </form>
  20. </body>
  22. </html>
=>Demo.aspx.cs code behind file
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8. using System.Configuration;
  9. using System.Data.SqlClient;
  10. using System.IO;
  11. using System.Collections;
  12. namespace architecture
  13. {
  14. public partial class Demo: System.Web.UI.Page
  15. {
  16. SqlConnection con;
  17. DataTable dt;
  18. //Connection String from Web.config file
  19. public static string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
  20. protected void Page_Load(object sender, EventArgs e) {
  21. //lblTime.Text = DateTime.Today.DayOfWeek.ToString();
  22. if (!IsPostBack) {
  23. ShowData();
  24. }
  25. }
  26. //method for Displaying Data in Gridview
  27. protected void ShowData()
  28. {
  29. SqlConnection con = new SqlConnection(constr);
  30. string str = "Select * from TbDemo; select * from TbDemo";
  31. con.Open();
  32. SqlCommand cmd = new SqlCommand(str, con);
  33. DataTable dt = new DataTable();
  34. SqlDataReader reader = cmd.ExecuteReader();
  35. dt.Load(reader);
  36. DataView dv = dt.DefaultView;
  37. gvlist.DataSource = dv;
  38. gvlist.DataBind();
  39. int i = 0;
  40. con.Close();
  41. }
  42. protected void Button1_Click(object sender, EventArgs e)
  43. {
  44. Response.ClearContent();
  45. Response.AddHeader("content-disposition", "attachment;filename=Users.xls");
  46. Response.ContentType = "applicatio/excel";
  47. StringWriter sw = new StringWriter();;
  48. HtmlTextWriter htm = new HtmlTextWriter(sw);
  49. gvlist.RenderControl(htm);
  50. Response.Write(sw.ToString());
  51. Response.End();
  52. }
  53. public override void VerifyRenderingInServerForm(Control control) {}
  54. }
  55. }