ODBCDataAdapter

Public Constructors

• ODBCDataAdapter() Constructs a new instance of the ODBCDataAdapter class.
• ODBCDataAdapter(OdbcCommand selectCommand) Initializes a new instance of the ODBCDataAdapter class with the specified System.Data.Odbc.OdbcCommand.
• ODBCDataAdapter(string selectCommandText, string connectionString) Initializes a new instance of the ODBCDataAdapter class with the specified SQL statement and connection string.
• ODBCDataAdapter(string selectCommandText, OdbcConnection connection) Initializes a new instance of the ODBCDataAdapter class with the specified SQL statement and OdbcConnection.

Public Properties

• AcceptChangesDuringFill (bool) Gets or sets a value that indicates whether AcceptChanges() is called by the Fill() method.
• DeleteCommand (OdbcCommand) Gets or sets an OdbcCommand used to delete records in the data source.
• InsertCommand (OdbcCommand) Gets or sets an OdbcCommand used to insert new records in the data source.
• SelectCommand (OdbcCommand) Gets or sets an OdbcCommand used to retrieve records from the data source.
• UpdateCommand (OdbcCommand) Gets or sets an OdbcCommand used to update records in the data source.

Public Methods

• Fill(DataSet dataSet) Adds or refreshes rows in the DataSet to match those in the data source using the specified System.Data.DataSet.
• Update(DataSet dataSet) Applies all updates to the data source.

Protected Methods

• CreateDbCommand() Creates and returns a compatible ADO.NET command object.

Remarks

The ODBCDataAdapter class provides a way to interact with ODBC data sources. It can be used to fetch data from a database into a DataSet, and then to send any changes made to the DataSet back to the database.

When you create an instance of ODBCDataAdapter, you typically specify the SQL query to retrieve data (using the SelectCommand property) and optionally commands for inserting, updating, and deleting data.

The Fill() method populates a DataSet with the results of the SelectCommand. If the DataSet already contains tables with the same names as the tables returned by the query, the new rows are appended to the existing tables.

The Update() method processes changes made to the rows within the DataSet and applies them to the data source using the InsertCommand, UpdateCommand, and DeleteCommand properties. The adapter determines which command to execute for each modified row based on its RowState.

The AcceptChangesDuringFill property controls whether the AcceptChanges() method is automatically called on the DataSet after the Fill() operation. If true, changes are accepted, and rows are marked as unchanged. If false, changes remain, and rows are marked as modified.

Example

The following example demonstrates how to use the ODBCDataAdapter to retrieve data from an ODBC data source and populate a DataSet.

using System;
using System.Data;
using System.Data.Odbc;

public class OdbcDataAdapterExample
{
    public static void Main(string[] args)
    {
        string connectionString = "DSN=MyOdbcDataSource;Uid=myUser;Pwd=myPassword;";
        string selectQuery = "SELECT CustomerID, CompanyName FROM Customers";

        using (OdbcConnection connection = new OdbcConnection(connectionString))
        {
            try
            {
                connection.Open();
                Console.WriteLine("Connection opened successfully.");

                using (OdbcDataAdapter adapter = new OdbcDataAdapter(selectQuery, connection))
                {
                    DataSet dataSet = new DataSet();
                    adapter.Fill(dataSet, "Customers");

                    Console.WriteLine("\nCustomer Data:");
                    foreach (DataRow row in dataSet.Tables["Customers"].Rows)
                    {
                        Console.WriteLine($"ID: {row["CustomerID"]}, Name: {row["CompanyName"]}");
                    }
                }
            }
            catch (OdbcException ex)
            {
                Console.WriteLine($"An error occurred: {ex.Message}");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"An unexpected error occurred: {ex.Message}");
            }
        }
    }
}