I've a DataReader which its Command involves a LIKE clause. For it to be executed, a String is passed as a paremeter from a TextBox at the UI. All data in the DB is stored as UpperCase strings. The scenario I face is as follows:
- If the user inputs an Uppercase String at the UI, the DataReader gives results without problem
- I've tried to give a sort of "protecction" to the input, so if the user inputs TitleCase or LowerCase, then the query still works as intended. Yet, when I use CultureInfo.CurrentCulture.TextInfo.ToUpper(myTextBox.Text) or
myTextBox.Text.ToUpper() , if I check the debugger, it even shows that the parameter is changed to UpperCase, yet, the dbConn.dbCommand.ExecuteReader() sends no results.
Could anyone give any hint or explanation of why this is not working? (and suggest a solution).
Thaks a lot in advanced for any help.