CreateUserWizard (almost) Figured Out – Part 1

While developing an outward-facing portal web site for a client, I had need to use the ASP.NET CreateUserWizard (CUW) control in Visual Studio 2010 (it is essentially unchanged from previous versions).  This control really does make it easy to create new users.

This series of posts will demonstrate my hard-won lessons on how to make this control do your bidding.  This initial post will provide the overview of the problem and the design.  The next post will cover the .aspx page with the CUW control declaration.  The final installment will cover the code-behind.

But like so many other software objects extant (e.g. Windows and Office), the CUW is designed out of the box to give good demo, not perform real-world work.  If you adhere strictly to their paradigm of user name, e-mail address, password, etc., with no additions or subtractions, it is incredibly easy to create a valid, secure, persisted user with zero coding.  Drag and drop a control, and bang! It just works. 

You can test this yourself by dragging a CreateUserWizard control from the toolbox onto a web page, run it, and create a user. You can verify that the user was created by opening the WAT in Visual Studio to see the new username listed.

Of course, it is a bit disingenuous  to say “zero coding”. Although there is no coding required in either the .aspx or the .aspx.cs files, there is some effort required in web.config to set up the security database properly, unless you use the standard default security database.  I’m not going to go into that here, but will just assume you have that part already working.

In any event, real-world implementations are rarely so cut and dried.  Business requirements intrude. For example, perhaps you need to perform some other verification before allowing a person to create a new user account. 

In the case of my client’s portal, we had to first determine if the new user had a pre-existing account in the corporate database, and if yes, if she also had a ShortTermStatus of “Active”. (ShortTermStatusID is a foreign key field in our db, with a half dozen possible values.)  If so, she is allowed to create an account into the portal. If not, she is informed accordingly and turned away.

Furthermore, to help ensure that a person is who they say they are, we ask for First Name, Last Name, and Phone Number, along with the already required E-mail address.  Then we find the person with that E-mail address (this requires that the E-mail address be unique in the corporate database), and compare the names and phone number. If everything matches, we allow the new user. (The actual comparison was also not quite as simple as one might initially think.  For example, we allow the First Name entered here to match either the FirstName or NickName fields on record, and the phone number entered can match any of several phone numbers on record. )

So these requirements mean that a database lookup needs to be performed before the new user is created in the security database.  If she is not qualified, the new user is never created.  If she is qualified, her PersonID from the corporate db needs to be conveyed and stored in the security database, so that the user can later log into the portal and see her live data.

One more thing: we wanted the regular users, but not necessarily admin people, to use their e-mail address as their username. In fact, when logging in, they are not given the opportunity to enter an identifying field other than their e-mail address (and password, of course).  It was felt this would make it easier for the users to manage their accounts.

This all should be easy enough, but it turns out to be surprisingly tricky to get it all right. 

And I still don’t have it perfect:  I have not yet figured out how to explicitly declare the Create User and Cancel buttons.  This is both esthetic (I would like to reposition the buttons) and functional (I would like to set the Cancel button CausesValidation = false).  It should be solvable – I have just not yet found the proper steps or syntax to access the correct template.

Here a screen shot of the final product in IE8 (without any styling applied, for brevity of the example):

A few things on this page bear note. There is no field called UserName, although the CUW requires just such a field; there is no choice in that matter.  Next, the E-mail address is asked for twice, including a confirmation field.

This latter is actually a hack.  The first E-mail address text box is actually the UserName, as far as the CUW control knows, as you will see in the control declaration in CreateUser.aspx, seen in the next installment.  Its ID attribute is “UserName”, while the ID attribute of the Confirm E-mail textbox is “Email”.  The CUW control requires both of those fields, with those exact ID’s. (You can change the ID required, but it is not usually worth the effort.)

On the Admin page, where users in other roles can be created, the UI does ask for and recognizes a UserName as UserName.

Using the information presented here, we do a lookup into the corporate database, by calling a stored procedure which returns a PersonID if the person exists in the database, and an error message either if she exists and is not valid or does not exist at all.

This thrilling tale is continued in Part 2 – The .aspx File


About Dan Hurwitz

A consultant specializing in .NET.
This entry was posted in Software Development and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s