i have a login web page and also a database in SQL. Page is connected with database. problem is that the password in database is in small letters but when i keep caps lock on then i can also login. now i want to restrict that user can add password with number also alphabet. and when password is in small letters and user use caps locks on then password will not match.
This is my Table
And this My aspx code
and the stored procedure is
Can anyone help me where and what code is placed?