AutoComplete TextBox with same words but case different does not show the second option

Question

1.00/5 (2 votes)

See more:

Does someone knows how you can make words shown which are case different, but the same.

In a Database someone has entered the word lowercase (in that project all words are)
Normaly the word starts with an uppercase.

The suggestion is now always lowercase.

For example:

Staircase
staircase
(both are in the string array)

The textbox will only suggest staircase. Staircase does not exist as suggestion.

Thanks

Posted 11-Mar-13 4:58am

Piet Pelle

Add a Solution

Comments

ZurdoDev 11-Mar-13 11:08am

Have you traced the code to see what it is doing?

2 solutions

Solution 1

Hi
sorry i am not clear with your question. can you explain in details.

Posted 11-Mar-13 6:27am

Ayyappan Ravi

Comments

Richard C Bishop 11-Mar-13 12:29pm

You will want to use the "Have a Question or Comment?" link to ask questions or post comments. You posted this comment as a solution.

Piet Pelle 11-Mar-13 13:53pm

try a textbox with say three lines in AutoCompleteCustomSource
staircase
Staircase
Stair
AutoCompleteMode = Suggest
AutoCompletSource = CustomSource

if you type a 's'in the textbox it only shows one staircase (the wrong one) and stair
I believe that the textbox considers them the same . . .

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Piet Pelle · Accepted Answer · 2013-03-11T23:04:00

It is not the best solutions, but on the sql query i use:

select unique lower(fieldname),fieldname from table order by lower(fieldname) asc

with a foreach loop in the dataset i check the first value with the previous one

if the same: i add to the second value ' ²'

the second value is added to the array list.

If choosen in the texbox on the TextChanged option I replace the last part with nothing . . .

string sDubbel = "";
string[] sAReturn = new string[dsRes.Tables[0].Rows.Count];
foreach (DataRow dr in dsRes.Tables[0].Rows)
{
if (sDubbel == dr[1].ToString().Trim().ToUpper())
dr[1] = dr[1].ToString().Trim() + " ²";
else
sDubbel = dr[1].ToString().Trim().ToUpper();

sAReturn[ii] = dr[1].ToString().Trim();
ii++;
}
dsRes.Dispose();
return sAReturn;