Web Part connections

In the current version of the Data Viewer Web Part you can only connect Data Viewer Web Parts that use Microsoft® SQL Server® databases as data sources. Commonly Web Part connections are used for Master/Child or Summary/Details relationships, For example, connected a Data Viewer Web Part that displays Suppliers to another instances of the Data Viewer Web Part which displays products, so that when a supplier is selected in the Suppliers Web Part, the products that the supplier sells is displayed in the Products Web Part.

To connect the Data Viewer Web Part to consume data from another Web Part, complete the following steps:

1. Place the page in edit mode.
   
   
2. Add two Web Parts to the page.
   
   
3. Configure the two Web Part to point to the relevant Microsoft SQL Server® database tables/views/stored procedures, select the columns that the Web Parts need to display and any formatting your require.
   
   
4. Configure the two Web Parts to use linking.
   
   
5. From the Data Viewer Web Part menu, click Connections and then click either Send Key Value to or Get Key Value From and then select the other Web Part on the page. You can configure Web Part connections from the master Web Part (Suppliers) to the child Web Part (Products) or from the child Web Part (Products) to the master (Suppliers).
   

• If you choose to configure Web Part connections from the master content (Suppliers) to the child content (Products), select Send Key Value to.
  
  
• If you choose to configure Web Part connections from the Web Part that is displaying the child content to the master content, select Get Key Value From.
  
  
  

*You must have configured Linking on the Display tab to a column that contains the data your wish to send or receive from the other Web Part.

For example, when you are creating a Master/Child relationship where on a page you configure one Data Viewer Web Part to display data from the Suppliers table, and in another Data Viewer Web Part you display data from the Products table, and there is a 1 to Many relationship between the two tables. Then in the Data Viewer Web Part that displays Suppliers configure the Supplier ID column (often known as the primary key) as the link from Suppliers table and in the other Web Part configure the Supplier ID column (often known as the foreign key) from Products table. Then the correct columns are linked when the Web Part connections is configured between the two Web Parts.