O'Reilly logo

Programming Visual Basic 2005 by Jesse Liberty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Web Data Access

In the previous chapter, you created forms, but they did not interact with real data. In this chapter, you'll begin to extract data from the database and fill in your forms. You'll do this incrementally, adding complexity as you go. You'll put a premium on using data controls and letting the controls manage the "plumbing" of database interaction.

Getting Data from a Database

To see how to interact with a database, begin by creating a new web application that can be used to display information about the Northwind database. Call it WebNorthWind, as shown in Figure 11-1.

Creating the WebNorthWind web site

Figure 11-1. Creating the WebNorthWind web site

You'll be working with the Customers table in the Northwind database, so rename your .aspx file from Default.aspx to Customers.aspx (don't forget to change the class name both in the code file and in the page directive!).

Create a Data Connection

You need a connection to the database. You can explicitly create one, or you can use a control that depends on having a connection and one will be created for you. Let's start by explicitly creating one.

Drag a SqlDataSource control onto the form, as shown in Figure 11-2.

Data source control

Figure 11-2. Data source control

The SqlDataSource control will appear on your form, as shown in Figure 11-3.

Figure 11-3. SqlDataSource control ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required