Export GridView data to txt file in Asp.net using C#
How to Export GridView to txt file using C# :
In this Post we learn how to export data from Grid View to
Text file (.txt format) in ASP.Net using C#. When we are developing asp.net web
site basically commercial web site then we needs to print the list of records
which are show in grid view. As we know that we easily bind the asp.net grid
view control for database for display the data in web page. So if we want to print
the Grid view data in to text file. Then we can use this type of code.
Here we make a gridview in asp.net web page and then export
data in a .text file.
Create a Gridview and Export data:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="ProductId"
HeaderText="Product
Id" ItemStyle-Width="100">
<ItemStyle
Width="100px"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="ProductName"
HeaderText="Product
Name" ItemStyle-Width="150">
<ItemStyle
Width="150px"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="Price"
HeaderText="Price"
ItemStyle-Width="150">
<ItemStyle
Width="150px"></ItemStyle>
</asp:BoundField>
</Columns>
<HeaderStyle BackColor="Blue"
ForeColor="#990000"
BorderColor="#0000CC"
BorderStyle="Groove"
/>
</asp:GridView>
Make a DataTable and bind Grid by C# code:
DataTable dt = new
DataTable();
dt.Columns.AddRange(new DataColumn[3] { new
DataColumn("ProductId"),
new DataColumn("ProductName"), new
DataColumn("Price")
});
dt.Rows.Add(1, "Lux", "10Rs");
dt.Rows.Add(2, "Mobile", "10000Rs");
dt.Rows.Add(3, "Sugar", "50/kg");
dt.Rows.Add(4, "Biskit", "20Rs");
GridView1.DataSource = dt;
GridView1.DataBind();
C# Function of Exporting Grid Data:
ExportTextFile(object
sender, EventArgs e)
{
string txt = string.Empty;
foreach (TableCell
cell in GridView1.HeaderRow.Cells)
{
txt
+= cell.Text + "\t\t";
}
txt += "\r\n";
foreach (GridViewRow
row in GridView1.Rows)
{
//Making the space beween cells.
foreach (TableCell
cell in row.Cells)
{
txt += cell.Text + "\t\t";
}
txt
+= "\r\n";
}
Response.Clear();
Response.Buffer = true;
//here you can give the name of file.
Response.AddHeader("content-disposition",
"attachment;filename=ProductList.txt");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(txt);
Response.Flush();
Response.End();
}
Export Grid View to txt file using C# :
<%@ Page
Language="C#"
AutoEventWireup="true"
CodeFile="Exportdataintextfile.aspx.cs"
Inherits=" Exportdataintextfile
" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD
XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
body
{
font-family: Arial;
font-size: 10pt;
}
table
{
border: 1px solid #ccc;
}
table th
{
background-color: #F7F7F7;
color: #333;
font-weight: bold;
}
table th, table td
{
padding: 5px;
border-color: #ccc;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<asp:GridView ID="GridView1"
runat="server"
AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="ProductId" HeaderText="Product Id" ItemStyle-Width="100">
<ItemStyle
Width="100px"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="ProductName"
HeaderText="Product
Name" ItemStyle-Width="150">
<ItemStyle
Width="150px"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="Price"
HeaderText="Price"
ItemStyle-Width="150">
<ItemStyle
Width="150px"></ItemStyle>
</asp:BoundField>
</Columns>
<HeaderStyle BackColor="Blue"
ForeColor="#990000"
BorderColor="#0000CC"
BorderStyle="Groove"
/>
</asp:GridView>
<br />
<asp:Button Text="Export in Text
File" OnClick="ExportTextFile"
runat="server"
/>
</div>
</form>
</body>
</html>
C# Code for Export Gridview:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class Exportdataintextfile
: System.Web.UI.Page
{
protected void
Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new
DataTable();
dt.Columns.AddRange(new DataColumn[3] { new
DataColumn("ProductId"),
new DataColumn("ProductName"), new
DataColumn("Price")
});
dt.Rows.Add(1, "Lux", "10Rs");
dt.Rows.Add(2, "Mobile", "10000Rs");
dt.Rows.Add(3, "Sugar", "50/kg");
dt.Rows.Add(4, "Biskit", "20Rs");
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
protected void
ExportTextFile(object sender, EventArgs e)
{
string txt = string.Empty;
foreach (TableCell
cell in GridView1.HeaderRow.Cells)
{
txt
+= cell.Text + "\t\t";
}
txt += "\r\n";
foreach (GridViewRow
row in GridView1.Rows)
{
//Making the space beween cells.
foreach (TableCell
cell in row.Cells)
{
txt += cell.Text + "\t\t";
}
txt
+= "\r\n";
}
Response.Clear();
Response.Buffer = true;
//here you can give the name of file.
Response.AddHeader("content-disposition",
"attachment;filename=ProductList.txt");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(txt);
Response.Flush();
Response.End();
}
}
Asp.net related Post :
- Asp.net Email Address Validation Using Regular Expression
- Find Nth Highest Salary in SQL Server
- How to Create Sql Function, use of function in sql
- SQL Injection,how we prevent over asp.net web application
- Sql CONTINUE STATEMENT,how to use
- Sql server while loop statement how to use
- SQL Features and Benefits, Database Engine
- Find datetime difference in asp.net by C#
- In Asp.net Difference between ""(empty string) and String.Empty
- Asp.net NullReferenceException and how fix it
- Add rows in GridView dynamic with Textbox
- Add rows in GridView dynamic with Textbox
- In asp.net by jquery change div text color on mouseover
- Asp.net Watermark Text on uploaded Image
- Asp.net TextBox OnTextChanged Event
- Upload multiple by one asp.net fileupload control using jQuery
- Create Dynamic Rows in ASP.Net GridView Control with TextBoxes
- Limitation of Characters in Textbox or TextArea in asp.netusing jquery:
- jquery disable or Enable submit button after validation
- Enable Disable Submit Button using jQuery
- Get the current page url by C# jQuery modal dialog with postbacks
- Drag and Drop Sortable Lists using jQueryUI
- jquery tooltip with css in asp.net web page
- Ajax ColorPickerExtender in ASP.NET Example
- What is the Ajax colorpicker,How to use Ajax colorpicker
- JQuery UI Datepicker (Calendar) with asp.net textbox
Comments
Post a Comment