5
Reply

Search exact text in datareader

Gertrudis Carreras

Gertrudis Carreras

Jun 23 2013 9:03 PM
1.2k
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)