//Button1放在UpdatePanel外面
<asp:Button ID="Button1" runat="server" onclick="Button3_Click" Text="导出到EXCEL" /><asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server" ><asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>protected void Button3_Click(object sender, EventArgs e)
{
System.Web.UI.Control ctl = this.GridView1;
//GridView1是你在窗体中拖放的控件
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel0714.xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
HttpContext.Current.Response.ContentType = "application/ms-excel";
ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
ctl.RenderControl(hw);
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
}
以上可导出到EXCEL。但是当我把Button放到UpdatePanel里面时就导不出来了,
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Button ID="Button1" runat="server" onclick="Button3_Click" Text="导出到EXCEL" />
<asp:GridView ID="GridView1" runat="server" ><asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>提示:网页上有错误。为什么,我估计是updatepanel中不支持Response.Write方法所致,怎么修改代码也可导出到excel?
<asp:Button ID="Button1" runat="server" onclick="Button3_Click" Text="导出到EXCEL" /><asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server" ><asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>protected void Button3_Click(object sender, EventArgs e)
{
System.Web.UI.Control ctl = this.GridView1;
//GridView1是你在窗体中拖放的控件
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel0714.xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
HttpContext.Current.Response.ContentType = "application/ms-excel";
ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
ctl.RenderControl(hw);
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
}
以上可导出到EXCEL。但是当我把Button放到UpdatePanel里面时就导不出来了,
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Button ID="Button1" runat="server" onclick="Button3_Click" Text="导出到EXCEL" />
<asp:GridView ID="GridView1" runat="server" ><asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>提示:网页上有错误。为什么,我估计是updatepanel中不支持Response.Write方法所致,怎么修改代码也可导出到excel?
解决方案 »
- 怎么用ASP.NET 实现doc转化swf,就是WORD文档转化Flash文件??请教高手指点。最好给一个实例看看。
- Response.End()之后的语句还会在服务端继续执行吗?
- ███100分,求解,boundfield变dropdownlist████
- csharpziplib解压缩1.5G的文件报错,操作超时,有解决办法么
- 紧急请教! ASPX.CS里的一小点程序问题
- 如何将string类型转化为HttpPostedFile?
- Gridview中如何用Radiobuttonlist控制panel?
- 请问各位开发asp.net用vb.net好,还是用c#好,哪样比较流行?c#好学吗?
- 图片以二进制流的形式存在数据库里,怎么读取,并用image控件显示
- 目标计算机积极拒绝,无法连接 socketexception
- 关于无限级分类的疑问
- 绑定字段&时间转换问题
//重载VerifyRenderingInServerForm方法,否则运行的时候会出现如下错误提示:“类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内”
public override void VerifyRenderingInServerForm(Control control)
{
//override VerifyRenderingInServerForm.
}
前台代码:<asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <span style="color: #000000; font-family: 宋体"> <asp:Button ID="btn_export" runat="server" Text="导出" CssClass="button100" Width="80px" OnClick="Button6_Click"/></span> <asp:GridView ID="gv_oil" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%"> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#EFF3FB" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#2461BF" /> <AlternatingRowStyle BackColor="White" /> </asp:GridView> </ContentTemplate> <Triggers> </Triggers></asp:UpdatePanel
public override void VerifyRenderingInServerForm(Control control)
{
//override VerifyRenderingInServerForm.
}重载时出错.