34,333
edits
Changes
→Adding SQL Statements to a Visual Basic Application
Click on OK. Visual Studio will generate the appropriate SQL statement to perform this query.
<pre>
SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (Country = 'France')
</pre>
Press '''F5''' to rebuild and run the application. An additional toolbar now appears labeled ''France'' which, when pressed, filters the database entries so that only customers in France are selected:
[[Image:Exampl.jpg]]