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

namespace?ToExcel
{
????public?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;

????????///?

????????///?構(gòu)造函數(shù)
????????///?

????????public?AccessHelper（string?path）
????????{
????????????conn_str?=?string.Format（@“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=‘{0}‘“path）;
????????????InitDB（）;
????????}

????????private?void?InitDB（）
????????{
????????????ole_connection?=?new?OleDbConnection（conn_str）;//創(chuàng)建實(shí)例
????????????ole_command?=?new?OleDbCommand（）;
????????}

????????///?

????????///?轉(zhuǎn)換數(shù)據(jù)格式
????????///?

????????///數(shù)據(jù)源
????????///?數(shù)據(jù)列表
????????private?DataTable?ConvertOleDbReaderToDataTable（ref?OleDbDataReader?reader）
????????{
????????????DataTable?dt_tmp?=?null;
????????????DataRow?dr?=?null;
????????????int?data_column_count?=?0;
????????????int?i?=?0;

????????????data_column_count?=?reader.FieldCount;
????????????dt_tmp?=?BuildAndInitDataTable（data_column_count）;

????????????if?（dt_tmp?==?null）
????????????{
????????????????return?null;
????????????}

????????????while?（reader.Read（））
????????????{
????????????????dr?=?dt_tmp.NewRow（）;

????????????????for?（i?=?0;?i?????????????????{
????????????????????dr[i]?=?reader[i];
????????????????}

????????????????dt_tmp.Rows.Add（dr）;
????????????}

????????????return?dt_tmp;
????????}

????????///?

????????///?創(chuàng)建并初始化數(shù)據(jù)列表
????????///?

????????///列的個(gè)數(shù)
????????///?數(shù)據(jù)列表
????????private?DataTable?BuildAndInitDataTable（int?Field_Count）
????????{
????????????DataTable?dt_tmp?=?null;
????????????DataColumn?dc?=?null;
????????????int?i?=?0;

????????????if?（Field_Count?<=?0）
????????????{
????????????????return?null;
????????????}

????????????dt_tmp?=?new?DataTable（）;

????????????for?（i?=?0;?i?????????????{
????????????????dc?=?new?DataColumn（i.ToString（））;
????????????????dt_tmp.Columns.Add（dc）;
????????????}

????????????return?dt_tmp;
????????}

????????///?

????????///?從數(shù)據(jù)庫(kù)里面獲取數(shù)據(jù)
????????///?

????????///查詢語(yǔ)句
????????///?數(shù)據(jù)列表
????????public?DataTable?GetDataTableFromDB（string?strSql）
????????{
????????????if?（conn_str?==?null）
????????????{
????????????????return?null;
????????????}

????????????try
????????????{
????????????????ole_connection.Open（）;//打開(kāi)連接

????????????????if?（ole_connection.State?==?ConnectionState.Closed）
????????????????{
????????????????????return?null;
???????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-23?12:34??ToExcel\
?????目錄???????????0??2018-06-23?12:34??ToExcel\code\
?????目錄???????????0??2018-06-23?12:34??ToExcel\code\ToExcel\
?????目錄???????????0??2018-06-23?12:34??ToExcel\code\ToExcel\ToExcel\
?????文件????????5808??2018-06-23?11:39??ToExcel\code\ToExcel\ToExcel\AccessHelper.cs
?????文件?????????157??2018-06-12?10:31??ToExcel\code\ToExcel\ToExcel\App.config
?????文件????????2323??2018-06-12?15:55??ToExcel\code\ToExcel\ToExcel\CommonData.cs
?????文件????????7453??2018-06-23?11:41??ToExcel\code\ToExcel\ToExcel\DataProcessCenter.cs
?????文件????????3940??2018-06-23?12:27??ToExcel\code\ToExcel\ToExcel\DbProcess.cs
?????文件????????5281??2018-06-12?16:44??ToExcel\code\ToExcel\ToExcel\Form1.Designer.cs
?????文件????????3871??2018-06-23?12:31??ToExcel\code\ToExcel\ToExcel\Form1.cs
?????文件????????5817??2018-06-12?16:44??ToExcel\code\ToExcel\ToExcel\Form1.resx
?????目錄???????????0??2018-06-23?12:34??ToExcel\code\ToExcel\ToExcel\Model\
?????文件?????????818??2018-06-12?15:42??ToExcel\code\ToExcel\ToExcel\Model\PipeLine.cs
?????文件?????????492??2018-06-12?10:32??ToExcel\code\ToExcel\ToExcel\Model\PipePoint.cs
?????文件????????1500??2018-06-12?15:45??ToExcel\code\ToExcel\ToExcel\Model\Targetobject.cs
?????文件?????????488??2018-06-12?10:32??ToExcel\code\ToExcel\ToExcel\Program.cs
?????目錄???????????0??2018-06-23?12:34??ToExcel\code\ToExcel\ToExcel\Properties\
?????文件????????1338??2018-06-11?16:10??ToExcel\code\ToExcel\ToExcel\Properties\AssemblyInfo.cs
?????文件????????2854??2018-06-12?10:31??ToExcel\code\ToExcel\ToExcel\Properties\Resources.Designer.cs
?????文件????????5612??2018-06-11?16:10??ToExcel\code\ToExcel\ToExcel\Properties\Resources.resx
?????文件????????1107??2018-06-12?10:31??ToExcel\code\ToExcel\ToExcel\Properties\Settings.Designer.cs
?????文件?????????249??2018-06-11?16:10??ToExcel\code\ToExcel\ToExcel\Properties\Settings.settings
?????文件???????17621??2018-06-12?16:16??ToExcel\code\ToExcel\ToExcel\ToExcel.cs
?????文件????????4512??2018-06-23?11:42??ToExcel\code\ToExcel\ToExcel\ToExcel.csproj
?????目錄???????????0??2018-06-23?12:34??ToExcel\code\ToExcel\ToExcel\bin\
?????目錄???????????0??2018-07-09?14:55??ToExcel\code\ToExcel\ToExcel\bin\Debug\
?????文件?????7782912??2016-05-05?08:48??ToExcel\code\ToExcel\ToExcel\bin\Debug\Aspose.Cells.dll
?????文件???????32256??2018-06-23?12:31??ToExcel\code\ToExcel\ToExcel\bin\Debug\ToExcel.exe
?????文件?????????157??2018-06-12?10:31??ToExcel\code\ToExcel\ToExcel\bin\Debug\ToExcel.exe.config
?????文件???????56832??2018-06-23?12:31??ToExcel\code\ToExcel\ToExcel\bin\Debug\ToExcel.pdb
............此處省略26個(gè)文件信息