C#通用类库--导出数据（比其他方式快200倍）

做数据库处理的时候，经常需要将数据导出，一般都是导出到EXCEL，网上很多方法都是用EXCEL组件，自己感觉效率比较低，于是重新用流处理的方式导出数据，在数据量大的情况下，速度不知道快了多少，非常快，而且导出格式可以是EXCEL，WORD，TXT等，自由设定，不多说，贴出代码，直接传入对应参数即可！

//类名:EcanOutPutData
//作用:导出数据（二进制流的形式）
//作者：刘典武
//时间：2010-12-01

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data ;

namespace Ecan
{
    public class EcanOutPutData
    {
        /// <summary>
        /// 从listbox中导出数据
        /// </summary>
        /// <param name="lbox">listbox控件</param>
        /// <param name="txtTitle">导出数据的标题</param>
        /// <param name="filter">导出数据的格式(拓展名)</param>
        public void outPutListBoxData(ListBox lbox,string txtTitle, string filter)
        {
            SaveFileDialog save = new SaveFileDialog();
            save.Filter = "user files("+filter +")|" + filter;
            save.Title = "导出文件到";

            if (save.ShowDialog() == DialogResult.OK)
            {
                Stream myStream = save.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("GB2312"));
                try
                {
                    //写标题
                    sw.WriteLine(txtTitle);
                    //循环写内容
                    for (int i = 0; i < lbox.Items.Count; i++)
                    {
                        string tempStr = "";
                        tempStr += lbox.Items[i].ToString();
                        tempStr += "\t";
                        sw.WriteLine(tempStr);
                    }
                    MessageBox.Show("导出数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    sw.Close();
                    myStream.Close();
                }
                catch (Exception ee)
                {
                    MessageBox.Show(ee.Message);                    
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }

        /// <summary>
        /// 导出DataSet数据
        /// </summary>
        /// <param name="ds">数据源</param>
        /// <param name="txtTitle">导出数据的标题</param>
        /// <param name="filter">导出数据的格式</param>

        public void outPutDataSet(DataSet ds, string txtTitle, string filter)
        {
            SaveFileDialog save = new SaveFileDialog();
            save.Filter = "user files(" + filter + ")|" + filter;
            save.Title = "导出文件到";

            if (save.ShowDialog() == DialogResult.OK)
            {
                Stream myStream = save.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("GB2312"));
                try
                {
                    //写标题
                    sw.WriteLine(txtTitle);
                    //写数据字段
                    string tempTitle = "";
                    for (int i = 0; i < ds.Tables[0].Columns.Count;i++ )
                    {
                        if (i > 0)
                        {
                            tempTitle += "\t";
                        }
                        tempTitle += ds.Tables[0].Columns[i].ColumnName;
                    }
                    sw.WriteLine(tempTitle);

                    //循环写内容
                    for (int j = 0; j < ds.Tables [0].Rows .Count ; j++)
                    {
                        string tempStr = "";
                        for (int k = 0; k < ds.Tables[0].Columns.Count; k++)
                        {
                            if (k > 0)
                            { tempStr += "\t"; }
                            tempStr += ds.Tables[0].Rows[j][k].ToString();
                        }
                        sw.WriteLine(tempStr);
                    }
                    MessageBox.Show("导出数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    sw.Close();
                    myStream.Close();
                }
                catch (Exception ee)
                {
                    MessageBox.Show(ee.Message);                    
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }

        /// <summary>
        /// 导出DataGridView数据
        /// </summary>
        /// <param name="dgv">DataGridView控件</param>
        /// <param name="txtTitle">导出数据标题</param>
        /// <param name="filter">导出数据格式</param>

        public void outPutDataGridViewData(DataGridView dgv, string txtTitle, string filter)
        {
            DataSet myds =(DataSet ) dgv.DataSource;
            this.outPutDataSet(myds, txtTitle, filter);
        }

        /// <summary>
        /// 导出DataGridView数据
        /// </summary>
        /// <param name="dgv">DataGridView控件</param>        
        /// <param name="filter">导出数据格式</param>

        public void outPutDataGridViewData(DataGridView dgv, string filter)
        {
            SaveFileDialog save = new SaveFileDialog();
            save.Filter = "user files(" + filter + ")|" + filter;
            save.Title = "导出文件到";

            if (save.ShowDialog() == DialogResult.OK)
            {
                Stream myStream = save.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("GB2312"));
                try
                {                    
                    //写数据字段
                    string tempTitle = "";
                    for (int i = 0; i <dgv.Columns .Count ; i++)
                    {
                        if (i > 0)
                        {
                            tempTitle += "\t";
                        }
                        tempTitle += dgv.Columns[i].Name;
                        //tempTitle += ds.Tables[0].Columns[i].ColumnName;
                    }
                    sw.WriteLine(tempTitle);

                    //循环写内容
                    for (int j = 0; j <dgv.Rows .Count ;j++)
                    {
                        string tempStr = "";
                        for (int k = 0; k < dgv.Columns.Count; k++)
                        {
                            if (k > 0)
                            { tempStr += "\t"; }
                            tempStr += dgv.Rows[j].Cells[k].Value.ToString();
                        }
                        sw.WriteLine(tempStr);
                    }
                    MessageBox.Show("导出数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    sw.Close();
                    myStream.Close();
                }
                catch (Exception ee)
                {
                    MessageBox.Show(ee.Message);                    
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }
    }
}

一个C#资源分享平台，专业分享学习高质量代码，每周期布置学习任务，激发学习C#兴趣！(QQ群：128874886)