Introduction:
In the last article
Examination
of the FormView Control I demonstrated that how you can use the templates
inside the FormView to display different controls. In this article I will
embed the GridView control inside the FormView control and then export
the GridView control to an excel file.
The Scenario:
The scenario is that we have a FormView
control and in its ItemTemplate
there is a GridView control. Now, we want to populate the GridView
control with some data and later export the GridView control to excel.
This article is different from
Exporting
GridView to Excel in a sense that now the GridView is present inside
the FormView control.
Populating the GridView inside the
FormView Control:
The first thing that we need to do is to
populate the GridView control with some dummy data so that we can export
the data to the excel file. Take a look at the BindData method which
populates the GridView with the data.
private
void BindData()
{
DataSet ds =
new
DataSet();
if (Cache["DataSet"]
== null)
{
SqlConnection
myConnection = new
SqlConnection(ConnectionString);
SqlDataAdapter
ad = new
SqlDataAdapter("SELECT
* FROM Users", myConnection);
ad.Fill(ds);
Cache["DataSet"]
= ds;
}
fv1.DataSource = (DataSet)Cache["DataSet"];
fv1.DataBind();
FormViewRow
row = fv1.Row;
GridView
gv = row.FindControl("gv1")
as
GridView;
gv.DataSource = (DataSet)
Cache["DataSet"];
gv.DataBind();
}
|
In the code above I have moved the DataSet inside the
Cache object so that you don't have to make a trip to the database on
every request. Later I have assigned the FormView control with the
DataSet and bind it on the screen. The
FormViewRow row = fv1.Row;
get's the row from the FormView control which contains the GridView
control. The FindControl method is used to locate the GridView
control. Once, the GridView is found I simply assigns the DataSet
to the GridView DataSource property and bind the GridView on the page.
Once, you have bind the GridView you will see the data on the screen as
shown in the screen shot below:
Exporting the GridView to Excel:
The code for the exportation task is 99% same as that I
already discussed in my article
Exporting
GridView to Excel. The only change is the GetGridView method which
returns the GridView populated with the data. Take a look at the code
below:
protected
void
btnExport_Click(object
sender, EventArgs
e) {
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");
Response.Charset = "";
// If you want the option to open
the Excel file without saving than
// comment out the line below
//
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType =
"application/vnd.xls";
System.IO.StringWriter
stringWrite = new
System.IO.StringWriter();
System.Web.UI.HtmlTextWriter
htmlWrite = new
HtmlTextWriter(stringWrite);
GridView
gv1 = GetGridView();
gv1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
public
override
void VerifyRenderingInServerForm(Control
control)
{
// Confirms that an HtmlForm control is
rendered for the specified ASP.NET server control at run time.
}
|
And finally here is the GetGridView method:
private GridView
GetGridView() {
fv1.DataSource = Cache["DataSet"]
as
DataSet;
fv1.DataBind();
FormViewRow
row = fv1.Row;
GridView gv =
row.FindControl("gv1")
as
GridView;
gv.DataSource = Cache["DataSet"]
as
DataSet;
gv.DataBind();
return gv;
}
|
The purpose of the GetGridView method is to return the
populated GridView. Once, the populated GridView is returned it is
exported to the Excel file. Please also download the sample file which are
attached at the end of the article.
I hope you liked the article, happy coding!