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