Thank you so much for your time and comments. On Thu, Sep 6, 2012 at 5:39 PM, Stephen Russell <srussell...@gmail.com>wrote:
> > > On Thu, Sep 6, 2012 at 7:13 AM, Gunawan Hadikusumo < > john.hadikus...@gmail.com> wrote: > >> I think i had similar situation before...but not sure if it is exactly >> the same..... that time i used datareader alot but forgot to close it at >> the end of method. >> >> Check your datareader...make sure it is closed properly after being used. >> >> ------------------- >> > > Make sure you are not opening a new connection for each data pull you need > when you know that you need to hit 3,4,5 tables. Making the connection is > your largest loss of efficiency when you consider that the .Open() gets no > data. ;-> > > > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to dotnetdevelopment@googlegroups.com > To unsubscribe from this group, send email to > dotnetdevelopment+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- "People who never make mistakes, never do anything." dEv -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
