Hi all

I have created a community site using VB and asp.net with SQL Server as data provider. All pages are importing the public class DataAccess for communication with the SQL Server. For data binding the public shared function GetDataReader is used. All binding is using this function and the problem is that this function is setting up a new data connection every time accessed, with the result that these are not getting closed.

My question is if its a good idea using only ONE data connection in this class? How will this affect performance? This would mean that all pages are using the same data connection for all data access.

If this is not a good idea, how can I close the connections after data binding? I would prefer not to rewrite all code (a lot) as all are using the same concept with one central publi shared class (clean and nice).

Regards//Tom