saving datatable to excel without popup

I'm using the following class to save data from database to an excel sheet. I
wonder how to do so without a popup box showing up (open, save)?Thanks
I want to save the exel sheet on the hard drive without letting the user see
this pop up.

public static void Export(DataTabl e dt, HttpResponse response)
{
// clean up response object
response.Clear( );
response.Charse t = "";
response.Charse t = "UTF-8";
response.Conten tEncoding = System.Text.Enc oding.Default;

// set response object's mime type
response.Conten tType = "applicatio n/vnd.ms-excel";

System.IO.Strin gWriter sw = new System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter htw = new System.Web.UI.H tmlTextWriter(s w);

DataGrid dg = new DataGrid();
dg.AllowPaging = false;
dg.AllowSorting = false;
dg.DataSource = dt;
dg.ShowHeader = true;
dg.HeaderStyle. BackColor = System.Drawing. Color.DarkGray;
dg.HeaderStyle. ForeColor = System.Drawing. Color.White;
dg.HeaderStyle. Font.Bold = true;
dg.AlternatingI temStyle.BackCo lor = System.Drawing. Color.LightGray ;
dg.DataBind();
dg.RenderContro l(htw);

response.Write( WriteHeader());
response.Write( sw.ToString());
response.Write( WriteFooter());
response.End();
}