首页 开发技术 C#     /    C#通过存储过程将Excel文档导入SQLServer数据库

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

上传者: suenjoe | 上传时间:2018/10/16 19:53:48 | 文件大小:49KB | 文件类型:zip
C#通过存储过程将Excel文档导入SQLServer数据库
以Excel表格方式导入到数据库,为此写了一个这样一个测试程序,当然,里面导入的Excel表格的字段、表名都可以自定义的,过程比较简单,主要用到了SqlServer和Excel的接口类库

文件下载

资源详情

[{"title":"(26个子文件49KB)C#通过存储过程将Excel文档导入SQLServer数据库","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小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【好快吧下载】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【好快吧下载】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,8686821#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明