Hi,
I need a wizard tool to be developed in .Net C# as Windows App to import my excel data in database. There are several tools already available to do this. I would like the programmer to use http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx SQLBulkCopy tool in the above link.
But I need some modifications to it. That’s the reason I am posting this as a project here.
Project Requirements:
1. Windows Project will have just 1 form with a wizard control.
2. WizardPage1 will accept the excel sheet to import. (with a textbox, browse button)
3. WizardPage2 will display the available tables in Database where data could be imported (some tables of database should be excluded here). User will select one & click Next
4. WizardPage3 will check if the columns & datatypes match between the excel columns & database table columns. If not display a error of the specific column & allow user to make modifications offline in database & click a button refresh here to check it again.
5. Once everything is correct, user will click Next button
6. Check if data already exists in table. If yes, ask user if he would like to udpate record in excel with row in table (if PK matches).
7. WizardPage4 will display a grid table with tasks to perform & will mark it as complete as tasks completes. So this should be done very similar to SQLServerInstallationSteps grid.
8. WizardPage5 – completes the wizard.
You need to use Devexpress v10.1.5 (trial can be used. Url to download will be provided), VS 2008, SQLExpress2005 for this project.
Let me know if you have any questions.
After completion of this project, developer will be provided with more projects in future.
