将GridView导入到Excel和word完全可实现.docx
- 文档编号:1169682
- 上传时间:2023-04-30
- 格式:DOCX
- 页数:11
- 大小:22.79KB
将GridView导入到Excel和word完全可实现.docx
《将GridView导入到Excel和word完全可实现.docx》由会员分享,可在线阅读,更多相关《将GridView导入到Excel和word完全可实现.docx(11页珍藏版)》请在冰点文库上搜索。
将GridView导入到Excel和word完全可实现
1.将GridView导入到Excel和word
需要注意两个地方:
1.EnableEventValidation="false"必须加
2.下面这个事件必须加
publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)
{
//base.VerifyRenderingInServerForm(control);
}
3、若有分页功能
在<%@PageLanguage="C#"...%>中加上EnableEventValidation="false"
加了这个必须在导出前取消分页,否则只导出当前页,而不是整个gridview的数据。
在我的资源里有相应的原代码下载
<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="excel.aspx.cs"EnableEventValidation="false"Inherits="将GridView导出到Excel_excel"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http:
//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
//www.w3.org/1999/xhtml">
GridViewID="GridView1"runat="server"AllowPaging="True"AutoGenerateColumns="False" CellPadding="4"DataKeyNames="stuid"DataSourceID="SqlDataSource1"ForeColor="#333333" GridLines="None"> BoundFieldDataField="stuid"HeaderText="编号"InsertVisible="False"ReadOnly="True" SortExpression="stuid"/> BoundFieldDataField="stuname"HeaderText="姓名"SortExpression="stuname"/> CheckBoxFieldDataField="stusex"HeaderText="性别"SortExpression="stusex"/> BoundFieldDataField="stuaddress"HeaderText="地址"SortExpression="stuaddress"/> BoundFieldDataField="stuage"HeaderText="年龄"SortExpression="stuage"/> BoundFieldDataField="stutuition"HeaderText="学费"SortExpression="stutuition"/> BoundFieldDataField="stuaveragescore"HeaderText="成绩"SortExpression="stuaveragescore"/> GridView>
SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings: myTestGridViewConnectionString%>" SelectCommand="SELECT*FROM[stu]">
SqlDataSource>
ButtonID="Button1"runat="server"Text="导出到Excel"OnClick="Button1_Click"/> ButtonID="Button2"runat="server"OnClick="Button2_Click"Text="导出到Word"Width="108px"/>