Visual Basic Concepts

Creating a DHTML Application that Interacts with SQL Server Data

Visual Basic lets you easily create applications that use the Internet or a corporate intranet to interact with data in a distributed relational database system such as SQL Server. For example, you can create an application that uses an HTML page for data entry or to query data in your database.

Topics

This scenario shows you how to create a DHTML application that interacts with data in the Pubs sample database in SQL Server. It is designed for use on an intranet and requires that you view HTML pages using Microsoft Internet Explorer 4.x. The scenario demonstrates:

• Adding a table to an SQL Server database

• Creating a data entry HTML page

• Creating an HTML page for viewing and updating data

• Creating an HTML page that runs a stored procedure