Advice required about sqlconnection

Dear The Expert,
Which better .. to always open the sqlconnection until the application closed or to open the sqlconnection only when it required? ..
I need advice .. many thanks in advance

Regards
Winanjaya

You open the connection ONLY whenever needed . There's no advantage of leaving the connection open from the moment you start your app till you close it .

But .. how if I want to implement Commit and RollBack for WAN Application? this is for network connection consideration..
pls advice .
thanks

Winanjaya

If you explicitly , open the connection you must close it when you finish . If you open it implicitly , then you don't have to close it because it closes automatically when using the dataAdapte's fill or update method . That's it .