Open main menu

Changes

Accessing Databases Using Visual Basic

303 bytes removed, 18:49, 9 August 2007
no edit summary
In this chapter of [[Visual Basic Essentials]] is intended to provide a detailed overview of developing applications that work with databases using Visual Basic and ADO.Net. In the next chapter, we will build on this knowledge by by exploring [[Visual Basic and the DataGridView Control]]. As with most other aspects of Visual Basic and Visual Studio, Microsoft have put a significant amount of work into making it easy to work with databases. In fact, an incredible amount of database functionality can be built into a Visual Basic application without actually writing a single line of code.
The examples in this chapter work with a Microsoft Access database. The concepts covered, however, apply equally to other databases such as Microsoft SQL Server.
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>