[2008] - DataSet/Grid and MSAccess07 Querying

[talmeeno]

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 -

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.

[jmcilhinney]

You should go to the Database Development forum and read the FAQ thread at the top, then follow the relevant links.

[talmeeno]

i had a read there, just nothing seemed to relate to what im after.. all i wanted was something which told me step by step how to get a query working..

Edit: thankyou i managed to find some information it seems from ur sig.

[jmcilhinney]

Everything there relates to what you're after. It all about data access. Did you follow the ADO.NET links from that FAQ thread? There's an ADO.NET tutorial by mendhak. I think there's a fair chance that that shows you how to execute a query. There's also a thread by myself that includes ADO.NET code samples.