DataAdapter Select Command - Sql Server

The OleDbDataAdapter is an essential component of the ADO.NET Data Provider, responsible for facilitating communication between the Dataset and the Data Source through the OleDbConnection Object. It plays a crucial role in establishing a connection and retrieving data from the data source, while seamlessly working with the DataSet to provide a disconnected data retrieval mechanism.

OleDbDataAdapter

The SelectCommand property of the OleDbDataAdapter represents a Command object that retrieves data from the data source. By utilizing the Fill method, the OleDbDataAdapter populates a DataSet with the data obtained from the SelectCommand. The Fill method requires arguments such as a DataSet to be populated and a DataTable object (or the name of the DataTable) that will be filled with the rows returned from the SelectCommand. These features enable efficient data retrieval and population within the DataSet, ensuring effective management and manipulation of data.

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 = new OleDbDataAdapter(); DataSet ds = new DataSet(); int i = 0; 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; i <= ds.Tables[0].Rows.Count - 1; i++) { MessageBox.Show (ds.Tables[0].Rows[i].ItemArray[0].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }





Related Topics
  1. How to DataAdapter in Sql Server
  2. How to DataAdapter in OLEDB
  3. How to DataAdapter Select Command - Sql Server
  4. How to DataAdapter Insert Command - Sql Server
  1. How to DataAdapter Insert Command - OLEDB
  2. How to DataAdapter Update Command - Sql Server
  3. How to DataAdapter Update Command - OLEDB
  4. How to DataAdapter Delete Command - SQL SERVER
  5. How to DataAdapter Delete Command - OLEDB
  6. How to DataAdapter CommandBuilder in Sql Server
  7. How to DataAdapter CommandBuilder in OLEDB
  8. How to DataAdapter DataGridView - Sql Server
  9. How to DataAdapter DataGridView - OLEDB

Related Links
  1. C# DataAdapter.Fill
  2. Selected range of records from database | C#