人生過程精彩才是重點

相信有用ASP.NET 2.0的人若是有需要將資料庫資料轉成Excel檔案給別人使用時,有時會因為編碼問題而困擾

因此我把我知道的分享給大家知道一下

若有需要的人就自己拿去用吧

private void ExportCVS()
    {
        Response.Clear();
        Response.Buffer = true;
        string filename = DateTime.Now.ToString("yyyyMMdd") + "test.csv";
        Response.AddHeader("content-disposition", "attachment;filename=" + filename);

        Response.Charset = "BIG5";
        Response.ContentType = "application/text";
        Response.ContentEncoding = Encoding.GetEncoding(950);//950就是所謂的BIG5
        gvList.AllowPaging = false;
        //gvList.DataBind();
        QueryData();


        StringBuilder sb = new StringBuilder();
        for (int k = 0; k < gvList.Columns.Count; k++)
        {

            //add separator

            sb.Append(gvList.Columns[k].HeaderText + ',');

        }

        //append new line

        sb.Append("\r\n");

        for (int i = 0; i < gvList.Rows.Count; i++)
        {

            for (int k = 0; k < gvList.Columns.Count; k++)
            {

                //add separator
                sb.Append(gvList.Rows[i].Cells[k].Text + ',');

            }

            //append new line

            sb.Append("\r\n");

        }

        Response.Output.Write(sb.ToString());
        Response.Flush();
        Response.End();
        gvList.AllowPaging = true ;
        QueryData();
    }