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
