How can I search from Access database connected to VB?

[Ziyoda]

I don't know how I can do it, because I have no idea how searching works in databases. Does it first search and then display results in ascending order or do I have to rewrite SELECT... FROM... query and add WHERE place? Can you help me?

[shakti5385]

SELECT... FROM... query and add WHERE place? is the best solution for the searching , After it you can select the result. And In this way you can use the multiple table in the query also.

[Ziyoda]

Could you please tell how to do that? I cannot find that! Should I updata that query?

[shakti5385]

Use the query and get all the record in the datatable from the database, There is not need to update the record useing the SELECT query it will show the data only foollow the given conditiion. Use can use the WHERE Clause in the SELECT query for getting the data.