Click here to Skip to main content
14,667,847 members
Rate this:
Please Sign up or sign in to vote.
See more:
Creating windows service for bulk upload through excel in asp.net c#

Please give me solution.
Posted
Updated 16-Jun-15 22:32pm
v2
Comments
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100