Click here to Skip to main content
14,699,740 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hello all,


I have a question, how we could upload excel file to web server in c#.
After that, we make window service that copy excel data into table sql database, the excel data were copied to sql table after pass validation such as data cannot copied if there is any existing data in that field (duplicate data). and this windows service will run every one minute. .

how I can make this code?
please help me,

thank you very much
Posted

1 solution

Refer this

http://msdn.microsoft.com/en-us/library/aa479405.aspx[^]

Use FileSystemWatcher in your Windows Service and write logic to read excel file and dump rows into database.

http://msdn.microsoft.com/en-us/library/system.io.filesystemwatcher.aspx[^]

PS: Code is not free. One has to learn how to code :)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900