感谢查看我的问题并提供帮助。我有一个用C#构建的asp.net应用程序,其中包含一个简单的网格视图。我有一个按钮可以将网格视图导出到Excel中,这也有效。然而,我的网格视图在第一列有一个编辑链接,在第二列有一个删除按钮。这两个列也会被导出到Excel中。我该如何停止这两列被导出?我尝试了几件事情:
GridView1.Columns.RemoveAt(0);
GridView1.Columns.RemoveAt(1);
并且...
GridView1.Column(0).visible = false;
我尝试了每个方法之后都进行了数据绑定,但它根本不起作用。我会在下面发布我的代码,也许有人可以帮助我!谢谢!
public void ExportGridToExcel(GridView grdGridView, string fileName)
{
Response.Clear();
Response.AddHeader("content-disposition",
string.Format("attachment;filename={0}.xls", fileName));
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
grdGridView.RenderControl(htmlWrite);
GridView1.Columns.RemoveAt(0);
Response.Write(stringWrite.ToString());
Response.End();
GridView1.AllowPaging = false;
}
GridView的编辑功能被设置为True,删除按钮是一个模板字段,如下:
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btnDelete" CommandName="Delete" runat="server" Text="Delete" CssClass="okbutton" OnClientClick="return confirm('Are you sure you want to delete this entry?');" />
</ItemTemplate>
</asp:TemplateField>