>Hi Nadya,
>
>Only open the connection when you need to get/send data. ADO.NET is all about disconnected DataSets.
>
>~~Bonnie
>
Thanks a lot for the response. Funny, I remembered the opposite advice from you. My memory is starting to play tricks on me.
Thanks again and where a novice can read up on this particular topic?
>
>
>>Hi everybody,
>>
>>I have a theoretical question. If we're working with SQL Server, what is the commonly-used practice: open connection at the beginning of the application and close it at the end or open and close only when sending requests to the server?
>>
>>I have this question for Visual FoxPro-SQL Server applications and for .NET applications.
>>
>>Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog