Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

accessing userid immediately after creating the user in asp.net

Hi,
I want to get the userid of the created user in the same page (infact create user page) immediately after creating the user. How can i do that? Please help me.
Thanks in advance
0
CPSRI
Asked:
CPSRI
1 Solution
 
kswathiCommented:
You need to check the insert procedure of creating user,

in Sql
after insert if your userid column is auto increment value then write after the insert statement

Select SCOPE_IDENTITY()

and in your Data Acess
use ExecuteNONQuery to retrieve the inserted(user Id)  value.

0
 
EyalCommented:
from the stored procedure you can return the user record after inserting to the table
use select f1,f2.f3 from users where id= SCOPE_IDENTITY()
0
 
guramritCommented:
There should be a CreateUserWizard control on page. Add handler to "OnCreatedUser" event, say "CreateUserWizard1_OnCreatedUser". CreateUserWizard1_OnCreatedUser event will be fired when user is created.
Now in this function you can access just created username using property CreateUserWizard1.UserName,
see following code:

aspx:

<asp:CreateUserWizard ID="CreateUserWizard1" runat="server" OnCreatedUser=CreateUserWizard1_OnCreatedUser>
...
...
...
...
</asp:CreateUserWizard>


code behind:
    protected void CreateUserWizard1_OnCreatedUser(object sender, EventArgs e)
    {
        var uname = CreateUserWizard1.UserName;
        // do something...
       ...
       ...
       ...
    }
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
CPSRIAuthor Commented:
hey, i am so excited to meet you both again here, thanks for your replies but i want to access it in my asp.net page using c# code, and i am using asp.net membership class to create user. i can get the solution if you tell me exactly which stored procedure will be used to create user, in my case, using Membership class.
0
 
guramritCommented:
If you are using Membership class, then you'll be using Membership.CreateUser to create user.
This function returns MembershipUser, which contains all the properties of newly created user.
e.g.

MembershipUser user = Membership.CreateUser("testuser", "testpassword");
lblUser.Text = "Hello " + user.UserName;

http://msdn.microsoft.com/en-us/library/d8t4h2es.aspx
0
 
CPSRIAuthor Commented:
Thank you
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now