Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Timeout ProblemTimeout Problem
Previous
 
Next
New Post
5/20/2008 11:14 PM
 
Hi Folks,
 
I have a table module that I developed to handle the MS GridView. I seem to be having a timeout problem with it. This is a fairly complex GridView implementation because it actually contains a main GridView with another embedded one. I am using the MS ObjectDataSource object and calling methods that use the DNN data provider. Here is a typical statement: 
Return CType(SqlHelper.ExecuteReader(AltDBConnectionString, GetFullyQualifiedName("GetPgMembers"), sortExpression, startRowIndex, maximumRows, searchArg, typeArg, Msg), IDataReader) 
I am also using ExecuteScalar and ExecuteNonQuery. I am not using ExecuteSQL.
 
Here is the first part of the error message: 
Message: DotNetNuke.Services.Exceptions.PageLoadException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached… 
Could this be a connection closing issue? I am not explicitly closing any connections. Should I be doing that? I was under the impression that DNN handles that. Does anyone have some experience with implementing the GridView component in DNN? Am I possibly running afoul of special issues with GridView and DNN? Anything that points me in the right direction would be most appreciated.
 
Thanks,
G. M.   
 
New Post
5/20/2008 11:46 PM
 

George:

I cannot tell you exactly what is going on with your code but I had problems embedding a control inside of another, to make the story short, because I was implementing the thing using a bad approach, I basically created an infinite loop, (I had not done that in a while).  Your problem with connections may be something like what was happening to me, if your events run out of control, you end up creating too many connections. 

Anyway, check this post I made recently, in it you will find a URL for a site that has excellent examples on how to embed controls inside of others.  They have live demos there, check them out to see them in action.  They also have the code of course, maybe you can study those to see what is wrong with your code.

Good luck.

Carlos

 
New Post
5/21/2008 10:23 AM
 

Thanks very much for the help Carlos.

I'll follow your suggestion. In my testing I have noticed that the problem occurs when changes are made to the embedded GridView but it does not seem to happen to changes made to rows in the main or container GridView. I think you have pointed me in the right direction. At any rate I'll post any additional information about this here which I hope will also have a solution. :)

 

 

 
New Post
5/21/2008 11:00 AM
 

George:

I don't remember exactly because since then I corrected the code and deleted the erroneous one, but the problem I created was based on misuse of the events of both the parent container and the other bound control inside of it.  I don't remember if I was using on Load or on Binding (or both) but the thing is that the event from the inside control would fire the parent again, and then would run the event for the internal control again, which would then fire the parent again and, you get the point, infinite loop.  If you look at the examples for the site I suggested he basically handles the data binding for the internal control manually.

Carlos

 

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Timeout ProblemTimeout Problem


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out