DbNavigator is a data bound control which makes it easier to navigate over the records of a data source. A user can move to the first, last, previous, next record or perform common actions such as updating and refreshing the data source. The C1DbNavigator class provides various properties to set the Orientation, Location, Size and Styles for the control. It also includes several events for controlling its behavior when any of the buttons are clicked, for example, if the current row or fields have been changed in the record, an exception is thrown or if the visual property style has been changed.

// C1DbNavigatorクラスを使用してコントロールを初期化します
c1dbNavigator1 = new C1.Win.Input.DbNavigator.C1DbNavigator();
// フォームにコントロールを追加します
Controls.Add(c1dbNavigator1);
c1dbNavigator1.Location = new System.Drawing.Point(283, 199);
c1dbNavigator1.Size = new System.Drawing.Size(300, 50);
c1dbNavigator1.Dock = System.Windows.Forms.DockStyle.None;
// DbNavigatorコントロールを強調するために背景色を追加します
c1dbNavigator1.BackColor = Color.LightGray;

Elements

DbNavigator comprises of below mentioned items:

First button: This button moves to the first row in the record.

Previous button: This button moves to the previous row in the record.

TextBox: This is the area where the current row number of the record gets displayed.

Next button: This button moves to the next row in the record.

Last button: This button moves to the last row in the record.

Add button: This button adds a new row to the record.

Delete button: This button deletes a row in the record.

Apply button: This button applies the changes made in the record.

Cancel button: This button cancels the changes.

Refresh button: This button refreshes the record.

Data Binding

Binding a control with a data source gives you the ability to communicate and even update the underlying data through the control. DbNavigator can be bound to a data source using DataSource property of C1DbNavigator class. Here, a data source containing employee data is bound to DbNavigator control. It becomes very easy to quickly navigate between employee's data, add or delete any data entries and update the data source by using navigation buttons.

Type your example code here. It will be automatically colorized when you switch to Preview or build the help system.

Back to Top

Add Items to DbNavigator

DbNavigator control consists of various items like first button, last button, apply button, label, editor, separator etc. These items can be added, edited or removed from the control by using the respective classes like NavFirstButton for first button, NavSeparator for separator, NavLabel for label etc.

// DbNavigatorでさまざまなアイテムを初期化します
NavFirstButton navFirstButton1 = new NavFirstButton();
NavPrevButton navPrevButton1 = new NavPrevButton();
NavSeparator navSeparator1 = new NavSeparator();
NavEditor navEditor1 = new NavEditor();
NavLabel navLabel1 = new NavLabel();
NavSeparator navSeparator2 = new NavSeparator();
NavNextButton navNextButton1 = new NavNextButton();
NavLastButton navLastButton1 = new NavLastButton();
NavSeparator navSeparator3 = new NavSeparator();
NavAddButton navAddButton1 = new NavAddButton();
NavDeleteButton navDeleteButton1 = new NavDeleteButton();
NavSeparator navSeparator4 = new NavSeparator();
NavApplyButton navApplyButton1 = new NavApplyButton();
NavCancelButton navCancelButton1 = new NavCancelButton();
NavRefreshButton navRefreshButton1 = new NavRefreshButton();

// ItemsプロパティとAddメソッドを使用して、DbNavigatorコントロールにさまざまなアイテムを追加します
c1dbNavigator1.Items.Add(navFirstButton1);
c1dbNavigator1.Items.Add(navPrevButton1);
c1dbNavigator1.Items.Add(navSeparator1);
c1dbNavigator1.Items.Add(navEditor1);
c1dbNavigator1.Items.Add(navLabel1);
c1dbNavigator1.Items.Add(navSeparator2);
c1dbNavigator1.Items.Add(navNextButton1);
c1dbNavigator1.Items.Add(navLastButton1);
c1dbNavigator1.Items.Add(navSeparator3);
c1dbNavigator1.Items.Add(navAddButton1);
c1dbNavigator1.Items.Add(navDeleteButton1);
c1dbNavigator1.Items.Add(navSeparator4);
c1dbNavigator1.Items.Add(navApplyButton1);
c1dbNavigator1.Items.Add(navCancelButton1);
c1dbNavigator1.Items.Add(navRefreshButton1);

Back to Top

You can also use the collection editor of DbNavigator control to add, remove or edit items in the collection at design-time. The Collection Editor can be launched by selecting the DbNavigator control on the Form and then clicking the ellipsis next to Items in the Properties window.

If the items in the DbNavigator exceed the control's size, a 'More Items' dropdown button appears which shows the remaining items, when clicked.

Navigation

DbNavigator allows you to conveniently navigate through the data source by using the buttons to move to next, previous, first or last records. You can also add or delete data entries, apply the changes and refresh the data source.

Back to Top

Orientation

You can set the orientation of DbNavigator to vertical or horizontal by using the Orientation property. The below image shows the vertical orientation of the control.

c1dbNavigator1.Orientation = System.Windows.Forms.Orientation.Vertical;
c1dbNavigator1.Size = new System.Drawing.Size(37, 382);

Back to Top

Tooltips

DbNavigator provides the flexibility to add custom tooltips in the navigator buttons by using ToolTip property. The below image adds custom tooltip for 'Apply' button as 'Apply Changes'.

navApplyButton1.ToolTip = "Apply Changes";

Back to Top

Visibility

You can choose to show or hide any button in the DbNavigator by using Visible property. The below image shows the DbNavigator control when the Visible property of Delete button is set to False.

navDeleteButton1.Visible = false;

Back to Top