我在.ACCDB格式的数据库，一些表。

我成功地加载到一个OleDbDataReader具有以下code：

 字符串的connectionString =供应商= Microsoft.ACE.OLEDB.12.0;数据源= C：\\ marcelo.accdb;

OleDbConnection的康恩=新的OleDbConnection（的connectionString）;

字符串SQL =SELECT * FROM Clientes;

OleDbCommand的CMD =新的OleDbCommand（SQL，康涅狄格州）;

conn.Open（）;

OleDbDataReader阅读器;

读者= cmd.ExecuteReader（）;
 

我想载入表clientes到DataTable代替。我应该怎么办呢？

 字符串CONNSTRING =
    供应商= Microsoft.ACE.OLEDB.12.0;数据源= C：\\ marcelo.accdb;

DataTable的结果=新的DataTable（）;

使用（OleDbConnection的康恩=新的OleDbConnection（CONNSTRING））
{
    OleDbCommand的CMD =新的OleDbCommand（SELECT * FROM Clientes，康涅狄格州）;

    conn.Open（）;

    OleDbDataAdapter的适配器=新OleDbDataAdapter的（CMD）;

    adapter.Fill（结果）;
}
 

I have a database in .ACCDB format with some tables.

I'm successfully loading it into an OleDbDataReader with the following code:

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;data source=C:\\marcelo.accdb";

OleDbConnection conn = new OleDbConnection(connectionString);

string sql = "SELECT * FROM Clientes";

OleDbCommand cmd = new OleDbCommand(sql, conn);

conn.Open();

OleDbDataReader reader;

reader = cmd.ExecuteReader();

I'd like to load the table "clientes" to a datatable instead. How should I do it ?

string connString = 
    "Provider=Microsoft.ACE.OLEDB.12.0;data source=C:\\marcelo.accdb";

DataTable results = new DataTable();

using(OleDbConnection conn = new OleDbConnection(connString))
{
    OleDbCommand cmd = new OleDbCommand("SELECT * FROM Clientes", conn);

    conn.Open();

    OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);

    adapter.Fill(results);
}