Click here to Skip to main content
14,766,249 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Creating windows service for bulk upload through excel in c#

Please give me solution.
Updated 16-Jun-15 23:32pm
Suvendu Shekhar Giri 17-Jun-15 4:41am
You want us to create a complete project for you?
Have you tried anything?
Suvendu Shekhar Giri 17-Jun-15 5:06am
What DBMS are you using?
Jitendra Ballia 17-Jun-15 6:45am
sql SERVER 2008
sumit_2095 19-Jun-15 0:42am
I can share a design approach for this problem statement.
1) Create a Table say ExcelImportFiles, in Database to store the Excel file as varbinary object, with a flag as Uploaded.
2) Create a Windows Service with a permissible value for thread sleep to get a looping behavior. In service, write code to read the file from the ExcelImportFiles Table and create a excel file. Then read the Excel Data in a DataTable or any DTO object. And then once you have performed the required validations if any, update the data in your Database either using a SQL Command, EF, or any other ORM.

Basically you should create a queue to process your excel files, this would be an extra over head for you. But if you are using SQL Server Database, then you can use SQL Server Broker Queue for the queue logic and focus on the Excel Import feature.

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