Introduction
In this article i will explain you how to export (Download) all Grid data in CSV(Comma Separated Values) file.
Description
Here i repeat the same process as i did my previous update to export (Download) all Grid data in Excel and Word doc file. .
Database Design
Create Database EmployeeDb
Use EmployeeDb
Create table Employee( Id int Identity(1,1), Name varchar(50),EmailId nvarchar(250), Address varchar(max) , MobileNo int )
Aspx page View
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div> <br /> <br />
<asp:GridView ID="gvUserInfo" runat="server" AutoGenerateColumns="false" CellPadding="4" ForeColor="#333333">
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150px" />
<asp:BoundField DataField="EmailID" HeaderText="Email Id" ItemStyle-Width="150px" />
<asp:BoundField DataField="Address" HeaderText="Address" ItemStyle-Width="140px" />
<asp:BoundField DataField="MobileNo" HeaderText="Mobile No" ItemStyle-Width="140px" />
</Columns>
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
</asp:GridView>
<asp:Button ID="btnExport" runat="server" OnClick="btnExport_Click" Text="Export To CSV" /> </div> <br /> <br/>
</form>
</body>
</html>
After completing the design phase go to view code window and write the code given below
CS page View
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered*/
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
//method for Displaying Data in Gridview
protected void BindGrid()
{
SqlConnection con = new SqlConnection("Data Source=JP-PC\\JP;Initial Catalog=EmployeeDb;Integrated Security=true;");
SqlCommand cmd = new SqlCommand("SELECT * FROM Employee", con);
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
gvUserInfo.DataSource = ds;
gvUserInfo.DataBind();
con.Close();
}
protected void btnExport_Click(object sender, EventArgs e)
{
BindGrid();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=EmployeeGridViewExport.csv");
Response.Charset = "";
Response.ContentType = "application/text";
gvUserInfo.AllowPaging = false;
StringBuilder sb = new StringBuilder();
for (int k = 0; k < gvUserInfo.Columns.Count; k++)
{
//add
separator
sb.Append(gvUserInfo.Columns[k].HeaderText + ',');
}
//append
new line
sb.Append("\r\n");
for (int i = 0; i < gvUserInfo.Rows.Count; i++)
{
for (int k = 0; k < gvUserInfo.Columns.Count; k++)
{
//add
separator
sb.Append(gvUserInfo.Rows[i].Cells[k].Text + ',');
}
//append
new line
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
In above code you can see i used a VerifyRenderingInServerForm function. The purpose of this function is avoid the error like "control must be placed in inside of form tag". If we set VerifyRenderingInServerForm function then compiler will think that controls rendered before exporting and our functionality will work perfectly.
If you are not using this function on your page then your localhost gives you error "control must be placed in inside of form tag".
For to clear understanding about outputs refer the below screen-shots.
For to clear understanding about outputs refer the below screen-shots.
0 comments:
Post a Comment