DataGrid in VB.NET

Displaying data in a DataGrid in VB.NET

This article explains how to display data in a datagrid. Create a Windows Application. Add a DataGrid control to the form. Leave DataGrid name as DataGrid1. Add reference to System.Data.OleDb namespace as follows:

Imports System.Data
Imports System.Data.OleDb

Create a connection to a database table. Create a connection string

Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\emp.mdb"
Dim myConnection As OleDbConnection = New OleDbConnection
myConnection.ConnectionString = connString

' create a data adapter

Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from emp", myConnection)

Create a DataSet Object and Fill with the data Use Fill method of OleDbDataAdpater to fill data to a DataSet object. ' create a new dataset

Dim ds As DataSet = New DataSet

' fill dataset

da.Fill(ds, "emp")

Attach DataSet to DataGrid Now you use DataSource method of DataGrid to attached the DataSet data to the data grid. ' Attach DataSet to DataGrid

DataGrid1.DataSource = ds.DefaultViewManager

Here is entire source code written on the form load method.


Imports System.Data
Imports System.Data.OleDb

Public Class Form1
    Inherits System.Windows.Forms.Form

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ' create a connection string 
        Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\emp.mdb"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        ' create a data adapter 
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from emp", myConnection)
        ' create a new dataset 
        Dim ds As DataSet = New DataSet
        ' fill dataset 
        da.Fill(ds, "emp")
        ' write dataset contents to an xml file by calling WriteXml method 
        ' Attach DataSet to DataGrid 
        DataGrid1.DataSource = ds.DefaultViewManager
End Sub   
End Class