modifying the createuserwizard control (repost)

hi diya ahuja

thank you for ur replies and sorry for having to keep bugging you like this..

below is the source code for the CreatedUser event

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.SessionState;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;

public partial class Admin_Default : System.Web.UI.Page
{
    protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
    {
        //// Create an empty Profile for the newly created user       
        ProfileCommon p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard1.UserName, true);

        p.FirstName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtfname")).Text;
        p.LastName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtlname")).Text;
        p.Email = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Email")).Text;
        p.Department = Int32.Parse(((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtdepartment")).Text);
        p.MobileNo = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtmobno")).Text;
        p.ExtNo = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtextno")).Text;
        //// Save the profile - must be done since we explicitly created this profile instance
        p.Save();

        TextBox UserNameTextBox = (TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("UserName");
        SqlDataSource DataSource = (SqlDataSource)CreateUserWizardStep1.ContentTemplateContainer.FindControl("InsertUserDetails");

        MembershipUser User = Membership.GetUser(UserNameTextBox.Text);
        object UserGUID = User.ProviderUserKey.ToString();

        Session["UserId"] = Membership.GetUser(UserNameTextBox.Text);

        //Perform insert operation like
        String connString = "Data Source=ZELLOLA-PC;Initial Catalog=BMLHelpDesk;Persist Security Info=True;User ID=sa;Password=psswrd";
        SqlConnection objcon = new SqlConnection(connString);
        objcon.Open();

        string q = "insert into users (UserId, usr_ID, usr_FName, usr_LName, usr_email, dprt_ID, usr_MobNo, usr_ExtNo) values (@UserId, @usr_ID, @usr_FName, @usr_LName, @usr_email, @dprt_ID, @usr_MobNo, @usr_ExtNo)";

        SqlCommand comm = new SqlCommand(q, objcon);
        comm.Parameters.AddWithValue("@UserId", Session["UserId"]);
        comm.Parameters.AddWithValue("@usr_ID", p.UserName);
        comm.Parameters.AddWithValue("@usr_FName", p.FirstName);
        comm.Parameters.AddWithValue("@usr_LName", p.LastName);
        comm.Parameters.AddWithValue("@usr_email", p.Email);
        comm.Parameters.AddWithValue("@dprt_ID", p.Department);
        comm.Parameters.AddWithValue("@usr_MobNo", p.MobileNo);
        comm.Parameters.AddWithValue("@usr_ExtNo", p.ExtNo);

        comm.ExecuteNonQuery();

        objcon.Close();

    }
}

the @UserId parameter is supposed to add the UserId field from the aspnet_Users to the table i created.

i still can't save anything into the table i've created myself. :S

now i am getting a different error message saying ...

No mapping exists from object type System.Web.Security.MembershipUser to a known managed provider native type.

and the 

Source Error:

Line 54:         comm.Parameters.AddWithValue("@usr_ExtNo", p.ExtNo);
Line 55: 
Line 56:         comm.ExecuteNonQuery();
Line 57: 
Line 58:         objcon.Close();

Stack Trace:

[ArgumentException: No mapping exists from object type System.Web.Security.MembershipUser to a known managed provider native type.]
   System.Data.SqlClient.MetaType.GetMetaTypeFromValue(Type dataType, Object value, Boolean inferLen) +1920083
   System.Data.SqlClient.SqlParameter.GetMetaTypeOnly() +4875045
   System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) +17
   System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters) +203
   System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc) +237
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   Admin_Default.CreateUserWizard1_CreatedUser(Object sender, EventArgs e) in c:\Users\Zellola\Documents\project stuffs\BMLHelpDesk-Copy\Admin\CreateUser.aspx.cs:56
   System.Web.UI.WebControls.CreateUserWizard.OnCreatedUser(EventArgs e) +111
   System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +354
   System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +102
   System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +418
   System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +161
   System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +19
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

i am really sorry about this :S

i am just going nuts because of this.. i am working on my final project and trying to finish this asap and focus on the studies since this is the last semester.. hehe

hope you could help me on this..

thank you :)