Finding multiple matches from a database

  • Thread starter Thread starter jy836
  • Start date Start date
J

jy836

I'm using an OleDbConnection, OleDbDataAdapter, DataSet, and DataGrid to
display the filtered contents of a database. In this database, there are
thousands of names, and some of them are identical. Is there a way to search
for the next instance of a name in a database? Whenever I search for a name,
it appears to only return the first instance of that name that it finds
(unless I'm missing something here). I want to create a list of all the
identical names (along with some other fields so that the user can
differentiate between the identical names), so that the user can choose
between the names. Thanks in advance.
 
Hi Jy

In the OleDbDataAdapter.SelectCommand.CommandText
= "Select [relevant fields] from Table where FieldName
like '% " & variable & "%'"

Kind Regards
Jorge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fake Whatsapp download tricks over 1 Million Android Users 2
Excel Excel - Two Database Formula extraction? 3
How put a Dataset in a Datagridview 3
ADO Update Problem 2
DataSet into DataGridView 2
large values from database 1
updating listbox with database update 1
Multiple DB Selects require multiple connections? 1

Back
Top