Technical Training
VB.NET 2005Simple Data Binding
VB.NET 2005 Tutorials: Simple Data Binding
In Section 1 of Data Binding you will learn about definition of Data Binding Bindable Entities, The Architecture of Data Binding, Bind Data to the User Interface and Simple Data Binding
Data Binding
The process of binding a control to a data source is called data binding. Visual Studio 2005 includes several new features to assist in developing applications that access data. The Data Source Configuration Wizard simplifies connecting the application to data in databases, Web services, and user-created objects. The new Data Sources window provides a centralized view of the data available to the project, and it reduces the complexity of data binding by allowing the user drag items from the window onto forms to create data-bound controls. Filling datasets, running queries, and executing stored procedures can be accomplished using the new Visual Studio-generated TableAdapter object. The new local data feature allows the user include Microsoft SQL Express and Microsoft Access database files, directly in to the application.
Windows Forms can take advantage of two types of data binding: simple binding and complex binding. Each offers different advantages. We will look at them a little later in this lesson.
Bindable Entities:
Binding data to form controls allows the user access data from databases as well as data in other structures, such as arrays and collections which support IList interface. The data providers for other objects in .NET Frameworkare listed below:
-
Array or collection that implement IList interface.
. -
ADO .NET objects
-
DataColumn object. The users can simple-bind a control (such as a TextBox control's Text property) to a column within a data table.
. -
DataTable object. The user can complex-bind a control to the information contained in a data table (such as binding the DataGrid control to a data table) using the default view of the DataTable.
. -
DataView object. The users can simple- or complex-bind to the data within a data view. However this provides a fixed snapshot of the data.
. -
DataSet object. The users can simple- or complex-bind to the data within a dataset using the default view.
. -
DataView Manager Object. It functions like DataView, with a difference that this snapshot comes with relationships that exists between the tables as seen in a DataSet.
-
The Architecture of Data Binding
-
Create Connection Object. The connection that the users create, forms the basis for all other activities. In doing so the user creates a connect string and also a connection object that provides connection to the database.
. -
Create DataSet and DataAdapter. Then the user proceeds to set the Data Binding property of the text box. At this stage the Visual Studio creates a DataSet and a DataAdaptor. The “Select ... “ statement for creating the DataSet is also autogenerated based on the selections the user has made in the Data Source configuration wizard.
. -
Call the fill method of the DataAdapter to fill the dataset. This also adds a line of code that fills the dataset using the data adapter and the connection object . At the end of it all the data from the selected data source is available for the control when the form loads.
Having said all that, let us now see how simple binding and complex binding of data to controls is accomplished.
Bind Data to the User Interface
Simple Data Binding
Simple data binding is the ability of a control to bind to a single data element--such as a value in a column in a dataset table. This is the type of binding typical for controls typically display a single value such as a System.Windows.Forms.TextBox control or System.Windows.Forms.Label control. In fact, any property on a control can be bound to a field in a database. Let us create a sample to understand the concept better.
1. Create a new Windows Application project in Visual Basic 2005 IDE .
2. Press Ctrl + Alt + S to open the Data Explorer if it is not seen docked to the top left hand side corner of the window. The screenshot below shows the Database Explorer.

3. Click on the “Connect to Database” icon on the left window pane, to open the dialog box. Choose option Database. In the dialog box “Choose Data Source”, select Microsoft SQL Server Database File and click continue as shown below:

4. The “Add Connection” dialog box opens. Click on the Browse button to choose the Database file. Now click on “Test Connection”. The user will get a message box saying “Connection Successful”. Click on OK to add the database.

5. The user will see a new connection added in the database explorer:

6. Add a TextBox to the form and also a button which we will use for closing the application. The window will look like the screenshot shown below:

7. Add a BindingNavigator from the toolbox to the
form. In the property window set the value for property ‘Dock as Bottom’. Set
the Text property of the Button1 to Exit. Add the following code to the click
event of the button.
Me.Close()
The window will look like the screenshot shown below:

VB.NET 2005
- VB.NET 2005 Free Training
- The .NET Framework Architecture Part 1
- The .NET Framework Architecture Part 2
- Application Class and Message Class
- Implementing Class Library Object
- Visual Studio.NET Namespaces
- .NET Assemblies
- Differences between VB.NET 1.0 and VB.NET 2.0
- Introducing VB.NET Windows Forms
- Visual Studio Windows Forms Designer
- Exploring the Forms Designer generated code
- Setting and Adding Properties to Windows Form
- Implementing Inheritance
- Event Handling In Visual Basic .NET
- Building Graphical Interface elements
- .NET Common Windows Forms Controls Part 1
- .NET Common Windows Forms Controls Part 2
- Common Controls and Handling Control Events
- DomainUpDown and NumericUpDown Controls
- Dialog Boxes in Visual Basic .NET
- Visual Studio Adding Controls to Windows Form
- VB.NET Validation Controls
- Working with Menu Controls
- VB.NET MDI Applications
- .NET Exceptions
- VB.NET Creating and Managing Components Part 1
- VB.NET Creating and Managing Components Part 2
- Simple Data Binding
- .NET Complex Data Binding
- .NET Data Form Wizard
- Data Manipulation with ADO.NET
- SQL Server Stored Procedures
- SQL Server Ad Hoc Queries
- Finding and Sorting Data in DataSets
- ADO.NET Object Model
- Working with DataSets
- Using XML Data
- Working with File System in .NET
- Creating Web Service
- Instantiating - Invoking Web Services, Creating Proxy Classes with WSDL
- Web Reference and Web Services
- Web Services - SOAP, WSDL, Disco and UDDI
- Web Application Testing in VB.NET 2005
- Web Application Tracing and Debugging
- Working with Legacy Code and COM Components
- ActiveX Controls and Legacy Code
- Windows Application Testing
- VB.NET Windows Application Testing
- Tracing VB.NET Windows Application
- Debugging Windows Applications In Visual Studio.NET 2005
- Deploying Windows Applications In Visual Studio.NET 2005
- Customizing Setup Project in Visual Studio.NET 2005
- Shared Assembly
- Microsoft .NET Creating Installation Components
- The Registry Editor in Visual Studio.NET 2005
- The File Types Editor







