saving datatable to excel without popup

[viktor9990]

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(DataTable dt, HttpResponse response)
{
// clean up response object
response.Clear();
response.Charset = "";
response.Charset = "UTF-8";
response.ContentEncoding = System.Text.Encoding.Default;

// set response object's mime type
response.ContentType = "application/vnd.ms-excel";

System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

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.AlternatingItemStyle.BackColor = System.Drawing.Color.LightGray;
dg.DataBind();
dg.RenderControl(htw);

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