The reason to open/close the connection in distributed system is to save
server and network resources, when many users keep their connections open.
In you case it's not obligatory, you can keep connection open.
But why to read data from DB in navigation? why not to get data for the
currect select and keep them in DataSet?
If you develop a stand alone c# windows application that only reads from a
single local Access database, do you need to close the connection each time
you navigate to a different record? No other person or program will ever
interact with this single table MS Access database.
I have been developing web applications where you open then close the
connection to an external datasource with each submission but this is so
different.
--
WBR,
Michael Nemtsev :: blog:
http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche