ASP.NET Membership Website with custom user import and lookup table

See more:

C#

ASP.NET

SQL-Server

WebForms

, +

Hi Guys,

I'm looking to start a new ASP.Net C# 4.0 web project with ASP.Net membership.

I however have a twist to the project that I would like some advice / guidance on.

Let’s say I have the personal details of 3000 users in an excel sheet, before I start the project. The personal details include Designation, Name, Surname, sex, identity number (social security number), employee number, Position, Division, Department, e-mail address, telephone numbers etc.

Bearing in mind that I would like to make use of ASP.Net membership, I would like to import these details from excel into a SQL Table called "User_Lookup".


Now, instead of using the Default ASP.Net user/member "register" method, i would like to add a custom one that does the following:

My registration page would be a page where the user is asked to provide their Surname, I.D Number and Employee Number, which will be linked to the "User_Lookup Table". The user can then click on a next "button". If this request validates, the user will then be redirected to a "Register Page" where the majority of the fields on the registration page will be pre-populated with the corresponding details of the "User_Lookup Table". All details will be there, and the user will just have to choose their own password. When the user clicks on Register, a user will be created by default ASP.Net Membership, which includes GUID, HASH Value, Salt etc.

Has anyone done this before, and willing to give advice?

If yes, can you please point me in the direction of such a sample / tutorial, or just walk me through the process.

Thanks and Regards,

Wynand Vermaak