資源簡介
為了完善excel導(dǎo)入數(shù)據(jù)庫問題大數(shù)據(jù)多sheet表,自動設(shè)置對應(yīng)字段
代碼片段和文件信息
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?構(gòu)造函數(shù)
????????///?
????????///?構(gòu)造函數(shù)
????????///?
????????///?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個文件信息
- 上一篇:三層架構(gòu)酒店管理系統(tǒng)
- 下一篇:一個xm
l文件操作類
評論
共有 條評論