2 of 3

Write now Article Tools

Visual Basic 2005 is an excellent platform for writing a client or Web application that accesses a database. It includes controls that support data binding, as well as a full-featured data access object library. It also allows you to create stored procedures for use with SQL Server 2005.

The simplest way to create a data access application with Visual Basic 2005 is to use data binding. Data binding allows you to define a data source and bind that source to controls that can display and update the data. You can access any data for which there is a database provider, including an Access database file, an Open Database Connectivity (ODBC) data source, Microsoft SQL server, or Oracle. You can also data from an Extensible Markup Language (XML) Web service.

When you need more control over the data, you can use the OLE DB classes to connect to, view, and modify a data source. This method requires more code than using data binding. However, it allows you to provide additional functionality in the client code, such as validating user input before modifying the data source.

A better option for validating user input when using SQL Server is to create a stored procedure. You can combine stored procedures with databinding to create a secure data access application.

Learn more about this author, Rachelle Reese.
Click here to send this author comments or questions.

Add your voice

Know something about The pros and cons of VB database programming?
We want to hear your view. Write now!