0

I am having this code...

public void ExportClientsListToExcel()
{
    var grid = new System.Web.UI.WebControls.GridView();

    grid.DataSource = db.GetCompleteEmpReport();

    grid.DataBind();

    Response.ClearContent();
    Response.AddHeader("content-disposition", "attachment; filename=Exported_Diners.xls");
    Response.ContentType = "application/excel";
    StringWriter sw = new StringWriter();
    HtmlTextWriter htw = new HtmlTextWriter(sw);

    grid.RenderControl(htw);

    Response.Write(sw.ToString());

    Response.End();

}

where in I am getting the stored procedure data,populating the grid and then getting the Exported to Excel.It does not give me any error but not getting the required Exported file.Where I have gone wrong?

I am getting the required data in sw.ToString() part but not getting exported. I am calling that method by ajax Post call on the client side and have this code

  $("#btnExport").click(function (event) {
        $.ajax({
            url: 'Home/ExportClientsListToExcel',
            type: 'POST',
            success: function (status) {
                alert();
            },
        });
    });

The alert() popup is also coming.

akash
  • 173
  • 1
  • 14

0 Answers0