data reader

Question

I'm trying to match a UserID and Password from existing database using Data Reader and if no match shoe message and validating the information on the return

Khargesh Rajput · Answer

what problem you are facing Sample for fetch data is like SqlCommand command = new SqlCommand( SELECT * FROM login where username=@uname and password=@pwd; connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { //login success } else { //invalid login }

Akhil Garg · Answer

http://www.codeproject.com/Questions/339666/verify-user-name-and-password-in-csharp-form