How to pass values from SQL to ASP.Net?
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?
Re: How to pass values from SQL to ASP.Net?
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.
Re: How to pass values from SQL to ASP.Net?
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?
Re: How to pass values from SQL to ASP.Net?
what type of your database is? It can be very easy if you use SQL Server
Re: How to pass values from SQL to ASP.Net?
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.)
Re: How to pass values from SQL to ASP.Net?
heh heh......good link....tk! :bigyello: