如何上传excel文件 [英] how to upload excel file

问题描述

假设我在该文件中有excel文件，并且有国家和城市.我想同时将这些国家和城市存储到sql server 2005中..帮助我吗?

suppose i have excel file in that file i have country and city.i want to store those country and city into sql server 2005 at the same time..help me?

推荐答案

C#

从Excel读取数据

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138 [ ^ ]

保存数据

http://www.daniweb.com/software-development/csharp/threads/224348/how-to-insert-data-in-database-using-dataset-in-c-windows-application [

C#

Read data from Excel

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138[^]

Save data

http://www.daniweb.com/software-development/csharp/threads/224348/how-to-insert-data-in-database-using-dataset-in-c-windows-application[^]

这篇关于如何上传excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！