database for login control in asp.net

[sweetkinjal]

Hello everybody!
I'm doing my project about ASP.NET but i don't know howto create Database.
Example:
UserName: xxxxxxx
Password: xxxxxxx
Login(<<<)

i want to know how the code working. i want to know where my data will be stored. for example if i am creating login control then which fields are required in my database and what are the steps to do it...e. I want use using SQL database.
Thanks for helping me.
please please reply me fast....

[Fortinbra]

Easiest way is to use the Aspnet_regsql.exe, and it will add all the tables, stored procedure, and anything else necessary to allow .NET to manage your logins and users for you.

[abhay1234]

if using vb as ur asp.net language you can refer this for sql server

http://www.vbdotnetheaven.com/uploadfile/mahesh/createsqldatabase04252005064419am/createsqldatabase.aspx

[__avd]

Welcome @sweetkinjal

Please take a look at this tutorial from asp.net An Overview of Forms Authentication (Form Authnetication and Authorization).