If the Data Sources window is not visible, click Show Data Sources on the Data menu.

Click Add New Data Source to start the Data Source Configuration Wizard.

Select Database and then click Next.

Select a data connection to the Northwind sample SQL Server database, or add a new connection by using the New Connection button.

After selecting or creating a connection, click Next.

Clear the option to save the connection if it is selected, and then click Next.

Expand the Tables node in the Database objects window.

Select the Orders table and the Order Details table.

Click Finish.

Verify that the My Master-Detail.xls workbook is open in the Visual Studio designer, with Sheet1 displayed.

Open the Data Sources window and expand the Orders node.

Select the OrderID column, and then click the drop-down arrow that appears.

Click NamedRange in the drop-down list, and then drag the OrderID column to cell A2.

A NamedRange control named OrderIDNamedRange is created in cell A2. At the same time, a BindingSource named OrdersBindingSource, a table adapter, and a DataSet instance are added to the project. The control is bound to the BindingSource, which in turn is bound to the DataSet instance.

Scroll down past the columns that are under the Orders table. At the bottom of the list is the Order Details table; it is here because it is a child of the Orders table. Select this Order Details table, not the one that is at the same level as the Orders table, and then click the drop-down arrow that appears.

Click ListObject in the drop-down list, and then drag the Order Details table to cell A6.

A ListObject control named Order_DetailsListObject is created in cell A6, and bound to the BindingSource.

From the Common Controls tab of the Toolbox, add a Button control to cell A3 of the worksheet.

This button is named Button1.

Add another Button control to cell B3 of the worksheet.

This button is named Button2.

Select NorthwindDataSet in the component tray.

In the Properties window, change the Modifiers property to Public.

Datasets must be public before caching is enabled.

Change the CacheInDocument property to True.

In Solution Explorer, right-click Sheet1.vb or Sheet1.cs, and then click View Code on the shortcut menu.

Add the following code to the Sheet1_Startup method to set the text for the buttons.

Me.Button1.Text = "<"
Me.Button2.Text = ">"

this.button1.Text = "<";
this.button2.Text = ">";

For C# only, add event handlers for the button click events to the Sheet1_Startup method.

this.button1.Click += new EventHandler(button1_Click);
this.button2.Click += new EventHandler(button2_Click);

Add an event handler for the Click event of Button1, and add the following code to move backwards through the records:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
    Handles Button1.Click

    Me.OrdersBindingSource.MovePrevious()
End Sub

private void button1_Click(object sender, EventArgs e)
{
    this.ordersBindingSource.MovePrevious();
}

Add an event handler for the Click event of Button2, and add the following code to advance through the records:

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
    Handles Button2.Click

    Me.OrdersBindingSource.MoveNext()
End Sub

private void button2_Click(object sender, EventArgs e)
{
    this.ordersBindingSource.MoveNext();
}

Press F5.

Verify that the named range and the list object are filled with data from the data source.

Scroll through some of the records by clicking the buttons.

Save the workbook, and then close the workbook and Visual Studio.

Disable the connection to the database. Unplug the network cable from your computer if the database is located on a server, or stop the SQL Server service if the database is on your development computer.

Open Excel, and then open My Master-Detail.xls from the \bin directory (\My Master-Detail\bin in Visual Basic or \My Master-Detail\bin\debug in C#).

Scroll through some of the records to see that the worksheet operates normally when disconnected.

Reconnect to the database. Connect your computer to the network again if the database is located on a server, or start the SQL Server service if the database is on your development computer.