Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up query
Message
From
07/11/2002 16:44:36
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00719885
Message ID:
00720041
Views:
10
Roger,

Yep ... good point.

~~Bonnie


>If you need to run multiple queries to fill the dataset it's better to open the connection, use the DataAdapters, and then close it. Otherwise you'll be opening and closing the connection multiple times. The DataAdapter will leave the connection in the state it found it.
>
>Roger
>
>>
>>This is only in the case if you explicitly open the connection. If your DataSet is filled with a da.Fill(ds), there's no reason to manually open it *or* close it ... the DataAdapter takes care of that for you.
>>
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform