ASP.NET 2.0 代码积累/收藏.

1.导出到Excel 格式问题(2006-11-01)

    /**//// <summary>
    /// 把GridView导出到Excel,保持原来格式,比如小数位
    /// </summary>
    /// <param name="agv"></param>
    /// <param name="excelFileName"></param>
    private void ExportExcel(Atos.Controls.AtosGridView agv, String excelFileName)
    {
        string style = @"<style> .text { mso-number-format:\@; } </style> ";//小数部分保留的设置,载RowDataBound里需要添加e.Row.Cells[4].Attributes.Add("class", "text");
        agv.Page.Response.Clear();
        agv.Page.Response.Charset = "UTF8";
        agv.Page.Response.ContentEncoding = System.Text.Encoding.UTF8;
        agv.Page.Response.AppendHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(excelFileName, System.Text.Encoding.UTF8) + ".xls");
        agv.Page.Response.ContentType = "application/vnd.ms-excel;charset=UTF8";
        agv.Page.Response.ContentEncoding = System.Text.Encoding.UTF8;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        agv.RenderControl(oHtmlTextWriter);
        Response.Write(style);
        agv.Page.Response.Write(oStringWriter.ToString());
        agv.Page.Response.End();

    }

text里绑定多个字段方法一

<asp:GridView ID="GridView1" runat="server">
        <Columns>
        <asp:TemplateField>
        <ItemTemplate>
          <asp:Image ID="Image1" runat="server"   ImageUrl='<%# DataBinder.Eval(Container.DataItem, "ImageName").ToString()+"/" +DataBinder. Eval(Container.DataItem, "ImageName").ToString() %> '   />
        </ItemTemplate>
         

        </asp:TemplateField>
        </Columns>
        </asp:GridView>