Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

OnyakTech
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Timeout Problem
Previous Previous
 
Next Next
New Post 5/20/2008 9:14 PM
User is offline George Mitchell
99 posts
10th Ranked




Timeout Problem 
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 9:46 PM
User is offline Carlos Rodriguez
526 posts
www.almacigo.com
8th Ranked


Re: Timeout Problem 

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 8:23 AM
User is offline George Mitchell
99 posts
10th Ranked




Re: Timeout Problem 

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 9:00 AM
User is offline Carlos Rodriguez
526 posts
www.almacigo.com
8th Ranked


Re: Timeout Problem 

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 Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Timeout Problem
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


telerik
telerik r.a.d.controls suite is the most innovative and comprehensive toolset for ASP.NET development, tailored for seamless integration with the DotNetNuke project. This integrated collection of controls allows professionals to build web-solutions with the UI richness and responsiveness of desktop applications.
dnn.telerik.com
CrystalTech
CrystalTech Web Hosting™ provides first-class service and support. Our value-packed ASP.NET plans offer DNN installation, SQL 2005 and up to 100 domain names starting at only $16.95 per month!
CrystalTech.com
DotNetNuke® in Sweden
All service of DotNetNuke® in Sweden.
Olsmar Konsult

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP