数据导出到excel

数据导出到excel

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Data.OleDb;

namespace DatasToExcel
{
    
        class AccessHelper
        {

            private string conn_str = null;
            private OleDbConnection ole_connection = null;
            private OleDbCommand ole_command = null;
            private OleDbDataReader ole_reader = null;
            private DataTable dt = null;

            /// 

            /// 构造函数
            /// 

            public AccessHelper（）
            {
                conn_str = @“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=‘“ + Environment.CurrentDirectory + “.\\ToAccess.mdb‘“;
                InitDB（）;
            }

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       6612  2019-04-13 16:35  DatasToExcel\DatasToExcel\AccessHelper.cs

     文件      28160  2019-04-14 21:38  DatasToExcel\DatasToExcel\bin\Debug\DatasToExcel.exe

     文件      42496  2019-04-14 21:38  DatasToExcel\DatasToExcel\bin\Debug\DatasToExcel.pdb

     文件      11600  2019-04-14 21:46  DatasToExcel\DatasToExcel\bin\Debug\DatasToExcel.vshost.exe

     文件        490  2010-03-17 22:39  DatasToExcel\DatasToExcel\bin\Debug\DatasToExcel.vshost.exe.manifest

     文件     495616  2019-04-14 21:38  DatasToExcel\DatasToExcel\bin\Debug\ToAccess - 副本.mdb

     文件     495616  2019-04-14 21:38  DatasToExcel\DatasToExcel\bin\Debug\ToAccess.mdb

     文件       9187  2019-04-13 19:40  DatasToExcel\DatasToExcel\bin\Debug\ToAccess.xls

     文件       5972  2019-04-13 17:06  DatasToExcel\DatasToExcel\DatasToExcel.csproj

     文件       4751  2019-04-14 20:49  DatasToExcel\DatasToExcel\DataToExcel.cs

     文件       8890  2019-04-13 17:06  DatasToExcel\DatasToExcel\DataToExcelTest.cs

     文件       2209  2019-04-14 21:36  DatasToExcel\DatasToExcel\Form1.cs

     文件       9490  2019-04-13 16:14  DatasToExcel\DatasToExcel\Form1.Designer.cs

     文件       6020  2019-04-13 16:14  DatasToExcel\DatasToExcel\Form1.resx

     文件        654  2019-04-14 21:46  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.csproj.FileListAbsolute.txt

     文件        975  2019-04-13 16:14  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.csproj.GenerateResource.Cache

     文件       1076  2019-04-13 16:29  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.csproj.ResolveComReference.cache

     文件      28160  2019-04-14 21:38  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.exe

     文件        180  2019-04-13 17:06  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.Form1.resources

     文件      42496  2019-04-14 21:38  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.pdb

     文件        180  2019-04-13 17:06  DatasToExcel\DatasToExcel\obj\x86\Debug\DatasToExcel.Properties.Resources.resources

     文件       5420  2019-04-13 14:40  DatasToExcel\DatasToExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

     文件       6889  2019-04-14 21:38  DatasToExcel\DatasToExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件        493  2019-04-08 20:16  DatasToExcel\DatasToExcel\Program.cs

     文件       1356  2019-04-08 20:16  DatasToExcel\DatasToExcel\Properties\AssemblyInfo.cs

     文件       2876  2019-04-08 20:16  DatasToExcel\DatasToExcel\Properties\Resources.Designer.cs

     文件       5612  2019-04-08 20:16  DatasToExcel\DatasToExcel\Properties\Resources.resx

     文件       1099  2019-04-08 20:16  DatasToExcel\DatasToExcel\Properties\Settings.Designer.cs

     文件        249  2019-04-08 20:16  DatasToExcel\DatasToExcel\Properties\Settings.settings

     文件        878  2019-04-08 20:16  DatasToExcel\DatasToExcel.sln

............此处省略14个文件信息