C# 通过存储过程将Excel文档导入SQL Server数据库

上传者: suenjoe | 上传时间: 2019-12-21 21:10:44 | 文件大小: 49KB | 文件类型: zip
以Excel表格形式导入到数据库,为此写了一个这样一个测试程序,当然,里面导入的Excel表格的字段、表名都可以自定义的,过程比较简单,主要用到了Sql Server和Excel的接口类库

文件下载

资源详情

[{"title":"( 26 个子文件 49KB ) C# 通过存储过程将Excel文档导入SQL Server数据库","children":[{"title":"ExcelToSqlserver","children":[{"title":"ExcelToSqlserver.suo <span style='color:#111;'> 16.00KB </span>","children":null,"spread":false},{"title":"ExcelToSqlserver","children":[{"title":"bin","children":[{"title":"Debug","children":[{"title":"ExcelToSqlserver.exe <span style='color:#111;'> 11.50KB </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.pdb <span style='color:#111;'> 31.50KB </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.vshost.exe <span style='color:#111;'> 13.99KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Form1.Designer.cs <span style='color:#111;'> 4.47KB </span>","children":null,"spread":false},{"title":"Form2.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 497B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExcelToSqlserver.csproj.GenerateResource.Cache <span style='color:#111;'> 905B </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.exe <span style='color:#111;'> 11.50KB </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.15KB </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.Form2.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExcelToSqlserver.pdb <span style='color:#111;'> 31.50KB </span>","children":null,"spread":false},{"title":"Refactor","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Form2.cs <span style='color:#111;'> 366B </span>","children":null,"spread":false},{"title":"Form1.cs <span style='color:#111;'> 4.05KB </span>","children":null,"spread":false},{"title":"ExcelToSqlserver.csproj <span style='color:#111;'> 3.95KB </span>","children":null,"spread":false},{"title":"Form2.Designer.cs <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.88KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"Resources.resx <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false},{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.81KB </span>","children":null,"spread":false}],"spread":true}],"spread":false},{"title":"ExcelToSqlserver.sln <span style='color:#111;'> 938B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • qq_22425635 :
    稍微改改就可以使用了
    2018-01-04
  • 一位统计 :
    非常好,帮助我实现了我需要的功能。
    2017-04-05
  • afa315 :
    我的2012版本的打不开
    2014-08-25
  • 牡丹001 :
    能够实现 可以借鉴
    2014-01-27
  • 泛用人形代码复制机 :
    局限性比较大 我改用npoi了.
    2013-12-20

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明