获取所有表到DataTable[]

本文关键字：DataTable 获取 | 更新日期: 2023-09-27 18:14:34

我有一个Access DB与多个表。我需要将它们全部转移到DataTable数组。

这是我的:

using (OleDbConnection conn = new OleDbConnection(connStr))
{
    conn.Open();
    tables = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
}

tables = public DataTable tables = null;

获取所有表到DataTable[]

解决方案是使用OleDbDataAdapter和DataSet:

    public DataSet tables = new DataSet();
    public OleDbDataAdapter adapter;
    public BusLogic()
    {
        using (OleDbConnection conn = new OleDbConnection(connStr))
        {
            conn.Open();
            adapter = new OleDbDataAdapter("SELECT * FROM City", conn);
            adapter.Fill(tables, "Cities");
        }
    }