A good way to display data is to show it in a grid view. However, it becomes difficult to manipulate and filter large amounts of data in this way. Exporting data to an Excel file is a great solution for handling large amounts of data because Excel has many features -- such as sorting, searching and filtering.
Following step do this
Following step do this
Using the code
This sample uses ASP.NET 2.0, C# and SQL Server 2000. I am using a simple form & database to fast data retrieving. Firstly pull data from a database and display it in the grid then we are export data from the grid to the Excel file.
That’s the process to handle large amounts of data and combat different types of errors.
Create a <DIV id=”divprint”>
On aspx page create a div tag for id div print then copy & Paste ur gridview source code then close div tag with </div>
On .aspx page
Firstly add controls Lables, Text Box. Gridview also Button . In Go button write the code to fill girdview with calling Fillgrid() Function .. in a Textbox pass a query on Go button Click event . Then Gridview Fill .
Using
these Namespaces
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Linq;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Xml.Linq;
using
System.Data.SqlClient;
using
System.Globalization;
using
System.Xml.Linq;
using
System.Text;
using
System.IO;
using
iTextSharp.text;
using
iTextSharp.text.pdf;
using
iTextSharp.text.html;
Fillgrid
function code
public void fillGrid()
{
string
constr1;
IFormatProvider
culture = new CultureInfo("fr-Fr", true);
constr1 = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
con = new
SqlConnection(constr1);
con.Open();
cmd = new
SqlCommand(TextBox1.Text, con);
adp = new
SqlDataAdapter(cmd);
ds = new
DataSet();
adp.Fill(ds);
gv.DataSource = ds;
gv.DataBind();
con.Close();
}
On Export Button
On export button write this code & generate Save as Popup Box
string
attachment = "attachment;
filename=Export.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter
sw = new StringWriter();
HtmlTextWriter
htw = new HtmlTextWriter(sw);
// Create a
form to contain the grid
HtmlForm
frm = new HtmlForm();
gv.Parent.Controls.Add(frm);
frm.Attributes["runat"]
= "server";
frm.Controls.Add(gv);
frm.RenderControl(htw);
//GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
After you do this Ur gridview data exports in Excel File Export.xls
Conculsion
On this article we learned how to pull data from a database and
show it in the grid view control. We have learned how to export data from gridview to an Excel file, I hope that this Code helps you. Feel
free to give me any suggestions
regarding this article. Happy coding!
Regard's
Prabhakar