mdb的批量查询语句封装成datatable的效率特别卡 就是因为 access不能批量执行sql 所以 现在就只能     

public static DataTable getMdbDataTable(string fileNamePath, List<string> strSql)
        {
            DataTable dt = new DataTable();
            string ConnectionStringMDB = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}", fileNamePath);
            OleDbConnection cnMdb = new OleDbConnection(ConnectionStringMDB);
            cnMdb.Open();
            try
            {
                for (int i = 0; i < strSql.Count; i++)
                {
                    OleDbDataAdapter adapter = new OleDbDataAdapter(strSql[i], cnMdb);
                    adapter.Fill(dt);
                }
            }
            catch (Exception ex)
            {
                Sql.Error = ex.Message;
            }
            finally
            {
                cnMdb.Close();//关闭数据库连接
                cnMdb.Dispose();
            }
            return dt;
        } 这样 但是 数据量一大就卡死。求优化方案