当前位置导航:炫浪网>>网络学院>>网页制作>>ASP.NET教程

ListView中的内容以Excel导出

  <div>

  <asp:ListView ID="ListView1" runat="server">

  <ItemTemplate>

  <tr>

  <td id="Td1" runat="server" style="">

  <asp:Label ID="idLabel" runat="server" Text='<%# Eval("name") %>' />

  <br />

  </td>

  <td>

  <asp:Label ID="xLabel" runat="server" Text='<%# Eval("Age") %>' />

  <br />

  </td>

  </tr>

  </ItemTemplate>

  <LayoutTemplate>

  <table id="Table1" runat="server" border="0" style="">

  <tr runat="server" id="itemPlaceholder" />

  </table>

  </LayoutTemplate>

  </asp:ListView>

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

  onclick="Button1_Click" />

  后台代码

  public partial class ListView_Code13 : System.Web.UI.Page

  {

  DataAccess da;

  protected void Page_Load(object sender, EventArgs e)

  {

  if (Session["da"] == null)

  {

  da = new DataAccess();

  Session["da"] = da;

  }

  else

  {

  da = Session["da"] as DataAccess;

  }

  if (!IsPostBack)

  {

  Bind();

  }

  }

  private void Bind()

  {

  ListView1.DataSource = da.List;

  ListView1.DataBind();

  }

  private void Export(string FileType, string FileName)

  {

  Response.Charset = "GB2312";

  Response.ContentEncoding = System.Text.Encoding.UTF7;

  Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

  Response.ContentType = FileType;

  this.EnableViewState = false;

  StringWriter tw = new StringWriter();

  HtmlTextWriter hw = new HtmlTextWriter(tw);

  ListView1.RenderControl(hw);

  Response.Write(tw.ToString());

  Response.End();

  }

  protected void Button1_Click(object sender, EventArgs e)

  {

  Export("application/ms-excel", "employee.xls");

  }

  }

相关内容
赞助商链接