Microsoft Access 07
Visual Basic/Studio - 08
Windows XP / Vista

Hi, im currently working on a program which must connect to a microsoft access 07 database file and do various operations on the data and then resave the data.

Currently i can get the information displayed in a table using a DataGrid and browse through the data by scrolling or using a combo box which i linked to the data.

First Question: I am making a query for a quick search function using a text box and a button. I have the sql already however i need some help implementing the variable QSearch into the sql. QSearch is the variable which stores the infomation in the quick search text box. The query is currently in the TableAdapter section of DataSet.xsd ???
SQL -
Code:
SELECT *
FROM Members
WHERE (any row is like QSearch)

Question 2: If this isnt going to work or there is a much much simpler way to do this, please can someone point me in the right direction. Thankyou very much.


if there is any other information you require please feel free to let me know
cheers.