Export Gridview Data To Excel,Pdf,.Csv,Txt,Html,Doc Files
Add Pdf ITextsharp Reference Below Link
http://dotnetdrizzles.blogspot.in/2014/09/how-to-create-pdf-document-in-asp-net.html
HTML Coding
Next - Add Namespaces - Bind GridView & Download All Formate Coding
Next - Add To Swith the Case Selected Dropdownlist Items
Export Gridview Data To Excel,Pdf,.Csv,Txt,Html,Doc Files Whenever Select Dropdownlist Value Using asp.Net C#.
DEMO
Add Pdf ITextsharp Reference Below Link
http://dotnetdrizzles.blogspot.in/2014/09/how-to-create-pdf-document-in-asp-net.html
HTML Coding
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div >
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<AlternatingRowStyle BackColor="Gray" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="ID" />
<asp:BoundField DataField="username" HeaderText="User Name" />
<asp:BoundField DataField="course" HeaderText="Course" />
</Columns>
<HeaderStyle BackColor="#FFCCFF" />
</asp:GridView>
<table> <tr><td>
<asp:DropDownList ID="DropDownList1" runat="server" Style="font-size: 18px;
cursor: pointer; background-color:silver; padding: 5px 10px 5px 10px;" Width="124px">
<asp:ListItem Text="Word File" Value="wordfile"></asp:ListItem>
<asp:ListItem Text="HTML
File"></asp:ListItem>
<asp:ListItem Text="PDF File" ></asp:ListItem>
<asp:ListItem Text="Excel
File"></asp:ListItem>
<asp:ListItem Text="Text
File"></asp:ListItem>
<asp:ListItem Text="CSV File" ></asp:ListItem>
</asp:DropDownList>
</td></tr>
<tr><td>
<br />
<asp:Button ID="Button7" Style="width: 150px; font-size: 18px;
cursor: pointer; background-color:gray; padding: 5px 10px 5px 10px; margin-left: 0px;" runat="server" OnClick="Button7_Click" Text="Download File" />
</td></tr>
</table>
</div>
</form>
</body>
</html>
C# Coding
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Web.UI.HtmlControls;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;
public partial class Download : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter adp;
SqlDataReader rd;
DataSet ds;
string query;
DataTable dtTable = new DataTable();
public void dbcon()
{
string connn = (System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
con = new SqlConnection(connn);
con.Open();
}
protected void Page_Load(object sender, EventArgs e)
{
gridbind();
}
protected void gridbind()
{
dbcon();
query = "select
* from Reg";
cmd = new SqlCommand(query, con);
adp = new SqlDataAdapter(cmd);
ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void txt()
{
gridbind();
string text = string.Empty;
foreach (TableCell Tblcell in GridView1.HeaderRow.Cells)
{
text += Tblcell.Text + "\t\t";
}
text += "\r\n";
foreach (GridViewRow row in GridView1.Rows)
{
foreach (TableCell Tblcell in row.Cells)
{
text += Tblcell.Text + "\t\t";
}
text += "\r\n";
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=Gridtxt.txt");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(text);
Response.Flush();
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
protected void csv()
{
gridbind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridCsv.csv");
Response.Charset = "";
Response.ContentType = "application/text";
GridView1.AllowPaging = false;
GridView1.DataBind();
StringBuilder str = new StringBuilder();
for (int k = 0; k < GridView1.Columns.Count; k++)
{
str.Append(GridView1.Columns[k].HeaderText
+ ',');
}
str.Append("\r\n");
for (int i = 0; i < GridView1.Rows.Count; i++)
{
for (int k = 0; k < GridView1.Columns.Count; k++)
{
str.Append(GridView1.Rows[i].Cells[k].Text
+ ',');
}
str.Append("\r\n");
}
Response.Output.Write(str.ToString());
Response.Flush();
Response.End();
}
protected void doc()
{
gridbind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridDoc.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 html()
{
HtmlForm form = new HtmlForm();
GridView1.AllowPaging = false;
gridbind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;
filename=GridHtml.html");
Response.Charset = "";
Response.ContentType = "text/html";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
form.Attributes["runat"] = "server";
form.Controls.Add(GridView1);
this.Controls.Add(form);
Form.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void pdf()
{
gridbind();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=GridPdf.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
GridView1.RenderControl(hw);
GridView1.HeaderRow.Style.Add("width", "15%");
GridView1.HeaderRow.Style.Add("font-size", "10px");
GridView1.Style.Add("text-decoration", "none");
GridView1.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
GridView1.Style.Add("font-size", "8px");
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f,
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 excel()
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;
filename=GridExcel.xls");
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
private void Download_File(string FilePath)
{
Response.ContentType = ContentType;
Response.AppendHeader("Content-Disposition", "attachment;
filename=" + Path.GetFileName(FilePath));
Response.WriteFile(FilePath);
Response.End();
}
protected void Button7_Click(object sender, EventArgs e)
{
string strFileType;
strFileType =
DropDownList1.Text.ToString();
switch (strFileType)
{
case "HTML File":
html();
break;
case "Word File":
doc();
break;
case "Text File":
txt();
break;
case "Excel File":
excel();
break;
case "PDF File":
pdf();
break;
case "CSV File":
csv();
break;
}
}
}
Add New Webform - Select Gridview,Dropdownlist,Button From toolbox
Next - Add Namespaces - Bind GridView & Download All Formate Coding
Next - Add To Swith the Case Selected Dropdownlist Items
0 comments:
Post a Comment