spacer
spacer

Visual Basic & VB.NET resources | VBprofs.com

Google
 
Main Menu
Home
IT News
Articles
Source Codes
Books
Calendar of Events
Publish your Content
Links Directory
Reviews and Recs
Premium Content
 VBprofs Premium Content Become a member to get access to our premium content! 

 Membership is entirely free, and allows you to:
  •  access programming projects posted by our partners;
  •  publish your articles, news, links;
  •  publish a project request;
  •  access our VB Careers section.
Polls
How did you reach VBprofs.com?
  
Which is your favorite programming language?
  
Related Items
 
Home arrow Articles arrow Visual Basic / .NET Articles arrow Data Binding in TierDeveloper

Data Binding in TierDeveloper PDF Print E-mail
Articles - Visual Basic / .NET Articles
Written by Ann Morris   
.NET
INTRODUCTION

One of the most powerful aspects of .NET and Windows Forms is data binding. Data binding is the process of associating user interface (UI) elements with a data source to generate a visual representation of data. Two types of data binding are available for Windows Forms: Simple Data Binding and Complex Data Binding.

Simple data binding allows you to bind one data element to a control. In many situations you want to display only one record at a time e.g., customer’s personal information. Textboxes and labels are such controls that are used for this purpose and hence called simple binding.


Complex data binding allows you to bind more than one data element to a control. For example if you want to display number of orders placed by a customer you would use controls like data grid controls, list boxes.


The data binding capabilities of .NET are similar to ADO and the Visual Basic controls. Visual Basic or Delphi users will find .NET data binding more flexible and more transparent. It saves a lot of time in both Windows Forms and ASP.NET applications.


How to Bind TierDeveloper DataSet to Data Grid Control


Assumptions

  1. You are using TierDeveloper’s sample project “TDevStoreSQL.tier” and you’ve defined a query method “GetAllCustomers” for the object “Customers”.
  2. You have generated the components and Windows Forms Application from TierDeveloper.
  3. You have access to a database, such as Microsoft SQL Server™ or Microsoft Access.
In order to bind Data Grid please follow these steps: 


1. Open the TierDeveloper generated project in VS.NET

2. Add and open a new Windows Form.

3. Select the ToolBox window and click on Windows Forms tab.

4. Drag DataGrid component and place it anywhere on the Windows Form.

5. Paste the following code in the Windows Form Load event.

[Visual Basic]

Private Sub CustomersForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load



Dim cf As CustomersFactory = New CustomersFactory

DataGrid1.CaptionText = "Customers"

DataGrid1.DataSource = cf.GetAllCustomersDS()



End Sub

[C#]

Private void CustomersForm_Load(object sender, System.EventArgs e)

{



CustomersFactory cf = New CustomersFactory();

DataGrid1.CaptionText = "Customers" ;

DataGrid1.DataSource = cf.GetAllCustomersDS();



}

6. The postfix DS shows that this method will return a DataSet object.

7. Run the application and you will see that the DataGrid is filled with all the customers.

Note: You can also bind datagrid to customer collection to do this you will just have to change the grid data source to the method that can return collection.

DataGrid1.DataSource = cf.GetAllCustomers();


About The Author

I am Ann Morris and work in Software development consultancy company.

< Prev   Next >

 
Antivirus Shop
BitDefender Antivirus v10
Newsflash

PowerRefresh 1.0 released!
A simple yet extremely useful tool for webmasters, publishers and SEO working bees: PowerRefresh allows you to automatically refresh your IE windows every x minutes. It can handle unlimited number of windows and, unlike similar applications, is using full browsers.


Get PowerRefresh from Kaloyani.com: download
Login Form
Username

Password

Remember me
Forgotten your password?
No account yet? Create one
Popular

VBprofs.com - online resources for Visual Basic and VB.NET professionals: Visual Basic and VB.NET articles, industry news and events, career tools, VB / VB.NET books, calendar and much more. VBprofs.com is an interactive web site with free membership.
(c) Copyright 2005 - 2006 by VBprofs.com
powered by Mambo Open Source Software
spacer