C# Datset with OLEDB Data Provider

The DataSet in ADO.NET holds a copy of the data retrieved through the SQL statement or query. It represents a comprehensive set of data that includes the tables, their order, constraints, and relationships between the tables.

OleDbDataAdapter Class

When working with the DataSet, you can indeed use it in combination with the OleDbDataAdapter Class. The OleDbDataAdapter facilitates the communication between the data source and the DataSet when using an OLEDB provider.

Full Source C#
using System; using System.Data; using System.Data.OleDb; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string connetionString = null; OleDbConnection connection ; OleDbDataAdapter oledbAdapter ; DataSet ds = new DataSet(); string sql = null; int i = 0; 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; i <= ds.Tables[0].Rows.Count - 1; i++) { MessageBox.Show (ds.Tables[0].Rows[i].ItemArray[0] + " -- " + ds.Tables[0].Rows[i].ItemArray[1]); } } catch (Exception ex) { MessageBox.Show("Can not open connection ! "); } } } }

To populate the DataTables within the DataSet with data from the data source, you can utilize the OleDbDataAdapter. It provides methods such as Fill() that retrieve data from the data source and populate the DataTables within the DataSet.

The Fill() method of the OleDbDataAdapter retrieves the data from the data source based on the provided SQL statement or query and fills the corresponding DataTables in the DataSet.

Conclusion

Using the combination of the DataSet and OleDbDataAdapter, you can effectively retrieve and store data from the data source into DataTables within the DataSet. This allows for efficient data access, manipulation, and analysis within your C# application using ADO.NET.






Related Topics
  1. What is C# ADO.NET Dataset
  2. C# Datset with Sql Server Data Provider
  3. Find Tables in a Dataset - Sql Server
  4. Find Tables in a Dataset - OLEDB
  1. How to Dataset rows count - Sql Server
  2. How to Dataset rows count - OLEDB
  3. How to find Column Definition SqlServer
  4. How to find Column Definition OLEDB
  5. How to Dyanamic Dataset in C#
  6. C# Dataset with multiple tables - Sql Server
  7. C# Dataset with multiple tables - OLEDB
  8. C# Dataset table relations
  9. C# Dataset merge tables - Sql Server
  10. C# Dataset merge tables - OLEDB
  11. Bind a dataset to a combo box in C#, bind enum to combobox , bind dictionary to combobox
  12. How to find tables in a Database in C#

Related Links
  1. How to insert image in a database
  2. How to retrieve image from database