ADO.NET 3.5 Cookbook, 2nd Edition

8.16. Using Windows Forms BindingNavigator and BindingSource Controls

Problem

You want an easy way to navigate and interact with records in a result set.

Solution

Use a BindingNavigator control that is bound to a BindingSource component. Bind the data controls to the BindingSource component by adding DataBinding objects.

Follow these steps:

1. Create a C# Windows Forms application, BindWindowsFormBindingNavigator.

2. Add the following controls to the Form1 design surface:

   • BindingNavigator named departmentBindingNavigator

   • BindingSource named departmentBindingSource

   • Label with Text property = DepartmentID:

   • TextBox named departmentIDTextBox

   • Label with Text property = DepartmentName

   • TextBox named departmentNameTextBox

   The completed layout of the Windows Form named Form1 is shown in Figure 8-31.

The C# code in Form1.cs in the project BindWindowsFormBindingNavigator is shown in Example 8-28. The solution fills a DataTable from the HumanResources.Department table in AdventureWorks and binds it to the data source of the BindingSource control. The BindingSource property of the BindingNavigator is set to the BindingSource control. The TextBox controls—departmentIDTextBox and departmentNameTextBox—are bound to the BindingSource control.

Figure 8-31. Layout for Form1 in BindWindowsFormBindingNavigator solution

Example 8-28. File: Form1.cs for BindWindowsFormBindingNavigator solution

using System; using System.Data; ...