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?