using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.OleDb;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;

namespace?WindowsApplication1
{
????public?partial?class?Form1?:?Form
????{
????????public?DataSet?ds?=?new?DataSet（）;
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

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

????????///?將Excel表格中的數據轉換為可編輯的存放在內存當中的DataSet對象
????????///?

????????///?需要導入的Excel表格存放的絕對路徑
????????///?需要導入的Excel表格中的Sheet名稱
????????///?轉換結束的DataSet對象
????????public?DataSet?ExcelDataSource（string?filepath?string?sheetname）
????????{
????????????string?strConn;
????????????strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?filepath?+?“;Extended?Properties=Excel?8.0;“;
????????????OleDbConnection?conn?=?new?OleDbConnection（strConn）;
????????????OleDbDataAdapter?oada?=?new?OleDbDataAdapter（“select?*?from?[“?+?sheetname?+?“$]“?strConn）;
????????????DataSet?ds?=?new?DataSet（）;
????????????oada.Fill（ds）;
????????????return?ds;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????this.openFileDialog1.DefaultExt?=?“*.xls“;
????????????this.openFileDialog1.ShowDialog（）;
????????????this.textBox1.Text?=?this.openFileDialog1.FileName;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????ds?=?ExcelDataSource（this.textBox1.Text?“Sheet1“）;

????????????this.dataGridView1.DataSource?=?ds;
????????????this.dataGridView1.DataMember?=?“Table“;
????????}

????????//?該按鈕下實現了如何將數據批量添加到數據庫的對應表中
????????private?void?button3_Click（object?sender?EventArgs?e）
????????{
????????????//SqlConnection?sc?=?new?SqlConnection（“Server=（local）;uid=nan;pwd=sa;database=PDSSC“）;
????????????string?connectionString?=?“Data?Source=（local）;Initial?Catalog=pdssc;user?id=nan;password=nan“;
????????????SqlConnection?sc?=?new?SqlConnection（connectionString）;
????????????sc.Open（）;
????????????//聲明?SqlBulkCopy對象
????????????//沒有這個對象，批量導入就沒戲
????????????SqlBulkCopy?sbc?=?new?SqlBulkCopy（sc）;
????????????sbc.DestinationTableName?=?“Test“;

????????????//sbc.ColumnMappings.Add（ds.Tables[0].Columns[0].ColumnName?0）;
????????????//sbc.ColumnMappings.Add（ds.Tables[0].Columns[1].ColumnName?1）;
????????????//sbc.ColumnMappings.Add（ds.Tables[0].Columns[2].ColumnName?2）;

????????????//?列映射
????????????for?（int?q?=?0;?q?????????????{
????????????????sbc.ColumnMappings.Add（ds.Tables[0].Columns[q].ColumnNameq）;
????????????}

????????????try
????????????{
????????????????sbc.WriteToServer（ds.Tables[0]）;
????????????????MessageBox.Show（“導入完成。“）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????

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

?????目錄??????????0??2008-12-31?15:26??批量導入數據

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1

?????文件????????947??2008-11-21?13:24??批量導入數據\WindowsApplication1\WindowsApplication1.sln

????..A..H.?????13312??2008-11-21?13:29??批量導入數據\WindowsApplication1\WindowsApplication1.suo

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1

?????文件????????478??2008-11-13?12:51??批量導入數據\WindowsApplication1\WindowsApplication1\Program.cs

?????文件???????3453??2008-11-21?13:24??批量導入數據\WindowsApplication1\WindowsApplication1\WindowsApplication1.csproj

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1\bin

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1\bin\Debug

?????文件??????14328??2008-12-23?15:51??批量導入數據\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.vshost.exe

?????文件????????490??2007-07-21?01:33??批量導入數據\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.vshost.exe.manifest

?????文件??????11264??2008-12-23?15:50??批量導入數據\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.exe

?????文件??????28160??2008-12-23?15:50??批量導入數據\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.pdb

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1\obj

?????文件????????992??2008-11-13?17:55??批量導入數據\WindowsApplication1\WindowsApplication1\obj\WindowsApplication1.csproj.FileListAbsolute.txt

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\TempPE

?????文件???????4608??2008-12-23?15:46??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件????????180??2008-12-23?15:46??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\WindowsApplication1.Form1.resources

?????文件????????180??2008-11-21?13:24??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\WindowsApplication1.Properties.Resources.resources

?????文件??????28160??2008-12-23?15:50??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\WindowsApplication1.pdb

?????文件??????11264??2008-12-23?15:50??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\WindowsApplication1.exe

?????文件????????976??2008-12-23?15:51??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\WindowsApplication1.csproj.FileListAbsolute.txt

?????文件????????847??2008-12-23?15:46??批量導入數據\WindowsApplication1\WindowsApplication1\obj\Debug\WindowsApplication1.csproj.GenerateResource.Cache

?????目錄??????????0??2008-11-21?13:06??批量導入數據\WindowsApplication1\WindowsApplication1\Properties

?????文件???????1194??2008-11-13?12:51??批量導入數據\WindowsApplication1\WindowsApplication1\Properties\AssemblyInfo.cs

?????文件???????2862??2008-11-21?13:24??批量導入數據\WindowsApplication1\WindowsApplication1\Properties\Resources.Designer.cs

?????文件???????5350??2008-11-13?12:51??批量導入數據\WindowsApplication1\WindowsApplication1\Properties\Resources.resx

?????文件???????1117??2008-11-21?13:24??批量導入數據\WindowsApplication1\WindowsApplication1\Properties\Settings.Designer.cs

?????文件????????249??2008-11-13?12:50??批量導入數據\WindowsApplication1\WindowsApplication1\Properties\Settings.settings

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