Design Page Code:
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1"
runat="server"
AutoGenerateColumns="false"
Font-Names="Arial"
Font-Size="11pt"
AlternatingRowStyle-BackColor="AliceBlue" HeaderStyle-BackColor="white"
AllowPaging="true"
BorderStyle="Solid"
OnPageIndexChanging="OnPaging">
<Columns>
<asp:BoundField DataField="EmployeeCode"
HeaderText="EmployeeCode"
SortExpression="EmployeeCode"
/>
<asp:BoundField DataField="EmployeeDesc"
HeaderText="EmployeeDesc"
SortExpression="EmployeeDesc"
/>
<asp:BoundField DataField="Gender"
HeaderText="Gender"
SortExpression="Gender"
/>
<asp:BoundField DataField="DateofBirth"
HeaderText="DateofBirth"
SortExpression="DateofBirth"
/>
<asp:BoundField DataField="DeptDesc"
HeaderText="DeptDesc"
SortExpression="DeptDesc"
/>
</Columns>
</asp:GridView>
</div>
<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"
/>
</form>
</body>
Server Side code:
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", "white");
GridView1.HeaderRow.Cells[1].Style.Add("background-color",
"white");
GridView1.HeaderRow.Cells[2].Style.Add("background-color",
"white");
GridView1.HeaderRow.Cells[3].Style.Add("background-color",
"white");
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",
"AliceBlue");
row.Cells[1].Style.Add("background-color",
"AliceBlue");
row.Cells[2].Style.Add("background-color",
"AliceBlue");
row.Cells[3].Style.Add("background-color",
"AliceBlue");
}
}
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();
}
OutPut :
