I am using login control now the problem is that when password is entered it checks password form sql but does not check case.

what ever the case is in sql databse it hardly matters to m code. how d i correct it where i am wrong.

please help me.

its because by default SQL Server is case insensitive.
for implementing case sensitive queries you have to change your password column

SELECT * FROM tablename WHERE mypassword='password entered by user' sql_latin1_general_cp1_cs_as

using sql_latin1_general_cp1_cs_as collation you can write case sensitive queries in SQL Server

for further information you can look at this article http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

check out below solved thread links..

check case sensitive while login - ASP.NET Forums

ID and Password--case sensitive - ASP.NET Forums

hope it helps./. 

thanks both of you.

i havent tried it but i guess it will work.

thanks once again