Hi,
I have a problem, I am trying to execute an insert into my database and I am doing that using the protected void CreateUserWizard1_CreatingUser()function of my CREATEUSERWIZARD control. I am using a stored procedure which name is "usp_EmployeeUserNameInsert". This stored procedure requires a parameter which is @Username and I have already assigned it a value. When I try to run my application it returns me this error:"An SqlParameter with ParameterName '@Username' is not contained by this SqlParameterCollection." Do I have to create a parameter collection? Where do I create that and how? Thanks
This is the code I am using:
 protected void CreateUserWizard1_CreatingUser(object sender, LoginCancelEventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["itworks"].ConnectionString);
        SqlParameter userParam = new SqlParameter("@Username", SqlDbType.VarChar);
        SqlCommand cmd = new SqlCommand("usp_EmployeeUserNameInsert", conn);
        cmd.CommandText = "usp_EmployeeUserNameInsert";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters["@Username"].Value = CreateUserWizard1.UserName;
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }:)

You'll be better off abstracting the data access code to its own library, maintaining code in event handlers becomes very hard work.
We use the Microsoft Patterns and Practices Enterprise Library for Data Access. It makes this sort of thing much cleaner and easier.

--

Joe (Microsoft MVP - XML)