OleDbDataAdapter is a part of the ADO.NET Data Provider. OleDbDataAdapter provides the communication between the Dataset and the Data Source with the help of OleDbConnection Object. The OleDbDataAdapter works with the DataSet to provide a disconnected data retrieval mechanism.
The SelectCommand property of the OleDbDataAdapter is a Command object that retrieves data from the data source. The following program shows the OleDbDataAdapter using its SelectCommand property to retrieve the data from the Data Source.
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 New OleDbDataAdapter
Dim ds As New DataSet
Dim i As Integer
connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your mdb filename;"
connection = New OleDbConnection(connetionString)
Try
connection.Open()
oledbAdapter.SelectCommand = New OleDbCommand("Your SQL Statement Here", 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))
Next
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
End Class