Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Querying a dataset
- Thread starter drimades
- Start date
- Thread starter
- #4
- Thread starter
- #5
Following the guide of Visual Basic they say:
To create a parameterized query and controls to enter the parameters
Select the DataGridView control, and then choose Add Query on the Data menu.
Type FillByCity in the New query name area on the Search Criteria Builder Dialog Box.
Add WHERE City = @City to the query in the Query Text area.
The query should be similar to the following:
SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax
FROM Customers
WHERE City = @City
Note:
Access and OleDb data sources use the question mark '?' to denote parameters, so the WHERE clause would look like this: WHERE City = ?.
Click OK to close the Search Criteria Builder dialog box.
A FillByCityToolStrip is added to the form.
This if I have only a word in the textbox of City (for example). What if I have 2 or more words (and so more conditions) written in the textbox called City?
To create a parameterized query and controls to enter the parameters
Select the DataGridView control, and then choose Add Query on the Data menu.
Type FillByCity in the New query name area on the Search Criteria Builder Dialog Box.
Add WHERE City = @City to the query in the Query Text area.
The query should be similar to the following:
SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax
FROM Customers
WHERE City = @City
Note:
Access and OleDb data sources use the question mark '?' to denote parameters, so the WHERE clause would look like this: WHERE City = ?.
Click OK to close the Search Criteria Builder dialog box.
A FillByCityToolStrip is added to the form.
This if I have only a word in the textbox of City (for example). What if I have 2 or more words (and so more conditions) written in the textbox called City?
- Status
