how can retrive data from excel sheet and save in database with help of Fileupload control

Posted by Bhuwan87rawat under ASP.NET on 9/3/2012 | Points: 10 | Views : 637 | Status : [Member] | Replies : 2
hello sir,
In my application i make a form cantain some one fileupload control and some textbox and one save button
i want to select a excelsheet and retrive some data like email_id,city,name from excelsheet and after that save in database
how is possible in asp.net...


Regard
Bhuwan




Responses

Posted by: Wadhwanisanju on: 9/6/2012 [Member] Starter | Points: 25

Up
0
Down
Hello,

The direct method is available in .NET to read data from Excel sheet and paste in sql server database

This is the exact thing that you are looking for.

http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html

Thanks and Happy coding!!!!!!!!!!!

Bhuwan87rawat, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saratvaddilli on: 9/6/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Please Go through this Link

http://www.dotnetfunda.com/forums/thread11343-how-can-retrive-data-from-excel-sheet-and-save-in-database-with-help-o.aspx


Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Bhuwan87rawat, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response