Database Connection problem
-
HI , I have an ASP.net page that contains a function with a for loop in , inside the for loop i query the database , i use a class which i have identified my connection in and the page inherits that class , the problem is the function doesn't see the connection and creates a new connection every time inside the loop , which caused a database maximum pool error , please help , why doesn't my function create a new connection each time ??? and why doesn't it access the connection object of the page ??? Thanks
-
HI , I have an ASP.net page that contains a function with a for loop in , inside the for loop i query the database , i use a class which i have identified my connection in and the page inherits that class , the problem is the function doesn't see the connection and creates a new connection every time inside the loop , which caused a database maximum pool error , please help , why doesn't my function create a new connection each time ??? and why doesn't it access the connection object of the page ??? Thanks
-
but the dataset at a session variable and then get the table or the dataset and get data from it