将GridView导入到Excel和word(完全可实现)12.docVIP

  • 0
  • 0
  • 约9.3千字
  • 约 13页
  • 2018-05-02 发布于贵州
  • 举报

将GridView导入到Excel和word(完全可实现)12.doc

将GridView导入到Excel和word(完全可实现)12

1.将GridView导入到Excel和word 需要注意两个地方: 1.EnableEventValidation=false 必须加 2.下面这个事件必须加 public override void VerifyRenderingInServerForm(Control control) ??? { ??????? //base.VerifyRenderingInServerForm(control); ??? } 在%@ Page Language=C# ...%中加上EnableEventValidation=false 加了这个必须在导出前取消分页,否则只导出当前页,而不是整个gridview的数据。 在我的资源里有相应的原代码下载 %@ Page Language=C# AutoEventWireup=true CodeFile=excel.aspx.cs EnableEventValidation=false Inherits=将GridView导出到Excel_excel % !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head runat=server ??? title将Gridview导出到Excel,Word/title /head body ??? form id=form1 runat=server ??? div ??????? asp:GridView ID=GridView1 runat=server AllowPaging=True AutoGenerateColumns=False ??????????? CellPadding=4 DataKeyNames=stuid DataSourceID=SqlDataSource1 ForeColor=#333333 ??????????? GridLines=None ??????????? FooterStyle BackColor=#5D7B9D Font-Bold=True ForeColor=White / ??????????? Columns ??????????????? asp:BoundField DataField=stuid HeaderText=编号 InsertVisible=False ReadOnly=True ??????????????????? SortExpression=stuid / ??????????????? asp:BoundField DataField=stuname HeaderText=姓名 SortExpression=stuname / ??????????????? asp:CheckBoxField DataField=stusex HeaderText=性别 SortExpression=stusex / ??????????????? asp:BoundField DataField=stuaddress HeaderText=地址 SortExpression=stuaddress / ??????????????? asp:BoundField DataField=stuage HeaderText=年龄 SortExpression=stuage / ??????????????? asp:BoundField DataField=stutuition HeaderText=学费 SortExpression=stutuition / ??????????????? asp:BoundField DataField=stuaveragescore HeaderText=成绩 SortExpression=stuaveragescore / ??????????? /Columns ??????????? RowStyle BackColor=#F7F6F3 ForeColor=#333333 / ??????????? EditRowStyle BackColor=#999999 / ??????????? SelectedRowStyle BackColor=#E2DED6 Font-Bold=True ForeColor=#333333 / ??????????? PagerStyle BackColor=#284775 ForeColor=White HorizontalAlign=Center / ??????????? HeaderStyle BackColo

您可能关注的文档

文档评论(0)

1亿VIP精品文档

相关文档