Incremental search

[mp]

Hi,

I need help in following...

I have used:
Visual Studio 2002 or 2003 - C#
Access DataBase
ADO connection

I am looking for example or directions of incremental search.
--------------------------------------------------
I would like to set a incremental search for example in dataGrid.
When user put A in edit box in dataGrid should be listed all contents of db
started with letter A.
When user put AB should be listed all contents started wit AB etc
Example: User put abandon and get:
....
abandoned napusten
abandoned napustene
abandoned napusteno
abandoned nezbrinut
abandoned nezbrinutu
abandoned ostavljen
abandoned ozloglasen
abandoned raskalasen
abandoned raspusten
abandoned child napusteno dijete
abandoned land napusteno zemljiste
abandoning napustanje
abandonment napustanje
abandonment napustenost
abandonment neusiljenost
abandonment odricanje
abandonment odustajanje od
abandonment ostavljanje
abandonment prepustanje
....

How we can do that with C#, ms access and VS?

Thanks

 

[John Baro]

Is "abandoned napusten" and "abandoned napustene" contained in a single
column in the db.
If they are then you could do
SELECT ColumnName FROM TableName WHERE ColumnName LIKE '%abandon%'
HTH
JB
PS
This will work in SQL Server, the syntax might be slightly different for
access.

 

[mp]

No, there are two columns.

English Croatian

 

[mp]

I have try:

new OleDbCommand("SELECT * FROM MyTable WHERE ENGLESKI LIKE 'abandon'",
thisConnection)

I get only abandon listed, without abandoned etc.

I would like to get all words started with A for e.g. if I look for A

Thanks