Database (Access) searching code (1 Viewer)

[Weddas]

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="OneNote.File"><meta name="Generator" content="Microsoft OneNote 14"> Hey i don't know if this post belongs here but i am having trouble finding a way to search a database from access and is connected into the software solution where there can be multiple results in vb .net?

If someone knows how to do this or can help at all it would be greatly appreciated.

thanks

Weddas

 

[harrisony]

Use OleDbCommand with some SQL (if you can't write out the SQL use the sql builder thingy in access)

 

[Weddas]

Cheers i will give it a go tonight

 

[Weddas]

unfortunatly i still can not get it to work, i dont know if its a misunderstanding on my behalf or if im just doing something wrong.
is there any other way, like by typeing a name into a text box and for that to be connected up with the name feild in the database which then is filted into a table?

sorry for makeing this painful but i just dont get it?

cheers

Weddas

 

[harrisony]

There might be (google may be able to help), I tend to do things using SQL as I get tons more control and its standard across many database systems. If you have some come code to show me and the the database (or even just the table structure) i'll see what I can do