public class ExcelCreator
{
    public static void DataSetToExcel(int aid,DataSet dataSet,HttpResponse response)
    {
    response.Clear();
    response.ContentType="application/vnd.ms-excel";
    response.Charset="iso-8859-9";

    StringWriter stringWriter=new StringWriter();
    HtmlTextWriter htmlTextWriter=new HtmlTextWriter(stringWriter);

    DataGrid dataGrid=new DataGrid();
    dataGrid.DataSource=dataSet.Tables[0];
    dataGrid.DataBind();
    dataGrid.RenderControl(htmlTextWriter);
    response.Write(stringWriter.ToString());
    response.End();
    }
}


ExcelCreator.DataSetToExcel(id,dataSet,Response);