Lesson 5: Add data to the dataset

In this lesson, you will add data to the dataset to test that the ClassicsCD sample application correctly totals each order placed in the application.

  1. In the Script Explorer, double-click Test dataset and then double-click Private Test dataset. Under the test script editor, double-click the Test dataset tab to expand the dataset editor so that you can work.

    The dataset editor opens and should look similar to the following table:

    Composer Item Quantity Card# CardType ExpDate Name Street CityStZip Phone Total
    0 Schubert String Quartets Nos. 4 & 14 1 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $19.99
  2. Position your mouse pointer in the dataset editor, right-click, and then click Add Record. Click OK to add a row after the first row.
  3. To add a second empty row, right-click Add Record.

    To save time, copy the data from row 0 in the dataset into the two empty rows that you created in steps 2 and 3.

  4. Position the mouse pointer in the row 0 cell, right-click, and then click Copy.
  5. Position the mouse pointer in row 1 cell, right-click, and then click Paste.
  6. Click Yes to paste the data into the empty row.
  7. Position the mouse pointer in row 2 cell, right-click, and then click Paste.
  8. Click Yes to paste the data into the empty row.
  9. Change the value in the Quantity and Total columns to test that ClassicsCD sample application correctly totals each order:
    1. In row 1, under the Quantity column, select the cell and type 2.
    2. In row 1, under the Total column, select the cell and type $38.98.
    3. In row 2, under the Quantity column, select the cell and type 3.
    4. In row 2, under the Total column, select the cell and type $57.97.

    The data in the dataset should look like the following table:

    Composer Item Quantity Card# CardType ExpDate Name Street CityStZip Phone Total Composer Item Quantity Card# CardType ExpDate Name Street CityStZip Phone Total
    0 Schubert String Quartets Nos. 4 & 14 1 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $19.99 0 Schubert String Quartets Nos. 4 & 14 1 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $19.99
    1 Schubert String Quartets Nos. 4 & 14 2 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $19.99 0 Schubert String Quartets Nos. 4 & 14 1 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $38.98
    2 Schubert String Quartets Nos. 4 & 14 3 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $19.99 0 Schubert String Quartets Nos. 4 & 14 1 1234567890 Visa 09/09 Trent Culpito 75 Wall St. Ny, Ny 12212 212-552-1867 $57.97
  10. On the Test dataset tab, click X to close the dataset editor, and then click Yes to save the changes you made to the dataset.

Advance to Lesson 6: Play back the test.