Binding a DataSet to a Windows Forms DataGrid
DataSet and DataTable objects can be bound to Windows Forms DataGrid objects to provide an easy way to view data. This is done by calling a DataGrid object’s SetDataBinding method, passing the object that is to be bound to the grid. The syntax of the SetDataBinding method is:
Public Sub SetDataBinding( _ ByVal
dataSourceAs Object, _ ByVal
dataMemberAs String _ )
The parameters are:
The source of the data to show in the grid. This can be any object that exposes the
System.Data.IListSourceinterfaces, which includes the DataTable and DataSet classes discussed in this chapter.
If the object passed in the
dataSourceparameter contains multiple tables, as a DataSet object does, the
dataMemberparameter identifies the table to display in the DataGrid. If a DataTable is passed in the
dataMemberparameter should contain either
Nothingor an empty string.
Example 8-8 shows how to bind a DataSource object to
a DataGrid. The DataSource object contains a
Customers table and an
table, and a relation between them. The call to the DataGrid
object’s SetDataBinding method specifies that the
Customers table should be shown in the grid. Figure 8-3 shows the resulting DataGrid display.
Example 8-8. Creating a DataSet and binding it to a Windows Forms DataGrid
' Open a database connection. Dim strConnection As String = _ "Data Source=localhost;Initial Catalog=Northwind;" ...