NetSir

Good Good Study,Day Day Up!

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::

<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");

    }
}

posted on 2010-09-05 13:22  NetSir  阅读(454)  评论(3编辑  收藏  举报