Connecting one database on two pages

Do not mix datasets with databases.

When you talk about a dataset → this is just some kind of a connection (wire) to your database. That means, you have all the possibility to create a second dataset on your second page, and connect it with your database aswell.
The same for a 3. or 4. or 5. page.

It’s not about a same —> DATASET <---- it’s about the same → DATABASE <—.
All your data is coming from a DATABASE and not from a DATASET.