hi,

i have a web page on which i am displaying data in gridview control from database.i want to generate the excel report of this grid data. i am using the following code behind button click. it is working well.

private void ExportGridView()
{
     string attachment = "attachment; filename=invalidproductdata.xls";
     Response.ClearContent();
     Response.AddHeader("content-disposition", attachment);
     Response.ContentType = "application/ms-excel";
     StringWriter sw = new StringWriter();
     HtmlTextWriter htw = new HtmlTextWriter(sw);
     myGridView.RenderControl(htw);
     Response.Write(sw.ToString());
     Response.End();
}

but the problem is that i want to take this code into my code class in business logic layer for reuse purpose.but when i put this method in logic layer class it creates an error. the error is " Response does not exist in the current context ".
plz help me how can i resolve this issue.

Thanks and Best Regards,
Nice Candy