Search exact text in datareader

Jun 23 2013 9:03 PM
Hi to all,

I have a datareader that return the list of all users in a database, but always return text in lower or uppercase:

string CommandText = "SELECT username, password " + " FROM users" + " WHERE username = @Find";

users in database:
jose
maria
carlos

if Iwrite: JOSE in upper case, it shows the one in lowercase how to avoid this please.

Thanks in Advance

Answers (5)