C# 实时读取EXCEL到SQL数据库

实时读取EXCEL到SQL，即:将excel数据导入到sql server 数据库

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Runtime.InteropServices;

namespace RealTimeExcelToSql
{
    public partial class Frm_Main : Form
    {
        public Frm_Main（）
        {
            InitializeComponent（）;
        }
        #region 为INI文件中指定的节点取得字符串
        /// 

        /// 为INI文件中指定的节点取得字符串
        /// 

        /// 欲在其中查找关键字的节点名称
        /// 欲获取的项名
        /// 指定的项没有找到时返回的默认值
        /// 指定一个字串缓冲区，长度至少为

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

     文件      18944  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\bin\Debug\RealTimeExcelToSql.exe

     文件      44544  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\bin\Debug\RealTimeExcelToSql.pdb

     文件      14328  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql\bin\Debug\RealTimeExcelToSql.vshost.exe

     文件        490  2009-06-11 05:14  实时读取ExcelToSql\RealTimeExcelToSql\bin\Debug\RealTimeExcelToSql.vshost.exe.manifest

     文件        133  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\bin\Debug\Set.ini

     文件      16019  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\Frm_Main.cs

     文件      13318  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\Frm_Main.designer.cs

     文件       6212  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\Frm_Main.resx

     文件       3492  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\RealTimeExcelToSql.csproj.FileListAbsolute.txt

     文件        850  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\RealTimeExcelToSql.csproj.GenerateResource.Cache

     文件      18944  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\RealTimeExcelToSql.exe

     文件        180  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\RealTimeExcelToSql.Frm_Main.resources

     文件      44544  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\RealTimeExcelToSql.pdb

     文件        180  2015-12-24 08:47  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\RealTimeExcelToSql.Properties.Resources.resources

     文件        143  2015-12-24 21:43  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\Set.ini

     文件        502  2010-06-12 13:39  实时读取ExcelToSql\RealTimeExcelToSql\Program.cs

     文件       1368  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql\Properties\AssemblyInfo.cs

     文件       2886  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql\Properties\Resources.Designer.cs

     文件       5612  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql\Properties\Resources.resx

     文件       1103  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql\Properties\Settings.Designer.cs

     文件        249  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql\Properties\Settings.settings

     文件       3851  2010-11-03 16:51  实时读取ExcelToSql\RealTimeExcelToSql\RealTimeExcelToSql.csproj

     文件        944  2010-06-12 13:38  实时读取ExcelToSql\RealTimeExcelToSql.sln

    ..A..H.     21504  2015-12-24 08:55  实时读取ExcelToSql\RealTimeExcelToSql.suo

     目录          0  2010-11-09 15:02  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\Refactor

     目录          0  2010-11-09 15:02  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug\TempPE

     目录          0  2014-03-27 10:08  实时读取ExcelToSql\RealTimeExcelToSql\bin\Debug

     目录          0  2015-12-24 21:43  实时读取ExcelToSql\RealTimeExcelToSql\obj\Debug

     目录          0  2014-03-27 10:06  实时读取ExcelToSql\RealTimeExcelToSql\bin

     目录          0  2014-03-27 10:06  实时读取ExcelToSql\RealTimeExcelToSql\obj

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