How to make SQL and ASP.Net interact?

[ZhiYi]

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?

[tenno]

Hi there, hope this link helpful for you:

http://msdn.microsoft.com/vstudio/express/vwd/learning/

[Shuja Ali]

Well you have a duplicate thread and it has already been answered in the database forum. If there is no record matching then there won't be any records returned by the select query.