从Excel工作表将数据添加到SQL Server [英] adding data into sql server from an excel sheet

问题描述

你好朋友，
我正在从事.net项目.我需要从excel工作表将数据添加到sql服务器表中，该用户将使用文件上载器控件进行上传.在该excel工作表中还存在一个下拉列表.
我的问题是我不知道如何使用文件上载器完成此操作，我也不知道如何处理excel表格的清单.请大家帮帮我.谢谢预先的朋友.

Hello friends ,
I am working on a .net project . where i need to add data to a sql server table from an excel sheet , that user will upload using file uploader control.In that excel sheet there is dropdownlists also .
my problem is i don''t know how to done it using file uploader and i have no idea how to handle drodownlist of excel sheet.Can you guys please help me .Thanks in advance friends.

推荐答案

如果您正在寻找代码参考，请参见以下博客:

http://insqlserver.com/content/how-import- ms-excel-data-sql-server-table-using-cnet [ http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx [ ^ ]

Here is a blog if you are looking for code reference:

http://insqlserver.com/content/how-import-ms-excel-data-sql-server-table-using-cnet[^]

http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx[^]

这篇关于从Excel工作表将数据添加到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！