在gridview导出为excel时,如何不导出HyperLinkField?

jyh070207 2012-05-29 07:17:51

在gridview导出为excel时,如何不导出HyperLinkField?

gridview中有一个HyperLinkField,如何在导出excel时,不导出,
主要导出方法:
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();

...全文

118 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

jyh070207 2012-06-01

打赏
举报

谢谢!!

孟子E章 2012-06-01

打赏
举报

你还可以这样

<%@ Page Language="C#" Debug="true" %>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">



  private System.Data.DataTable GetData()

  {

    System.Data.DataTable dt = new System.Data.DataTable();

    System.Data.DataRow dr;

    dt.Columns.Add(new System.Data.DataColumn("UserId", typeof(System.Int32)));

    dt.Columns.Add(new System.Data.DataColumn("Name", typeof(System.String)));

    dt.Columns.Add(new System.Data.DataColumn("Count", typeof(System.Double)));

    dt.Columns.Add(new System.Data.DataColumn("CreateDate", typeof(System.DateTime)));

    dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns["UserId"] };

    System.Random rd = new System.Random();

    for (int i = 0; i < 6; i++)

    {

      dr = dt.NewRow();

      dr[0] = i + i;

      dr[1] = "【孟子E章】" + i.ToString();

      dr[2] = System.Math.Ceiling(rd.NextDouble() * 1000);

      dr[3] = DateTime.Now.AddDays(rd.Next(100) - rd.Next(100));

      dt.Rows.Add(dr);

    }

    return dt;

  }

  protected void Page_Load(object sender, EventArgs e)

  {



    if (!Page.IsPostBack)

    {

      GridView1.DataSource = GetData();

      GridView1.DataBind();

    }

  }



  protected void Button1_Click(object sender, EventArgs e)

  {

    Response.Clear();

    Response.Buffer = true;

    Response.Charset = "GB2312";

    Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");

    Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");

    Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 

    System.IO.StringWriter oStringWriter = new System.IO.StringWriter();

    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

    GridView1.Columns[3].Visible = false;    

    this.GridView1.RenderControl(oHtmlTextWriter);

    Response.Output.Write(oStringWriter.ToString());

    Response.Flush();

    Response.End();

  }

  public override void VerifyRenderingInServerForm(Control control) { }

  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

  {

    if (e.Row.RowType == DataControlRowType.DataRow)

    {

      HyperLink x = e.Row.Cells[3].Controls[0] as HyperLink;

      x.Attributes.Add("onclick", "window.open('','_xx','width=200,height=300,left=200');");

      x.Target = "_xx";

    }



  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

</head>

<body>

  <form id="form1" runat="server">

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="GridView1_RowDataBound">

    <Columns>

      <asp:BoundField DataField="Name" HeaderText="姓名" />

      <asp:BoundField DataField="Count" />

      <asp:BoundField DataField="CreateDate" />

      <asp:HyperLinkField DataNavigateUrlFields="UserId" DataTextField="Name" DataNavigateUrlFormatString="http://dotnet.aspx.cc/?id={0}" />

    </Columns>

  </asp:GridView>

  <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出到Excel" />

  </form>

</body>

</html>

孟子E章 2012-06-01

打赏
举报

例子

<%@ Page Language="C#" Debug="true" %>



<%@ Import Namespace="System.Xml" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.OleDb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">



  public bool isExport = false;



  private System.Data.DataTable GetData()

  {

    System.Data.DataTable dt = new System.Data.DataTable();

    System.Data.DataRow dr;

    dt.Columns.Add(new System.Data.DataColumn("学生班级", typeof(System.String)));

    dt.Columns.Add(new System.Data.DataColumn("学生姓名", typeof(System.String)));

    dt.Columns.Add(new System.Data.DataColumn("语文", typeof(System.Decimal)));

    System.Random rd = new System.Random();

    for (int i = 0; i < 8; i++)

    {

      dr = dt.NewRow();

      dr[0] = "班级" + i.ToString();

      dr[1] = "【孟子E章】" + i.ToString();

      dr[2] = System.Math.Round(rd.NextDouble() * 100, 0);

      dt.Rows.Add(dr);

    }

    return dt;

  }

  protected void Page_Load(object sender, EventArgs e)

  {

    

    if (!Page.IsPostBack)

    {



      GridView1.DataSource = GetData();

      GridView1.DataBind();

    }

  }



  protected void Button1_Click(object sender, EventArgs e)

  {

    isExport = true;   

    Response.Clear();

    Response.Buffer = true;

    Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

    Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");

    Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 

    System.IO.StringWriter oStringWriter = new System.IO.StringWriter();

    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

    GridView1.DataSource = GetData();

    GridView1.DataBind();

    this.GridView1.RenderControl(oHtmlTextWriter);

    Response.Output.Write(oStringWriter.ToString());

    Response.Flush();

    Response.End();

  }

  public override void VerifyRenderingInServerForm(Control control) { }

  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

  {

    if (isExport)

    {

      e.Row.Cells[1].Visible = false;

    }

    else

    {

      if (e.Row.RowType == DataControlRowType.DataRow)

      {

        HyperLink x = e.Row.Cells[1].Controls[0] as HyperLink;

        x.Attributes.Add("onclick", "window.open('','_xx','width=200,height=300,left=200');");

        x.Target = "_xx";

      }

    }

  }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

</head>

<body>

  <form id="form1" runat="server">

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="GridView1_RowDataBound">

    <Columns>

      <asp:BoundField DataField="学生班级" />

      <asp:HyperLinkField DataNavigateUrlFields="学生班级" DataTextField="学生姓名" DataNavigateUrlFormatString="xx.aspx?id={0}" />

    </Columns>

  </asp:GridView>

  <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />

  </form>

</body>

</html>

jyh070207 2012-06-01

打赏
举报

[Quote=引用 6 楼的回复:]
定制新窗口的位置及大小？

你可以使用模板列，怎么定义都可以，为啥非要HyperLinkField？
当然，HyperLinkField也是可以的，你需要在绑定事件里面写一些代码的
[/Quote]能否具体一些,对asp.net学习不久,实际上要实现的效果就是,
gridview显示产品信息,其中有一个按钮,单击后，要求打开一个小窗口，显示该行产品的明细信息。。。
谢谢~~~~

孟子E章 2012-06-01