Newbie: ASP.net and SQL server - login help

[rickjamesb]

A tutorial would be great (everything i found was for Access or MYSQL which caused errors). I have no clue what i am doing. First off, tell me if this will work, or if i'm going at this the wrong way...

I have an SQL database with a customers table. Attributes include: username and password.

I have a login.aspx page with two text boxes - txtUsername/txtPassword (for username and password verification) and a button to submit - btnSubmit.

What code do i put on the submit botton or aspx page?
How do i search the Customers table to see if they have a valid username/password?
Do i need code for a stored procedure - sql query?
And once the user is verified, how do i automatically redirect them to the protected page? Example: members.aspx

 

[blar9]

Add a dataset to your page, create a table adapter called Login for example that will select userid maybe from your login table and give it 2 variables ie.

Select * from Users where username=@username and password=@password

then you can use that query on your button click event

dim dt as new DatasetName.LoginDataTable
dim da as new LoginTableAdapters.LoginTableAdapter

dt = da.Login(txtUserName,txtPassword)

if dt.rows.count > 0 then
response.redirect("somepage.aspx")
endif