Click here to Skip to main content
15,843,623 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I'm creating a login page in windows form using C#.net. As usual two labels, two textboxes for username and password. two buttons for login and cancel
Have done with design level, I want to create a table in database for this login, what are the basic field I should include in that table for the Login function like username,password, roles,etc
Posted

1 solution

Applications usually vary but here is what I am putting on my UserInfo table.
UserID
UserName
EmailAddress
Password -- this should be at least hashed on the application side
RoleID -- a foreign key to the roles table
FirstName
LastName
DateOfBirth
...etc


There might be instances where you want to separate the user info to another table and your username and password to another table.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900