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
 
Back
Top