Login Validation

[kiran01]

Hi All , I am working with Asp.net 2.0 C# and my database is SQl 2005 .I hve a problem with putting Login Validation . I want tht when user enters username and Password it should be verified with database if ID PWD matches then user should be logged in and if it doesn't match then it should give login failed . Can u plz pass on d code if possible . Thanks in advance

[Imran Khan Pathan]

1. Write sql query string to get ID of user and fill dataset if username and password wont be matched it returns value 0.If ID is 0 give msg that Login Failed otherwise it successed. 2. U can also check that if ds.rows.count==0 return false for login failed otherwise true. Best Regards Pathan

[kiran01]

I have given this code WebForm1

Login:

Password: