Change the options in the Hyperlink Column dialog. [View full size image]   TIP As you can see, the formatted string looks like the following:   employeestore_datagrid_details.aspx?ItemID={0}   This string essentially uses employeestore_datagrid_details.aspx as the page to link to. Also notice the addition of the ItemID parameter along with an array value (the index of the element within the data source) contained within a pair of braces. Because ItemID is the first field in the data source, it is said to be at index 0. The ItemID parameter is passed from the employeestore_datagrid.aspx to employeestore_datagrid_details.aspx, where the appropriate item (determined by the ItemID as part of the query string) is identified and the appropriate information is displayed on the page. 6. Click OK to close the Hyperlink Column dialog. 7. Click OK to close the DataGrid dialog. Save your work and test the results in the browser by pressing the F12 key. The result should look similar to Figure 25.58. Figure 25.58. All the item names are now linked and ready to navigate to their appropriate page. [View full size image]   Notice that the names in the ItemName column are now clickable. Roll your cursor over the product name. As you do, look in the status bar to see that the link and correct product ID are displayed. Next, let's create the employeestore_datagrid_details.aspx page: 1. Initially, you can use the original employeestore.aspx page. You'll want to remove all the dynamic elements on the page (except the DataSet and the three dynamic text elements) so that it resembles Figure 25.59. Figure 25.59. Open the original employeestore.aspx page and resave it as employeestore_datagrid_details.aspx. [View full size image] 2. Save the modified page as employeestore_datagrid_details.aspx. 3. Type the new caption Quantity under the Cost caption and drag the Quantity field from the DataSet located in the Bindings panel into the cell, next to the new Quantity caption. 4. Double-click the DataSet so that it launches the DataSet dialog in Simple mode. 5. What we have to do now is capture the ItemID being passed in the query string onto this page. We can do that by selecting ItemID from the Filter drop-down menu, choosing the = symbol, choosing URL Parameter, and then typing in the value ItemID. The result will appear similar to Figure 25.60. Figure 25.60. Configure the DataSet dialog so that it filters by the ItemID URL parameter. [View full size image] 6. Click the Test button. The Test Value dialog appears. Type an existing ItemID (such as 1) into the Test Value text box. 7. Clicking OK reveals only one record (there is only one item with the ItemID 1). 8. Click OK to close the Test SQL Statement dialog. 9. Click OK to close the DataSet dialog.