How to search a name using either no or name in textbox.?

Question

0.00/5 (No votes)

See more:

Hi,

How to search a name using like no or name in text box..?

For example,

Emp.Id Emp.Name
------ --------
D101 Raja
1230 Raghu

If i type "D101" in the text box, the text box should fetch both no and name like D101-Raja.
Or
If i enter "Ra", the text box should fetch both raja and Raghu.

This is i want to use in ajax control with ASP.NEt Text box..

How to do this...?

Posted 9-Nov-11 19:44pm

gani7787

Add a Solution

Comments

sahabiswarup 10-Nov-11 1:47am

you may try textbox selectedindex changed.
that will help you to solve your problem.

Anil Honey 206 10-Nov-11 3:24am

you want to Implement AutoComplete Extender or Normal TextBox.

3 solutions

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)

raj ch · Answer 1 · 2011-11-09T20:20:00

In ur txtbox_selectedIndexChanged event call the following function

VB

public sub getData()
dim dbconn,sql,dbcomm
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
sql="SELECT CUSTNUM,CUSTNAME,CUSTACTIVE FROM customers where CUSTACTIVE <> 'I'"
        If txtNum.Text <> 0 Then
            sql= sql & " AND CUSTNUM LIKE '" & txtNum.Text & "%'"
        End If
        If txtName.Text <> 0 Then
            sql= sql & " AND CUSTNAME LIKE '" & txtName.Text & "%'"
        End If      
dbcomm=New OleDbCommand(sql,dbconn)
end sub

After getting data from it use it in ur program

arunrv · Answer 2 · 2011-11-09T22:08:00

Solution 2

u can use SLQ Like operator with '%' placing

check out this link it will help u

http://www.w3schools.com/sql/sql_like.asp[^]

Posted 9-Nov-11 22:08pm

arunrv

puneetisonfire89 · Answer 3 · 2011-11-09T22:20:00

Solution 3

it simple use autopostback =true and fire the event ontextchanged and use sql query with like keyword

Posted 9-Nov-11 22:20pm

puneetisonfire89

Updated 9-Nov-11 22:28pm

v2