跪求导出数据

Question

各位大虾们，能教我怎么从sql server2000数据库中导出全部的数据表到word文件中吗？？？不甚感激

Answer 1

/// 将Web控件导出
        /// </summary>
        /// <param name="source">控件实例</param>
        /// <param name="type">类型:Excel或Word</param>
        public void ExpertControl(System.Web.UI.Control source, DocumentType type)
        {
            //设置Http的头信息,编码格式
            if (type == DocumentType.Excel)
            {
                //Excel
                Response.AppendHeader("Content-Disposition","attachment;filename=result.xls");
                Response.ContentType = "application/ms-excel";
            }
            else if (type == DocumentType.Word)
            {
                //Word
                Response.AppendHeader("Content-Disposition","attachment;filename=result.doc");
                Response.ContentType = "application/ms-word";
            }
            Response.Charset = "UTF-8";  
            Response.ContentEncoding = System.Text.Encoding.UTF8;             //关闭控件的视图状态
            source.Page.EnableViewState =false;              //初始化HtmlWriter
            System.IO.StringWriter writer = new System.IO.StringWriter() ;
            System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer);
            source.RenderControl(htmlWriter);             //输出
            Response.Write(writer.ToString());
            Response.End();
        }        //文档类型
        public enum DocumentType
        {
            Word,
            Excel
        }把数据取出来放DataSet 或者DataTable里 然后去搜 DataTable导出WORD

Answer 2

http://www.cnblogs.com/dreamof/archive/2008/06/13/1219437.html