I wouldn't recommend having any database or IO code in your Pages. The Page
class is your Interface layer. It should only call upon business classes to
do the actual work, and contain interface-related code. For example, let's
say that you want to display data from a database in a DataGrid on the Page.
You could create a Database class having a method that can execute a
database operation and return a DataSet. The Page class can then call the
method in that class to get the DataSet, and simply bind it to the DataGrid.
The Database class would maintain its own connections.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living
"Wilson Smith" <WW*******@hotmail.com> wrote in message
news:ua**************@TK2MSFTNGP11.phx.gbl...
Microsoft document says use the Page_Unload event to perform final cleanup
work.
Like, closing files, closing database connections.
Considering the performance of the application is it always a good idea to
open the database connection at the Page_Load and do all the work and
close the connection in the Page_Unload event? Currently for each routine in its
specific function/sub routine I am opening the database connection and
closing.
I am just curious what the normal practice in the industry is in this
scenario.
Thanks for your reply.
Will