Hi Nadya,

Only open the connection when you need to get/send data. ADO.NET is all about disconnected DataSets.

~~Bonnie




>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.