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 ...
Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
