<%@ Page Language="C#"
AspCompat="true"
AutoEventWireup="true"
CodeFile="TestWebPage.aspx.cs"
ValidateRequest="false" Inherits="TestWebPage"
%>
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>Untitled Pagetitle>
head>
<body>
<form id="form1"
runat="server">
<div>
<asp:GridView ID="GridView1"
runat="server"
AutoGenerateColumns="False"
Font-Names="Arial"
Font-Size="11pt" AllowPaging="True"
OnPageIndexChanging="OnPaging"
CellPadding="4"
ForeColor="#333333" GridLines="None">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField ItemStyle-Width="150px"
DataField="UserID"
HeaderText="User
ID" />
<asp:BoundField ItemStyle-Width="150px"
DataField="UserName"
HeaderText="User
Name" />
<asp:BoundField ItemStyle-Width="150px"
DataField="City"
HeaderText="City"
/>
<asp:BoundField ItemStyle-Width="150px"
DataField="Address"
HeaderText="Address"
/>
Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White">HeaderStyle>
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White">AlternatingRowStyle>
asp:GridView>
<br />
<asp:Button ID="btnExportWord"
runat="server"
Text="ExportToWord"
OnClick="btnExportWord_Click"
/>
<asp:Button ID="btnExportExcel"
runat="server"
Text="ExportToExcel"
OnClick="btnExportExcel_Click"
/>
<asp:Button ID="btnExportPDF"
runat="server"
Text="ExportToPDF"
OnClick="btnExportPDF_Click"
/>
<asp:Button ID="Button1"
runat="server"
Text="ExportToCSV"
OnClick="btnExportCSV_Click"
/>
div>
form>
body>
html>
public override void
VerifyRenderingInServerForm(Control control)
{
/* Verifies that
the control is rendered */
}
protected void OnPaging(object
sender, GridViewPageEventArgs e)
{
GridView1.PageIndex =
e.NewPageIndex;
GridView1.DataBind();
}
protected void btnExportWord_Click(object
sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.doc");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-word ";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
GridView1.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void btnExportExcel_Click(object
sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
//Change the
Header Row back to white color
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
//Apply style to
Individual Cells
GridView1.HeaderRow.Cells[0].Style.Add("background-color", "#507CD1");
GridView1.HeaderRow.Cells[1].Style.Add("background-color", "#507CD1");
GridView1.HeaderRow.Cells[2].Style.Add("background-color", "#507CD1");
GridView1.HeaderRow.Cells[3].Style.Add("background-color", "#507CD1");
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row =
GridView1.Rows[i];
//Change Color
back to white
row.BackColor =
System.Drawing.Color.White;
//Apply text
style to each Row
row.Attributes.Add("class", "textmode");
//Apply style to
Individual Cells of Alternating Row
if (i % 2 !=
0)
{
row.Cells[0].Style.Add("background-color", "#EFF3FB");
row.Cells[1].Style.Add("background-color", "#EFF3FB");
row.Cells[2].Style.Add("background-color", "#EFF3FB");
row.Cells[3].Style.Add("background-color", "#EFF3FB");
}
}
GridView1.RenderControl(hw);
//style to
format numbers to string
string style = @"";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void btnExportPDF_Click(object
sender, EventArgs e)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
GridView1.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc,
Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
protected void btnExportCSV_Click(object
sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.csv");
Response.Charset = "";
Response.ContentType = "application/text";
GridView1.AllowPaging = false;
GridView1.DataBind();
StringBuilder sb = new StringBuilder();
for (int k = 0; k < GridView1.Columns.Count; k++)
{
//add separator
sb.Append(GridView1.Columns[k].HeaderText
+ ',');
}
//append new
line
sb.Append("\r\n");
for (int i = 0; i < GridView1.Rows.Count; i++)
{
for (int k = 0; k < GridView1.Columns.Count; k++)
{
//add separator
sb.Append(GridView1.Rows[i].Cells[k].Text
+ ',');
}
//append new
line
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
thank you . gridview to Export CSV coding.but by this code does not export fields of first column of GV.My first Column is Sr. No. and sr no. generated by Getno() function. pls help.
ReplyDeleteExport GridView to different file formats in C#
ReplyDeleteHi there, everything is going perfectly here and ofcourse every one is sharing data,
ReplyDeletethat's genuinely good, keep up writing.
Feel free to surf to my site; how to earn
money online fast []