ASP.NET 2.0,C#—-利用GridView控制項匯出其他檔案(匯出Excel,匯出Word檔案)

來源:互聯網
上載者:User

// 注意,在Visual Studio2005平台下,如果使用GridView匯出檔案,

        //就必須重載VerifyRenderingInServerForm方法

        public override void VerifyRenderingInServerForm(Control control)

        {

          

        }

 

        /// <summary>

        ///  匯出到檔案的方法,

        /// </summary>

        /// <param name="Model">Model=1:匯出為Execl,Model=2:匯出為Word</param>

        private void toFiles(int Model)

        {

            string strFileName = DateTime.Now.ToString("yyyyMMdd-hhmmss");

            System.Web.HttpContext HC = System.Web.HttpContext.Current;

             HC.Response.Clear();

             HC.Response.Buffer = true;

             HC.Response.ContentEncoding = System.Text.Encoding.UTF8;//設定輸出資料流為簡體中文

 

            if (Model == 1)

            {

                //---匯出為Excel檔案

                 HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls");

                 HC.Response.ContentType = "application/ms-excel";//設定輸出檔案類型為excel檔案。

            }

            else

            {

                //--- 匯出為Word檔案

                 HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".doc");

                 HC.Response.ContentType = "application/ms-word";//設定輸出檔案類型為Word檔案。

            }

 

            System.IO.StringWriter sw = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

            this.GridView1.RenderControl(htw);

 

             HC.Response.Write(sw.ToString());

             HC.Response.End();

         

        }

        //-匯出為Excel檔案

        protected void ToExecl_Click(object sender, EventArgs e)

        {

            toFiles(1);

        }

        //-匯出為Word檔案

        protected void Button1_Click(object sender, EventArgs e)

        {

            toFiles(2);

        } 

 

本文來自CSDN部落格,轉載請標明出處:http://blog.csdn.net/bl_song/archive/2009/07/13/4344895.aspx

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.