在gridview导出为excel时,如何不导出HyperLinkField?gridview中有一个HyperLinkField,如何在导出excel时,不导出,
主要导出方法:
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
主要导出方法:
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
就是用户单击这个hyperlink时,需要取本行的一个id字段,打开一个新窗口,并定制新窗口的位置及大小,
也就是一个对话框窗口
弹出窗口给HyperLinkField加个属性,用onclick,用js实现.
当然,HyperLinkField也是可以的,你需要在绑定事件里面写一些代码的
gridview显示产品信息,其中有一个按钮,单击后,要求打开一个小窗口,显示该行产品的明细信息
谢谢~~~~
<%@ 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>