TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
r p
NA
343
0
CREATEUSERWIZARD or OWN REGISTRATION TABLE
Nov 25 2008 4:44 AM
I am creating an Employee Site for employees to insert their CV and employers to contact them.
I have 3 main tables:-
1. Employee_Career_History (career_id, username, experience, area etc.)
2. Employee_Education_Details (edu_id, username, qualification, details etc.)
3. Employee_Hobbies (hobby_id, username, hobby etc.)
Suppose an employer wants to see the details of a PARTICULAR employee, at the button click event of the search button, I run a query like-
"select * from Employee_Career _History where Employee_Career _History.username=@username"
Now, the problem is-
1. if the user CHANGES HIS USERNAME, his record in the tables will never be accessed by the employer when he wants to see that particular person
(because the employer sees his new username and in the record in table has ONLY his OLD username), so
should I go some other key (eg. ProviderKey) or Should I go for myown registration table instead of createuserwizard?
2. Will CreateUserWizard in asp.net allow to CHANGE USERNAME?
3. I am using email as the username (in the text box for username I ask the user to enter email id). Hope it is fine.
Reply
Answers (
10
)
Redirect the Page after waiting some time
to close a application