VB.NET and SQL Server connection

[enrique_g_g]

HI,,,

I need a method to connect VB.NEt application to sql server2000? is bether to open the connection to sql in the begining and close the connection when my application finish? o is bether only when i need to realize some actualization to the data base? this involve open and close connection every time. and i have to write the sentence imports system.data.sqlclient in all files where i have to use declarations.

please help!!

[Boumxyz2]

ADO.Net works in a disconnected manner. So wether you'll open your connection once the application is open or each time you use it it doesn't matter because ADO.net will handle the connection the same way : It will open a connection only when you fetch data and close it right after data is on the local computer.

[enrique_g_g]

thanks for your clarificacion Nicolas Bohemier