General select statement to stored procedures
This is first refactored version of your code. I have changed following thing


If any object provide dispose method , prefer using statement.
Use dictionary rather than list of parameter as you have a possibility of specifying param names also
Current implementation sticks only to datatable , you might need to think about the datareader. 
naming of variable should be explicit. 


Few more things needs to be thought like out param if you need. 

public static DataTable ExecuteDataTable(string queryName, CommandType commandType, Dictionary&lt;string,object&gt; parameters=null)
{
    using (OleDbConnection connection =  WorkerDB.GetConnection())
    {
        using (var command=new OleDbCommand())
        {
            connection.Open();
            command.CommandText = queryName;
            command.CommandType = commandType;
            command.Connection = connection;


            if (parameters != null)
            {
                foreach (var parameter in parameters)
                {
                    command.Parameters.AddWithValue(parameter.Key, parameter.Value);
                } 
            }

            var dataAdapter = new OleDbDataAdapter(command);
            var dataTable = new DataTable();
            dataAdapter.Fill(dataTable);
            dataAdapter.Dispose();

            return dataTable;
        }
    }
}