Hi,
.Net provides some pre build components to do this, or otherwise you can write one of your own, which will read the username & password entered by the user authenticate it with the database and take the user to page for logged in user.
Hope this helps.
Cheers,