I have a module with a function getConnection. The function establishes connection to ms sql database and returns connection object.<BR><BR>I have an aspx page with several functions executing sql queries or stored procedures. So I call getConnection in page_load event and terminate the connection in page_unload event. All the functions that require db connection use the connection object returned by getConnection.<BR><BR>My question : Is it a good practice ? should i include getconnection and close connection in each function instead ?<BR><BR>When lots of simultaneous request for the same page is made an error stating given table doesn't exits is displayed in some of the requests.<BR><BR>kancha.