Implementing Simple Data Binding in visual basic .Net

Navigating between Records

For every data source that is bound to a Windows Form control, there exists a CurrencyManager object. The CurrencyManager object handles the binding to the data source by keeping a pointer to the current item in the record list.

The CurrencyManager class is derived from the BindingManagerBase class. If all the Windows Form controls are bound to a single data source, the form will have one CurrencyManager object associated with it.

A BindingContext object, which is a Windows Form object, is used to keep track of the existing CurrencyManager objects in a form.

A Windows Form containing bound controls has at least one BindingContext object that keeps track of one or more CurrencyManager objects, each in turn keeping track of a data source. The figure given below illustrates the relationship between the BindingContext class, CurrencyManager class, and a Windows Form:

Relationship between the BindingContext class, CurrencyManager class and a Windows Form

Fig:- 1.1. Relationship between the BindingContext class, CurrencyManager class and a Windows Form.

Design a Windows Form to display Data.

To design a Windows Form for displaying Data, retrieved from a SQL Server database, perform the following steps:

Create a new Visual Basic Windows Application project by clicking the New project button in Microsoft Development Environment. Form1 is added to the project by default. Name the form as FrmView.

-Select View from the menu bar, and then select ToolBox from the View menu. The Toolbox is displayed.
-From the Windows Forms tab of the Toolbox, drag five label controls and five Textbox controls, to the form.
-Set the Text property of the label controls as displayed in the following table:

Label Text Property
Label1 Customer ID
Label2 Company Name
Label3 Contact Name
Label4 Address
Label5 City

Drag four Button controls to the form. Set the Name and Text property for each button as displayed in the following table:

Button Name Text
Button1 bnfirst First
Button2 bnprev Previous
Button3 bnnext Next
Button4 bnlast Last

A Sample Designed Form is displayed below.

Windows Form

Fig:- 1.2. A Sample Designed Windows Form.

Connect to Database

Connecting to the NorthWind SQL Server database involves creating a connection, a data adapter, and a dataset. To connect to the SQL Server database, perform the following steps:

  1. Create a DataAdapter named SqlDataAdapter1 through the wizard.
    1. On the second screen of the wizard, click the New Connection button and establish a connection with NorthWind SQL Server database.
    2. Add the table Customers and select all its fields for the Select command in Query Builder.
  2. Generate a new Dataset DSCust1.

For steps on creating a connection, a data adapter, and a dataset using a wizard Click Here.

Make the following declaration at the Form level:

Dim bm as BindingManagerBase

In this example, a BindingManagerBase class object bm is declared. The object bm is initialized by using the BindingContext() method of the form. The position property of BindingManagerBase class is set to 0, which displays the first row of the DataTable Customer. You can change the value of the position property to specify the row of the DataTable to be bound to the controls.

You will use the BindingManagerBase class and the BindingContext() method to navigate through the records.

Code for the Load event of the form:

Dim bm As BindingManagerBase
Private Sub Frmview_Load(ByVal sender As Object,
	ByVal e As System.EventArgs) Handles MyBase.Load
  bm = Me.BindingContext(DsCust1, "Customers")
  bm.Position = 0
End Sub

The statement SqlDataAdapter1.Fill(DsCust1) populates the dataset with the records from the Customers table.

Write the following code for navigating through the data.

Private Sub bnnext_Click(ByVal sender As Object,
	ByVal e As System.EventArgs) Handles bnnext.Click
 bm.Position += 1
End Sub

Private Sub bnlast_Click(ByVal sender As Object,
		 ByVal e As System.EventArgs) Handles bnlast.Click
 bm.Position = bm.Count - 1
End Sub

Private Sub bnprev_Click(ByVal sender As Object,
		ByVal e As System.EventArgs) Handles bnprev.Click
 bm.Position -= 1
End Sub

Private Sub bnfirst_Click(ByVal sender As Object,
		ByVal e As System.EventArgs) Handles bnfirst.Click
 bm.Position = 0
End Sub

Bind the data to a Windows Form Control

Make the Text property under the Appearance category blank for all the TextBox controls. Expand the DataBinding property under the Data category. When the Text property is clicked, a down arrow is displayed. Clicking on the down arrow displays a list of datasets and the corresponding tables. The tables contain the existing column names.

The column names to be selected from the table Customers for the text property of each of the TextBox controls.

To view the bound data, select Debug from the menu bar. Then, select Start from the Debug menu. You can also run the application by clicking the Start icon on the standard toolbar.

Records from the Customers table are displayed. You can navigate through the records by using the First, next, and Previous buttons.

cover image of azure cloud book

Develop Azure Applications

Azure Cloud is gaining popularity and is competing with Amazon Elastic Cloud and Google Cloud for a spot in the billion dollar Cloud computing space.

With this book learn how to use - Table (an Azure Table is different from a SQL Server Table), Queue, Blob storage services, use your local machine to create an Application and a Service, how Azure splits a Table to achieve Load Balancing, Scalability based on the Partition Key, AppFabric Service Bus, Access Control Service, role of Fabric Controller, features of Azure SQL Database and Content Delivery Network.

Many have mastered Cloud Programming and are enjoying the benefits. Why not you?

View Highlights » View Contents »
cover image of foundation database programming book

Create your Own Accounting Software

A foundation book to Master Accounting Software Development, VB.Net, C# and OOPs programming. Detailed explanation of the Accounting domain for programmers is included. SQL and ADO.Net is also covered in detail.

This book gives you a strong foundation in Application Development.

A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. This is because, the accounting domain is dealt with great detail in this book.

The ideal book to get started with application development in the .Net world.

View Highlights » View Contents »

cover image of book

Create your Own WEB ERP Software using ASP.Net

This book opens you to the Web. Using ASP.Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. You will learn implementing inline GridView control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component.

Opens you to a world of opportunities. You will be able to develop a Web ERP application including all the five modules and learn how to use the TreeView control and GridView control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice.

View Highlights » View Contents »
cover image of entity framework book

ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015

Entity frameworks is the latest buzz in .Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. Learn to integrate EF into an ASP.Net Application and MVC application. Create, explore and query the Entity Data Model. Learn how to use ObjectDataSource control and GridView control in an ASP.Net Application.

Also, learn to build Three-Tier ASP.Net application, create a business-class, implement methods in the class to perform CRUD operations and bind a GridView to the ObjectDataSource control. Learn how to handle concurrency and managing Transactions.

View Contents »