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）;
????????}
????????#endregion

????????#region?窗體加載
????????void?Frm_ReadExcel_Load（object?sender?EventArgs?e）
????????{
????????????Init（）;
????????????EventHand（）;
????????}
????????#endregion

????????#region?初始化
????????void?Init（）
????????{
????????????conn?=?new?SqlConnection（connstr）;//SqlConnection實例化
????????????MaximizeBox?=?false;//禁用最小化
????????????MaximumSize?=?MinimumSize?=?Size;//固定當前大小
????????????txt_filepath.ReadOnly?=?true;
????????????com_databasename.DropDownstyle?=?com_tablename.DropDownstyle?=?ComboBoxstyle.DropDownList;//下拉框只可選
????????????try
????????????{
????????????????conn.Open（）;
????????????????using?（SqlCommand?cmd?=?conn.CreateCommand（））
????????????????{
????????????????????cmd.CommandText?=?@“select?name?from?sysdatabases“;
????????????????????SqlDataReader?reader?=?cmd.ExecuteReader（）;//獲取所有數據庫
????????????????????while?（reader.Read（））?com_databasename.Items.Add（reader[0].ToString（））;
????????????????????if?（com_databasename.Items.Count?>?0）?com_databasename.SelectedIndex?=?0;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{?MessageBox.Show（ex.Message）;?}
????????????finally
????????????{?conn.Close（）;?}
????????}
????????#endregion

????????#region?控件事件掛接
????????void?EventHand（）
????????{
????????????com_databasename.SelectedIndexChanged?+=?new?EventHandler（com_databasename_SelectedIndexChanged）;
????????????bt_see.Click?+=?new?EventHandler（bt_see_Click）;
????????????bt_next.Click?+=?new?EventHandler（btn_next_Click）;
????????????bt_SetColumns.Click?+=?new?EventHandler（bt_SetColumns_Click）;
????????????bt_ok.Click?+=?new?EventHandler（bt_ok_Click）;
????????????bt_instruction.Click?+=?new?EventHandler（bt_instruction_Click）;
????????????dgv_show.DataError?+=?new?DataGridViewDataErrorEventHandler（dgv_show_DataError）;
????????????FormClosing?+=?new?FormClosingEventHandler（Frm_ReadExcel_FormClosing）;
????????}
????????#endregion

????????#region?控件事件響應
????????#region?修改數據庫
????????///?

????????///?修改數據庫
????????///?

????????///?
????????///?
????????void?com_databasename_SelectedIndex

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????29696??2014-10-28?14:17??Excel大量數據快速導入數據庫\bin\Debug\Winform_SqlBulkCopy.exe

?????文件??????52736??2014-10-28?14:17??Excel大量數據快速導入數據庫\bin\Debug\Winform_SqlBulkCopy.pdb

?????文件??????11600??2014-10-29?10:35??Excel大量數據快速導入數據庫\bin\Debug\Winform_SqlBulkCopy.vshost.exe

?????文件????????490??2012-06-02?22:34??Excel大量數據快速導入數據庫\bin\Debug\Winform_SqlBulkCopy.vshost.exe.manifest

?????文件??????12458??2014-10-27?14:44??Excel大量數據快速導入數據庫\Frm_ReadExcel.cs

?????文件???????8955??2014-10-27?14:04??Excel大量數據快速導入數據庫\Frm_ReadExcel.Designer.cs

?????文件???????5817??2014-10-27?14:04??Excel大量數據快速導入數據庫\Frm_ReadExcel.resx

?????文件???????7933??2014-10-28?14:17??Excel大量數據快速導入數據庫\Frm_SetColumns.cs

?????文件???????9823??2014-10-28?14:14??Excel大量數據快速導入數據庫\Frm_SetColumns.Designer.cs

?????文件???????5817??2014-10-28?14:14??Excel大量數據快速導入數據庫\Frm_SetColumns.resx

?????文件???????5105??2014-10-27?13:56??Excel大量數據快速導入數據庫\Frm_SetServer.cs

?????文件???????8669??2014-10-27?13:38??Excel大量數據快速導入數據庫\Frm_SetServer.Designer.cs

?????文件???????5817??2014-10-24?13:47??Excel大量數據快速導入數據庫\Frm_SetServer.resx

?????文件???????7473??2014-10-08?17:29??Excel大量數據快速導入數據庫\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6483??2014-10-29?10:35??Excel大量數據快速導入數據庫\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????658??2014-10-28?14:15??Excel大量數據快速導入數據庫\obj\x86\Debug\GenerateResource.read.1.tlog

?????文件???????1606??2014-10-28?14:15??Excel大量數據快速導入數據庫\obj\x86\Debug\GenerateResource.write.1.tlog

?????文件???????4608??2014-10-27?13:37??Excel大量數據快速導入數據庫\obj\x86\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件???????4679??2014-10-27?13:37??Excel大量數據快速導入數據庫\obj\x86\Debug\WindowsFormsApplication3.csproj.FileListAbsolute.txt

?????文件??????27648??2014-10-27?13:33??Excel大量數據快速導入數據庫\obj\x86\Debug\WindowsFormsApplication3.exe

?????文件??????54784??2014-10-27?13:33??Excel大量數據快速導入數據庫\obj\x86\Debug\WindowsFormsApplication3.pdb

?????文件????????180??2014-10-24?13:45??Excel大量數據快速導入數據庫\obj\x86\Debug\WindowsFormsApplication3.Properties.Resources.resources

?????文件???????3374??2014-10-29?10:35??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.csproj.FileListAbsolute.txt

?????文件??????29696??2014-10-28?14:17??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.exe

?????文件????????180??2014-10-27?14:37??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.Frm_ReadExcel.resources

?????文件????????180??2014-10-28?14:15??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.Frm_SetColumns.resources

?????文件????????180??2014-10-27?14:37??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.Frm_SetServer.resources

?????文件??????52736??2014-10-28?14:17??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.pdb

?????文件????????180??2014-10-27?14:37??Excel大量數據快速導入數據庫\obj\x86\Debug\Winform_SqlBulkCopy.Properties.Resources.resources

?????文件????????508??2014-10-27?13:38??Excel大量數據快速導入數據庫\Program.cs

............此處省略20個文件信息