The following is my DataTable in design mode from which I will show data in a GridView.
sql table
The following is the script of my table:
  1. CREATE TABLE [dbo].[Employee](
  2. [Emp_ID] [int] IDENTITY(1,1) NOT NULL,
  3. [Name] [varchar](50) NULL,
  4. [Designation] [varchar](50) NULL,
  5. [City] [varchar](50) NULL,
  6. [State] [varchar](50) NULL,
  7. [Country] [varchar](50) NULL,
  8. CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
  9. (
  10. [Emp_ID] ASC
  11. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  12. ) ON [PRIMARY]
  14. GO
The following is the data in my table:
table data
The following is my aspx code:
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4. <html xmlns="http://www.w3.org/1999/xhtml">
  5. <head runat="server">
  6. <title>EXPORT Grid View To a Text File in ASP.NET C#</title>
  7. </head>
  8. <body>
  9. <form id="form1" runat="server">
  10. <div>
  11. <table style="border: solid 15px blue; width: 100%; vertical-align: central;">
  12. <tr>
  13. <td style="padding-left: 50px; padding-top: 20px; padding-bottom: 20px; background-color: skyblue;
  14. font-size: 20pt; color: orangered;">
  15. EXPORT Grid View To a Text File in ASP.NET C#
  16. </td>
  17. </tr>
  18. <tr>
  19. <td style="text-align: left; padding-left: 50px; border: solid 1px red;">
  20. <asp:GridView ID="GridViewEmployee" runat="server" AutoGenerateColumns="False" Width="90%"
  21. BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
  22. CellPadding="4" GridLines="Both">
  23. <Columns>
  24. <asp:BoundField DataField="Name" HeaderText="Employee Name" />
  25. <asp:BoundField DataField="Designation" HeaderText="Designation" />
  26. <asp:BoundField DataField="City" HeaderText="City" />
  27. <asp:BoundField DataField="State" HeaderText="State" />
  28. <asp:BoundField DataField="Country" HeaderText="Country" />
  29. </Columns>
  30. <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
  31. <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
  32. <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
  33. <RowStyle BackColor="White" ForeColor="#003399" />
  34. <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
  35. </asp:GridView>
  36. </td>
  37. </tr>
  38. <tr>
  39. <td align="right">
  40. <asp:Button ID="btnExport" Text="Export Grid View" OnClick="btnExport_Click" runat="server" />
  41. </td>
  42. </tr>
  43. </table>
  44. </div>
  45. </form>
  46. </body>
  47. </html>
The following is the aspx.cs code:
  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.Data.SqlClient;
  10. public partial class _Default : System.Web.UI.Page
  11. {
  12. SqlDataAdapter da;
  13. DataSet ds = new DataSet();
  14. DataTable dt = new DataTable();
  16. protected void Page_Load(object sender, EventArgs e)
  17. {
  18. if (!Page.IsPostBack)
  19. this.BindGrid();
  20. }
  22. private void BindGrid()
  23. {
  24. SqlConnection con = new SqlConnection();
  25. ds = new DataSet();
  26. con.ConnectionString = @"Data Source=INDIA\MSSQLServer2k8; Initial Catalog=EmployeeManagement; Uid=sa; pwd=india;";
  27. SqlCommand cmd = new SqlCommand("SELECT * FROM EMPLOYEE", con);
  29. da = new SqlDataAdapter(cmd);
  30. da.Fill(ds);
  31. con.Open();
  32. cmd.ExecuteNonQuery();
  33. con.Close();
  35. if (ds.Tables[0].Rows.Count > 0)
  36. {
  37. GridViewEmployee.DataSource = ds.Tables[0];
  38. GridViewEmployee.DataBind();
  39. }
  40. }
  42. protected void btnExport_Click(object sender, EventArgs e)
  43. {
  44. string txtFile = string.Empty;
  46. //Adding Column Name In Text File.
  47. foreach (TableCell cell in GridViewEmployee.HeaderRow.Cells)
  48. {
  49. txtFile += cell.Text + "\t\t";
  50. }
  52. txtFile += "\r\n";
  54. //Adding Data Column Values in Text File
  55. foreach (GridViewRow row in GridViewEmployee.Rows)
  56. {
  57. foreach (TableCell cell in row.Cells)
  58. {
  59. txtFile += cell.Text + "\t\t";
  60. }
  61. txtFile += "\r\n";
  62. }
  64. Response.Clear();
  65. Response.Buffer = true;
  66. Response.AddHeader("content-disposition", "attachment;filename=EmployeeData.txtFile");
  67. Response.Charset = "";
  68. Response.ContentType = "application/text";
  69. Response.Output.Write(txtFile);
  70. Response.Flush();
  71. Response.End();
  72. }
  73. }
Now run the application.
export grid
Employee data txt
exported txt file