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.

OleDbDataAdapter

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

Conclusion

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.






Related Topics
  1. What is ADO.NET Dataset
  2. How to Dataset with Sql Server
  3. Search Tables in a Dataset Sql Server
  4. Search Tables in a Dataset OLEDB Data Source
  1. Dataset table row count in SQL Server
  2. Dataset table row count - OLEDB Data Source
  3. How to find column definition - Sql Server
  4. How to find column definition - OLEDB Data Source
  5. How to create DataSet without Databse
  6. How to multiple tables in Dataset - Sql Server
  7. How to multiple tables in Dataset - OLEDB Data Source
  8. How to add relations between tables in a Dataset
  9. How to merge tables in a Dataset - Sql Server
  10. How to merge tables in a Dataset - OLEDB Data Source
  11. How to populate a combo box from a dataset in VB.Net
  12. How many tables exist in a database - VB.NET

Related Links
  1. Insert image in a database in VB.NET
  2. Retrieve image from database in VB.NET