想把datagrid导出excel的代码做成一个类来调用,可不成功,请大家帮忙看看.

Question

.aspx.cs代码:
private void Button1_Click(object sender, System.EventArgs e)
{
MyDataGrid.AllowPaging = false; 
BindGrid(); 
DGToExcel.ToExcleFile(MyDataGrid) ;
MyDataGrid.AllowPaging = true; 
BindGrid();
}
.cs类代码
public void ToExcleFile(DataGrid MyDataGrid)
{

MyDataGrid.SelectedItemStyle.BackColor = Color.White; 
MyDataGrid.AlternatingItemStyle.BackColor = Color.White; 
MyDataGrid.ItemStyle.BackColor = Color.White; 
MyDataGrid.HeaderStyle.BackColor = Color.White; 
MyDataGrid.HeaderStyle.ForeColor = Color.Red; 
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Filel123.xls");  HttpResponse resp; 
resp = Page.Response;

resp.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); 
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; 
            HttpContext.Current.Response.Charset = ""; 
MyDataGrid.EnableViewState = false; 
System.IO.StringWriter tw = new System.IO.StringWriter(); 
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); 
MyDataGrid.RenderControl(hw); 
        HttpContext.Current.Response.Write(tw.ToString()); 
    HttpContext.Current.Response.End(); 

}可就是这两句出错,
HttpResponse resp; 
resp = Page.Response;
提示:
c:\inetpub\wwwroot\DGToExcel2_Sample\WebDataAccess.cs(43): 非静态的字段、方法或属性“System.Web.UI.Page.Response”要求对象引用
在网上找了找,没能解决,请大家帮忙看看.

Answer 1

HttpResponse resp; 
//resp = Page.Response;
resp = HttpContext.Current.Response;