以下是一个使用OleDbDataAdapter的简单示例代码:
```csharp
using System;
using System.Data;
using System.Data.OleDb;
class Program
{
static void Main(string[] args)
{
// 数据库连接字符串
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\MyDatabase.accdb;";
// SQL查询语句
string query = "SELECT * FROM Customers";
// 创建OleDbDataAdapter对象
OleDbDataAdapter adapter = new OleDbDataAdapter(query, connectionString);
// 创建DataSet对象
DataSet dataSet = new DataSet();
try
{
// 填充DataSet
adapter.Fill(dataSet);
// 获取查询结果的第一个表格
DataTable dataTable = dataSet.Tables[0];
// 遍历表格中的行
foreach (DataRow row in dataTable.Rows)
{
// 输出每一行的数据
Console.WriteLine("Customer ID: {0}", row["CustomerID"]);
Console.WriteLine("Company Name: {0}", row["CompanyName"]);
Console.WriteLine("Contact Name: {0}", row["ContactName"]);
Console.WriteLine();
}
}
catch (Exception ex)
Console.WriteLine("Error: {0}", ex.Message);
finally
// 关闭连接和释放资源
adapter.Dispose();
dataSet.Dispose();
Console.ReadLine();
}
}
```