You seem to be looking for Form Authentication, which is part of asp.net. Hopefully, you are using a SQL Server or SQL Express database, in which case the aspnet_regsql tool will allow you to create a user table if you don't already have one. If you do have a user table or if you are not using a MS database, then you will need to write your own user membership provider. However, do not worry, it is not really difficult and there are tons of example on the net.
To begin with, a link with a sample to implement Form Authentication, which explain the controls to use on your pages: http://www.15seconds.com/Issue/020220.htm
Also, Microsoft has some example of provider implementations: http://msdn.microsoft.com/en-us/library/f1kyba5e.aspx. To search for more information, look for 'asp.net custom membership provider' in your favorite search engine.