Verify case-sensitive Password in asp.net using sql server during login

asp.net, c#-4.0, sql-server, sql-server-2005, sql-server-2008

Solution

CREATE TABLE #temp
(
    Password Varchar(2)
)
insert into #temp values('a')

First Approach

select Password  from #temp Where Password COLLATE Latin1_general_CS_AS  = 'A' 
select Password  from #temp Where Password COLLATE Latin1_general_CS_AS  = 'a'

Second Approach

select Password  from #temp Where cast(Password as varbinary(2))  = cast('A' as varbinary(15)) 
select Password  from #temp Where cast(Password as varbinary(2))  = cast('a' as varbinary(15)) 

drop table #temp

Problem

Return Successful ``` Dim user = "ravi" Dim pass = "admin" objcmd.CommandText = "Select * from ADMIN_INFO where ADMIN_ID='" & user & "' and ADMIN_PASS='" & pass & "'" ``` Return Successful ``` Dim user = "ravi" Dim pass = "ADMIN" objcmd.CommandText = "Select * from ADMIN_INFO where ADMIN_ID='" & user & "' and ADMIN_PASS='" & pass & "'" ``` After execution of query, both return successful, where as in table only `ravi` and `admin` is available. So, how can i check for case-sensitivity. Need help !!

Original source