Excel大量数据快速导入数据库源码

为了完善excel导入数据库问题大数据多sheet表，自动设置对应字段

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace Winform_SqlBulkCopy
{
    public partial class Frm_ReadExcel : Form
    {
        #region 全局变量
        DataSet ds;
        string[] tablenames;
        SqlConnection conn;
        string connstr;
        List SqlBulkCopyparameters;
        #endregion

        #region 构造函数
        /// 

        /// 构造函数
        /// 

        /// sqlserver连接字符串
        public Frm_ReadExcel（string _connstr）
        {
            connstr = _connstr;
            InitializeComponent（）;
            Load += new EventHandler（Frm_ReadExcel_Load）;
        }

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件        8955  2014-10-27 14:04  Frm_ReadExcel.Designer.cs
     文件       12458  2014-10-27 14:44  Frm_ReadExcel.cs
     文件        5817  2014-10-27 14:04  Frm_ReadExcel.resx
     文件        9823  2014-10-28 14:14  Frm_SetColumns.Designer.cs
     文件        7933  2014-10-28 14:17  Frm_SetColumns.cs
     文件        5817  2014-10-28 14:14  Frm_SetColumns.resx
     文件        8669  2014-10-27 13:38  Frm_SetServer.Designer.cs
     文件        5105  2014-10-27 13:56  Frm_SetServer.cs
     文件        5817  2014-10-24 13:47  Frm_SetServer.resx
     文件         508  2014-10-27 13:38  Program.cs
     目录           0  2014-10-29 10:19  Properties\
     文件        1480  2014-10-29 10:37  Properties\AssemblyInfo.cs
     文件        2877  2014-10-27 13:37  Properties\Resources.Designer.cs
     文件        5612  2012-11-02 15:02  Properties\Resources.resx
     文件        1118  2014-10-27 13:37  Properties\Settings.Designer.cs
     文件         249  2012-11-02 15:02  Properties\Settings.settings
     文件        4467  2014-10-27 13:37  Winform_SqlBulkCopy.csproj
     文件         879  2014-10-29 10:39  Winform_SqlBulkCopy.sln
     目录           0  2014-10-29 10:19  bin\
     目录           0  2014-10-29 10:19  bin\Debug\
     文件       29696  2014-10-28 14:17  bin\Debug\Winform_SqlBulkCopy.exe
     文件       52736  2014-10-28 14:17  bin\Debug\Winform_SqlBulkCopy.pdb
     文件       11600  2014-10-29 10:35  bin\Debug\Winform_SqlBulkCopy.vshost.exe
     文件         490  2012-06-02 22:34  bin\Debug\Winform_SqlBulkCopy.vshost.exe.manifest
     目录           0  2014-10-29 10:45  bin\Release\
     目录           0  2014-10-29 10:19  obj\
     目录           0  2014-10-29 10:19  obj\x86\
     目录           0  2014-10-29 10:19  obj\x86\Debug\
     文件        7473  2014-10-08 17:29  obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
     文件        6483  2014-10-29 10:35  obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
     文件         658  2014-10-28 14:15  obj\x86\Debug\GenerateResource.read.1.tlog
............此处省略14个文件信息