Excel Import - having difficulties

[RazSam]

Hi

I am developing in c# .net 2,0 web forms and having some problems. Code is attached below.

I have written code to export the contents of a Grid View to Excel, this works. The problem occurs when i change the contents of the datagrid such as apply a row filter to it. The new records have been binded to the datasource.

I try to export those results to Excel but seem to the whole datagrid contents into Excel instead of the filtered results.

Example: Filter the datagrid to display three records and then i Export to Excel, Excel should only display those records instead all the records are displayed

Code:
Table objTable = new Table();
StringBuilder str = new StringBuilder() ;

if ((GridView1.Hea derRow) != null)
{
objTable.Rows.A dd(GridView1.He aderRow);
}

foreach (GridViewRow row in GridView1.Rows)
{
str.Append (objTable.Rows. Add(row).GetTyp e());
}

if ((GridView1.Foo terRow) != null)
{
objTable.Rows.A dd(GridView1.Fo oterRow);
}

Response.Clear( );

Response.AddHea der("content-disposition", "attachment;fil ename=FileName. xls");
Response.Charse t = "";

// Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);

Response.Conten tType = "applicatio n/vnd.xls";

System.IO.Strin gWriter stringWrite = new System.IO.Strin gWriter();

System.Web.UI.H tmlTextWriter htmlWrite = new HtmlTextWriter( stringWrite);

//GridView1.Allow Paging = false;
//GridView1.DataB ind();

objTable.Render Control(htmlWri te);

//GridView1.Allow Paging = true;
//GridView1.DataB ind();

Response.Write( stringWrite.ToS tring());

Response.End();

Thanks

Raz