How to pass values from SQL to ASP.Net?

[LiLo]

Hi,

I am making a login web service. First a database is created. It has ID,username and password attributes.

I plan to use the SELECT statement to retrieve the user record from the database.

How do I enable the ASP.Net code to check the password attribute value returned by the SELECT statement?

And if there is no record found, what value does the SELECT statement return and how to make ASP.Net know about this value?

[mendhak]

1. Why should your SELECT statement return the password? It needs to accept the password and compare it against the value stored in the database.

2. If no records are found, your dataset's table should have 0 rows in it.

[LiLo]

How do I use SQL statements to compare the passwords?

And if there is a mismatch or match, how does the ASP.Net code know about it?

[lekhuyen]

what type of your database is? It can be very easy if you use SQL Server

[mendhak]

http://www.daniweb.com/techtalkforums/thread19303.html

(I was going to explain it, but I came across this page and couldn't believe someone had written a tutorial for this.)

[LiLo]

heh heh......good link....tk!