你有没有把DataGrid 放在<form runat=Server></form>里面啊
解决方案 »
- C#正则表达式问题
- 多站点实现文件同步
- 采集器获取Post分页数据
- 关于kindeditor编辑器上传图片的问题
- 求asp.net(C#)打开Excel,读数据,写Excel,最后关闭Excel的小例子!
- 郁闷中~~配置错误,我已经把虚拟目录作为应用程序进行配置可还是不行!
- 关于ASP.NET(C#)语言网站的问题?
- aspx 关于 AspNetPager 控件 当前第几页的问题。
- 关于TreeView控件的问题
- In our W2K domain, I've had some users recently metion that they've had some errors popping up when trying to save files over th
- 问个脚本的问题
- 大家有没有碰到过这样的情况,当点击按钮时让它javascript打开一个return false的子窗口同时添加事件
你导出到excel的语句也可能存在问题,我以前用你的"application/ms-excel"没有成功,改为
"application/octet-stream"好像就可以了, 你试一试吧
<form id="Form1" method="post" runat="server">
<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="100%" align="center" background="images/treetopbg.jpg"
border="0">
<TR>
<TD class="bk" width="10"><FONT face="宋体"> </FONT></TD>
<TD class="bk" width="25"><IMG height="16" src="images/staff.gif" width="16"></TD>
<TD class="bk" height="30">首页 >> 人力资源管理 >> 员工基本信息
<asp:label id="labParam" runat="server" Visible="False"></asp:label><asp:label id="labSelect" runat="server"></asp:label><asp:label id="aa" runat="server"></asp:label><asp:label id="lblSearch" runat="server" Visible="False"></asp:label></TD>
</TR>
</TABLE>
<table cellSpacing="0" cellPadding="0" width="100%" align="center" bgColor="snow" border="0">
<TR height="30">
<TD colSpan="5" height="6"></TD>
</TR>
<TR height="30">
<TD colSpan="5"> 按公司分类:<IMG height="12" src="images/acc.gif" width="12">
<asp:linkbutton id="lnbCompanyft" runat="server">方特投资发展有限公司</asp:linkbutton><IMG height="12" src="images/acc.gif" width="12">
<asp:linkbutton id="lnbCompanyzn" runat="server">华强智能技术有限公司</asp:linkbutton><IMG height="12" src="images/acc.gif" width="12">
<asp:linkbutton id="lnbCompanysm" runat="server">华强数码电影有限公司</asp:linkbutton>
<asp:Button id="btnExcel" runat="server" Text="导出EXCEL" CssClass="redButtonCss"></asp:Button><FONT face="宋体"> </FONT>
<asp:button id="cmdSearch" runat="server" CssClass="redButtonCss" Text="高级搜索"></asp:button><FONT face="宋体"> </FONT>
<asp:button id="Button1" runat="server" CssClass="redButtonCss" Text="生成报表"></asp:button><FONT face="宋体"> </FONT>
</TD>
</TR>
</table>
<table cellSpacing="0" cellPadding="0" width="98%" align="center" border="0">
<tr>
<td height="8"><FONT face="宋体"></FONT></td>
</tr>
</table>
<table cellSpacing="0" cellPadding="0" width="98%" align="center" border="0">
<tr>
<TD>
<TABLE class="gbtext" id="Table2" cellSpacing="0" cellPadding="0" width="100%" border="0">
<TR>
<TD style="WIDTH: 70px" align="center" width="70" height="24"><asp:button id="btnAll" runat="server" CssClass="redbuttoncss" Width="60px" Text="全部员工"></asp:button></TD>
<TD style="WIDTH: 70px" align="center" width="70" height="24"><asp:button id="btnOnduty" runat="server" CssClass="redbuttoncss" Width="60px" Text="在职员工"></asp:button></TD>
<TD style="WIDTH: 70px" align="center" width="71" height="24"><asp:button id="btnOutduty" runat="server" CssClass="redbuttoncss" Width="60px" Text="离职员工"></asp:button></TD>
<TD style="WIDTH: 75px" align="center" width="77" height="24"><asp:button id="btnWillon" runat="server" CssClass="redbuttoncss" Width="70px" Text="将转正员工"></asp:button></TD>
<TD align="center"><asp:label id="lblShowCount" runat="server"></asp:label></TD>
<TD style="WIDTH: 210px" align="right"><asp:button id="cmdNew" runat="server" CssClass="redbuttoncss" Text="新员工"></asp:button> <asp:button id="btnDimission" runat="server" CssClass="redbuttoncss" Text="离职"></asp:button> <asp:button id="btnChangePosition" runat="server" CssClass="redbuttoncss" Text="调职"></asp:button> <asp:button id="btnOn" runat="server" CssClass="redbuttoncss" Text="转正"></asp:button> </TD>
</TR>
<TR>
<TD style="WIDTH: 70px" align="center" width="70" height="2"></TD>
<TD style="WIDTH: 70px" align="center" width="70" height="2"></TD>
<TD style="WIDTH: 71px" align="center" width="71" height="2"></TD>
<TD style="WIDTH: 77px" align="center" width="77" height="2"></TD>
<TD align="right"></TD>
</TR>
</TABLE>
</TD>
</tr>
<tr>
<td align="center"><asp:datagrid id="Employeeinfo" runat="server" Width="100%" AutoGenerateColumns="False" AllowPaging="True"
BorderColor="#93BEE2" PageSize="20" DataKeyField="Einfo_number">
<AlternatingItemStyle HorizontalAlign="Center" BackColor="#E8F4FF"></AlternatingItemStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<HeaderStyle Font-Bold="True" HorizontalAlign="Center" Height="30px" ForeColor="White" BackColor="#337FB2"></HeaderStyle>
<FooterStyle HorizontalAlign="Right"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="Einfo_number" HeaderText="编号">
<HeaderStyle Width="8%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Einfo_name" HeaderText="姓名">
<HeaderStyle Width="10%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Einfo_sex" HeaderText="性别">
<HeaderStyle Width="5%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Einfo_company" HeaderText="公司">
<HeaderStyle Width="18%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Einfo_dep" HeaderText="部门">
<HeaderStyle Width="10%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Einfo_depsmall" HeaderText="分部门">
<HeaderStyle Width="10%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Einfo_ontime" HeaderText="聘用时间">
<HeaderStyle Width="10%"></HeaderStyle>
</asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
</asp:datagrid></td>
</tr>
</table>
</form>
这样好像是把DATAAGRID放在<FORM>和</FORM>之间了吧
你的错误提示所说明的问题就是这个原因,如果不是这个问题,那我也不知道什么原因了
但我是肯定要分页的,所以请问一下有没有在分页情况下实现导出EXCEL的功能呀
要从 DataGrid 导出数据必须不分页。 可以从它的数据源里取数据赋给你的方法, 然后方法里凭空创建一个不分页的 DataGrid 绑定这个数据源, 再 render 到页面即可。