How to Dataset with OLEDB Data Source

The DataSet in ADO.NET serves as a container that holds a copy of the data we retrieve from the data source using an SQL statement. It provides a versatile structure for working with data in a disconnected manner. When working with an OleDb data source, we can utilize the DataSet in conjunction with the OleDbDataAdapter class.


The OleDbDataAdapter object plays a crucial role in populating Data Tables within the DataSet. It acts as a bridge between the OleDb data source and the DataSet, facilitating the retrieval and manipulation of data. By utilizing the Fill method provided by the OleDbDataAdapter, we can populate the Data Tables in the DataSet with data from the data source.

To elaborate, here is an example demonstrating the usage of the OleDbDataAdapter and Fill method to populate a DataSet:

Full Source VB.NET
Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As OleDbConnection Dim oledbAdapter As OleDbDataAdapter Dim ds As New DataSet Dim sql As String Dim i As Integer connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your mdb filename;" sql = "Your SQL Statement Here" connection = New OleDbConnection(connetionString) Try connection.Open() oledbAdapter = New OleDbDataAdapter(sql, connection) oledbAdapter.Fill(ds) oledbAdapter.Dispose() connection.Close() For i = 0 To ds.Tables(0).Rows.Count - 1 MsgBox(ds.Tables(0).Rows(i).Item(0) & " -- " & ds.Tables(0).Rows(i).Item(1)) Next Catch ex As Exception MsgBox("Can not open connection ! ") End Try End Sub End Class


By utilizing the OleDbDataAdapter and Fill method, we can seamlessly populate Data Tables within the DataSet with data from the OleDb data source. This empowers us to work with the data offline and perform various operations on it.