C#实现excel文档中数据导入(mysql、sql)

上传者: sinat_40751643 | 上传时间: 2021-08-03 20:39:29 | 文件大小: 297KB | 文件类型: ZIP
利用window窗体程序,把excel文件放入到datagridview控件中,然后foreach插入表中

文件下载

资源详情

[{"title":"( 36 个子文件 297KB ) C#实现excel文档中数据导入(mysql、sql)","children":[{"title":"aboutdata","children":[{"title":"aboutdata.sln <span style='color:#111;'> 996B </span>","children":null,"spread":false},{"title":"aboutdata.v12.suo <span style='color:#111;'> 14.50KB </span>","children":null,"spread":false},{"title":"MySql.Data.dll <span style='color:#111;'> 288.00KB </span>","children":null,"spread":false},{"title":"aboutdata","children":[{"title":"bin","children":[{"title":"Release","children":null,"spread":false},{"title":"Debug","children":[{"title":"aboutdata.vshost.exe.config <span style='color:#111;'> 357B </span>","children":null,"spread":false},{"title":"MySql.Data.dll <span style='color:#111;'> 288.00KB </span>","children":null,"spread":false},{"title":"aboutdata.exe.config <span style='color:#111;'> 357B </span>","children":null,"spread":false},{"title":"aboutdata.pdb <span style='color:#111;'> 27.50KB </span>","children":null,"spread":false},{"title":"aboutdata.exe <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false},{"title":"aboutdata.vshost.exe <span style='color:#111;'> 23.66KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"MyDBHelp.cs <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"Form1.Designer.cs <span style='color:#111;'> 4.63KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 521B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"aboutdata.csproj.FileListAbsolute.txt <span style='color:#111;'> 577B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"aboutdata.csproj.GenerateResource.Cache <span style='color:#111;'> 977B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 6.91KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 865B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"aboutdata.pdb <span style='color:#111;'> 27.50KB </span>","children":null,"spread":false},{"title":"aboutdata.exe <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"aboutdata.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"aboutdata.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"DBHelper.cs <span style='color:#111;'> 610B </span>","children":null,"spread":false},{"title":"Form1.cs <span style='color:#111;'> 8.63KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.88KB </span>","children":null,"spread":false},{"title":"aboutdata.csproj <span style='color:#111;'> 3.95KB </span>","children":null,"spread":false},{"title":"App.config <span style='color:#111;'> 357B </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.07KB </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.80KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"数据导入格式.xls <span style='color:#111;'> 52.50KB </span>","children":null,"spread":false},{"title":"test(这个是mysql格式).sql <span style='color:#111;'> 1009B </span>","children":null,"spread":false},{"title":"使用说明.txt <span style='color:#111;'> 614B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

免责申明

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