O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

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

Seat Pricing

Clicking the Seat Pricing button returns a tabular display of current seat prices at the YMLD Theater (see Figure 12-7).

Figure 12-7. Current seat prices

The logic for returning the seat prices is identical to the logic for retrieving the current productions at the theater.

The Visual Basic .NET version loads the data into a data set and then maps the values to a data grid for display. The core portion of the logic is shown next.

 Dim myReader As OdbcDataReader Dim PriceTable As New DataTable() Dim mySelectQuery As String = "SELECT * FROM PRICEPLAN" Dim myCommand As New OdbcCommand(mySelectQuery, YMLD.conn) Dim myRow As DataRow PriceTable ...

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