Click here to Skip to main content
Click here to Skip to main content

BindingSource and BindingNavigator in C# 2.0

, 14 Sep 2006
Rate this:
Please Sign up or sign in to vote.
In this simple article, I'd like to show how to use the new components BindingSource and BindingNavigator in C# 2.0.

Introduction

In this simple article, I'd like to show how to use the new components BindingSource and BindingNavigator in C# 2.0.

The BindingSource offers the easiest way to navigate through records in a data source. And it is designed to simplify the process of binding controls to an underlying data source. Whereas a BindingNavigator is paired mostly with a BindingSource control to move through data records on a form and interact with them. To run the application and see it in action, I added the Northwind database as installNorthwind.sql containing only the Customers table.

You can not find the Northwind and Pubs sample databases in Microsoft SQL Server 2005 because they are not installed by default. But you can download these databases from the Microsoft web site.

What is BindingSource?

The new component BindingSource in C# 2.0 is the replacement for CurrencyManager. Although you can still use the CurrencyManager, the BindingSource component is the preferred way to bind your Windows Forms controls to data sources.

It supports the bindung of control elements in a form, and can be seen as a link between a data source and a control element. It provides advantages over traditional data binding such as:

  • Encapsulates the CurrencyManager functionality, and exposes the CurrencyManager events at design time.
  • Interoperates with other data-related Windows Forms controls, i.e., the BindingNavigator and the DataGridView controls.

The default property for the BindingSource class is DataSource. The default event is CurrentChanged. The BindingSource provides a number of methods, properties, and events such as CurrentItemChanged and DataSourceChanged, that allow for customization. The Position property gets or sets the index of the current item in the underlying list. The MoveLast() method changes the current value of the Position property to the index of the last item in the underlying data source, which is equal to the value of the Count property minus 1.

For example:

//attach the BindingSource to the DataGridView.
this.customersDataGridView1.DataSource = this.customersBindingSource1;

or

//gets the total number of the items.
int count = this.flagsBindingSource.Count;

or

//gets or sets the index of the current item.
int pos = this.customersBindingSource1.Position;

or

//moves to the last item in the list.
//MoveLast() OR equivalent
this.bindingSource1.Position = this.bindingSource1.Count - 1;

More on: <A href="http://msdn.microsoft.com" runat="server">Microsoft MSDN.

Data Binding With »BindingSource« in a Windows Application

If you want to navigate through records in a data source as mentioned before, the BindingSource offers the better and easiest way to do this. You can bind a BindingSource component to the data source, and then bind, e.g., TextBox controls to the BindingSource as we will see later. We can then use the built-in navigation methods on the BindingSource such as MoveNext(), MovePrevious(), MoveFirst(), and MoveLast().

The easiest way to see the BindingSource and BindingNavigator in action is as follows: choose the menu options: Data-->Show Data Source-->Add New Data Source. After you establish the connection, choose a DataSet, and select a table, you will see in the Data Source window the table you chose. From there, now you can drag/drop the table onto the Windows Form, and you get the data from the dragged table on a DataGridView including the BindingSource, DataSet, TableAdapter, and BindingSource automatically.

But we want to go another way which I think is the better way to understand and see how BindingSource and BindingNavigator work together.

First drag/drop five TextBoxes, six Labels, four Buttons, and a BindingSource from the Toolbox onto the form.

BindingSource

Now we have to adjust the two properties for the objects to find the data source clearly, which are:

  • DataSource
  • DataMember

After setting the DataSource in the Properties window, click "Add Project Data Source..."

BindingSource

In the next dialog window, you choose the database, and click Next.

BindingSource

Through the Next button, you come to a new dialog. Here you search for an available database connection, or you create a new connection.

BindingSource

After you click the Next button, you will get the following dialog where you choose your database object, in other words: you choose here the table "Customer" and tick it, and click the Finish button.

BindingSource

Now, you have created and added, as you can see, a new typed DataSet "northwindDataSet". Mark the DataMember in the Properties window, and click the "Customers" table. Now, an of TableAdapter is created. A TableAdapter is similar to a DataAdapter, but related to a DataTable. For example: if it describes the table "Customers", then the name of the TableAdapter is customersTableAdapter; for the table "Authors", the name would be authorsTableAdapter etc.

Now you have to combine all the control elements (TextBoxes) with the BindingSource object. You can do this in the Properties window entry "DataBinding" of each TextBox.

BindingSource

You mark textBoxCustId and extend the "DataBinding" entry in the Properties window. Click Text, and then choose here the column "CustomerID". Combine textBoxCompanyName with the column "CompanyName" and so on.

At this point, we have completed binding all the TextBox controls to the BindingSource.

Navigation methods of the BindingSource

MoveNext(), MovePrevious(), MoveFirst(), and MoveLast()

Here are the event handlers for the Click events of the buttons (Next, Previous, First, Last) for navigation.

Next button:

private void btNext_Click(object sender, EventArgs e) 
{
   if (this.bindingSource1.Position + 1 < this.bindingSource1.Count)
   {
     this.bindingSource1.MoveNext();
     this.fnDisplayPosition();
   } 
}

Previous button:

private void btPrevious_Click(object sender, EventArgs e)
{
  this.bindingSource1.MovePrevious();
  this.fnDisplayPosition();
}

First button:

private void btFirst_Click(object sender, EventArgs e)
{
  this.bindingSource1.MoveFirst();
  this.fnDisplayPosition();
}

Last button:

private void btLast_Click(object sender, EventArgs e)
{
  this.bindingSource1.MoveLast();
  this.fnDisplayPosition();
}

Display the position of the current record:

private void fnDisplayPosition()
{
    this.labelPosition.Text = this.bindingSource1.Position + 
         1 + " of " + this.bindingSource1.Count;
}

You can run the application, and the four navigation buttons should function now. But we have not implemented the BindingNavigator yet.

What is BindingNavigator?

The BindingNavigator control represents a standard way to navigate and manipulate data on a form. It is a special-purpose ToolStrip control for navigating and manipulating controls on the Windows Form.

In most cases, a BindingNavigator is combined with a BindingSource control to move through data records on a Windows Form. It is easy to modify the BindingNavigator component if you want to add additional or alternative commands for the user.

A BindingNavigator is:

  • a VCR (video-cassette recorder) control which is used with BindingSource.
  • based on ToolStrip.
  • extensible and pluggable.

Now, from the Toolbox, drag/drop a BindingNavigator onto the Form, and the Windows Forms Designer puts it by default on the top automatically.

BindingNavigator

And at last, that brings us to our final operation. The BindingNavigator still does not know where the data source is. We have to show the BindingNavigator where its data source is. Mark bindingNavigator1 on the Form1[Design] and set the BindingNavigator control's BindingSource property to the BindingSource (here: bindingSource1) on the Form.

BindingNavigator

Now the BindingNavigator is ready to do its task as a link between the data source and the control elements.

And..

If you want to dig into the other features of BindingNavigator and BindingSource, there are enough resources on the web. And I would particularly recommend the <A href="http://msdn.microsoft.com" runat="server">Microsoft MSDN web site.

I wish the article was a bit helpful.

Happy programming.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Huseyin Altindag
Software Developer (Senior)
United Kingdom United Kingdom
No Biography provided

Comments and Discussions

 
Questionproblem with binding navigator in multicolumncombo Pinmemberfatemehsoleimani21-Oct-14 4:18 
GeneralMy vote of 5 PinmemberMember 804174613-Jun-12 2:53 
GeneralMy vote of 4 PinmemberMiriBosi8-Mar-12 1:30 
GeneralMy vote of 5 Pinmemberpedu122-Jan-12 9:10 
GeneralMy vote of 5 Pinmembershashank kulshrestha14-Jul-11 2:03 
GeneralMy vote of 5 PinmemberRockingDownTheHighway8-Nov-10 9:25 
Generalgood Pinmemberchenlulouis28-Jun-10 16:35 
GeneralUsing The Buttons To Duplicate BindingSource and BindingNavigator Functionality Pinmemberjowecape7-Dec-09 19:16 
GeneralIt's not necessary to call fnDisplayPosition in every methods MoveXXX() PinmemberTri Viet Aptech1-Sep-09 22:38 
QuestionHow to bind list object to Binding Source PinmemberZeeshan Riaz17-Jul-09 13:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.141022.2 | Last Updated 14 Sep 2006
Article Copyright 2006 by Huseyin Altindag
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid