ASP.NET Profile provider custom fields

I'm sorry, I don't have time to make a full code sample.  Deadlines are looming.

Here's a good link about Membership:  http://msdn.microsoft.com/en-us/library/ff648345.aspx

Normally, when you want to create a new user, you write code like this:

Membership.CreateUser("UserName", "P@ssw0rd", "my@emailAddress");

The Membership provider class creates a user in the Membership database.  This is a rather complicated database with a lot of complicated stored procedures.  So you don't want to modify any of it.  Instead, you will make your own additional tables to store your own data.  You can put these in the Membership database, or in your own database.  Either way is fine.  In your case, you might have one table to list all departments (columns:  departmentID, departmentName) and another table to store department assignments (columns:  username, departmentID).

Now, instead of simply calling Membership.CreateUser, you create your own class, VishanMembership.  It has a method like this:

public void CreateUser(string userName, string password, string email, List departmentIDs)

Inside this method, you will

(1)  Start a database transaction.

(2)  Save your deparment assignments.

(3)  Call Membership.CreateUser(userName, password, email).  This call may fail for a number of reasons.  For example, the username or email may be invalid.

(4)  If Membership.CreateUser succeeded, you commit your database transaction, and you're done.  If not, you roll back your database transaction and send an error message.

Now you also need to add other methods to VishanMembership to update and delete users.  In each case, the method will update or delete the department assignments and also call the Membership class to update or delete the user data.

It's a lot to absorb for a new developer.  Let me know if it makes sense.