Hi,All


I want to use Asp.net membership feature.In create User Wizard There I see that is only 5 to 6 options availaible.ie

username,password,email,security question,answer

I Have A create user wizard  form there are 10 to 20 controls extra ie others information I have to take and their values will be get stored in database .
I am thinking of a structure that will have a master user tables and

other tables linked to master with user id(primary -foreign key relation)


BUt the main logic is how to add extra data that i am saying with asp.net membership feature
 

You can check on these links as this topic has been discussed before:

http://forums.asp.net/t/1370557.aspx

http://forums.asp.net/t/1362221.aspx

http://forums.asp.net/t/1358992.aspx

Some similar logic here:

http://aspnet.4guysfromrolla.com/articles/070506-1.aspx

http://www.asp.net/learn/security/tutorial-08-vb.aspx

In short:

In the CreatedUser Event of CUW ... Get the controls' value and insert them into the other tables linked to master table via UserId.

Sample code a bit modified from second link:

// Get the UserId of the just-added user

String FirstName = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("FirstName")).Text;

// Insert a new record into UserProfiles

string insertSql = "INSERT INTO User_Profile(UserId,FirstName, LastName) VALUES(@UserId, @FirstName, @LastName)";

myCommand.Parameters.AddWithValue("@FirstName", FirstName);

 Hi,

Tell Me One Thing .

That What is the solution for the case.

Suppose I have already a table with three fields userNAme ,Password nand email means previously I was having these tables and other tables are linked though these UserId.

I want to ask that now How to implement Asp.net membership feature with these data .

I think I am asking A valid question because If a company already has present data and if he wants to implement asp.ne membership feature 

then They cant afford to make their users to re register in them.

Please Tell Me.

Suppose I have already a table with three fields userNAme ,Password nand email means previously I was having these tables and other tables are linked though these UserId.

So do you want to use Membership APIs only or the membership database schema as well.

If you just want to use Membership APIs ...with your already existing tables you should look into 'Custom Membership Provides'. 

If you also want to use membership tables, you will have to migrate your data from your table to membership tables. You might want to look into DTS with Sql Server.

Or you can loop through the existing user table and pass the values to Membership.CreateUser(..) method to register them automatically instead of asking users to re-register. But this has some complications involved.

 Hi,GUru

Actually I want to avod seesions controlling for credintials.

There for I want to imple ment that asp.net membership tables features that will automatically control my site 

on behalf of security it has .That Is wahy I was Asking that How can I make my my tables Suppose 

Mast_user Table That I ahve Specified abopve.

DO u help me With some Code .

Actually I want to avod seesions controlling for credintials. 

There for I want to imple ment that asp.net membership tables features that will automatically control my site 

on behalf of security it has .

could you explain a bit on that.

Also explain how are you authenticating now and what different behavior you are expecting when using membership providers.

 Hi,

I am ahving this doubt from many days how to implement that what i am saying.

 Currently I am using Session to store userid so that i can make  acces to particular page to that user on behalf of that id .I have A user table and others table linked to that user table with user id

as foreign key relation ship Now that user table has userid,username,password,email column in it.I am saving the data in traditioal way as it is.

 Now i wan to make my same database structure so that i can make use of that asp.ne membershipfeature.Means In front end i will then be able to use Login contros etc provideed by Asp.net

Actually i am not familiar wit that custom membership class that u r saying.

So what wuld u say about my case............

For custom membership provider check this: This will help you use your existing database in backend and login controls in front-end.

http://support.microsoft.com/default.aspx/kb/910440

http://www.asp.net/learn/videos/video-189.aspx

Membership provider makes a database call to get the userId by passing the username.

so if you have unique username, you can also write your own function that can retrieve userId from database ..passing username as parameter.

You can obtain the username of logged-in user from Current HttpContext.

 Hi,Guru

Thanks for supporting 

guru_sarkar:

so if you have unique username

Ya I have UserName Column Unique 

guru_sarkar:

For custom membership provider check this: This will help you use your existing database in backend and login controls in front-end.

Really .............. can  i do that 

It will be awsome If I could get that successfull .

Thanks So much I wll let u know After implementing that If I face Any thing Than I hope u will support in future.....