Search textbox value irrespective of that case of the word

Nethra R S

15y3.6k

Hi friends,

Newbie here,

Irrespective of the case i want to search for the name entered in the textbox in asp.net. If the name exists even partially like for example if only Beena is enter where as the complete name is Beena Paul or if only Paul is entered irrespective of the case typed in .. The result should come. How do i write the query for that plzz help

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
I think that what you are describing is often called auto-completion; you can look for articles about that. I think that if the amount of data is relatively small then you could just fill a combobox or something like that and use auto-completion, which would provide good performance unless the amount of data is large and the bandwidth to the client is not fast.
0
Priya Linge15y ago
Hi,

You enter the string in Textbox.

string str=textbox1.Text;

string s = str + "%";

string query = "select ClientName from Client where ClientName like '" + s + "' order by ClientName";

This way you search the name.

Hope this will help you.

Thanks.
0
Jiteendra Sampathirao15y ago
use wild cards like

SELECT * FROM Persons
WHERE name LIKE 'sa%'

you will get this type of names

sampathi, santhosh etc..

refer LINK
0
Om prakash Singh15y ago
if you enter Beena then the query will return all the name which contains beena.
If you enter Paul then the query will return all the names which contains paul.
If you enter Beena Paul then the query will return all the names which contains beena paul.

So just try the query.
0
Nethra R S15y ago
Ok,

But what if only 1 part of the full name or half the name is entered .. How to write query for that?
0
Jiteendra Sampathirao15y ago
hi,
convert the value to either upper case or lower case like TextBox.Text.ToLower() or TextBox.Text.ToUpper().........

this is the good practise.......
0
Om prakash Singh15y ago
sql="select * from employeemaster where lower(name) like '%"+TextBox1.Text.ToLower()+"%'"";

Use query like this, u will get the result
0