How can one search for multiple items at once and display the result in a datagrid? for example, i want to search for multiple mobile numbers (in sql server database)at once and display the found numbers and their corresponding names.
Netcode
33
Veteran Poster
Recommended Answers
Jump to PostSomething like:
select FirstName, LastName from MyTable where PhoneNumber in ('111-222-3333', '222-333-4444')
The in clause allows you to specify multiple values to compare to and returns whatever matches any one of the values.
All 4 Replies
Momerath
1,327
Nearly a Senior Poster
Featured Poster
Netcode
33
Veteran Poster
crapulency
0
Junior Poster in Training
zx1
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.