Changes

Accessing Databases Using Visual Basic

399 bytes added, 18:52, 9 August 2007
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]]