Results 1 to 4 of 4

Thread: Advice required about sqlconnection

  1. May 23rd, 2004, 10:17 PM #1
    Winanjaya
    Winanjaya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    784

    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
    Reply With Quote Reply With Quote
  2. May 23rd, 2004, 10:28 PM #2
    Pirate
    Pirate is offline
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083
    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 .
    Reply With Quote Reply With Quote
  3. May 23rd, 2004, 10:48 PM #3
    Winanjaya
    Winanjaya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    784
    But .. how if I want to implement Commit and RollBack for WAN Application? this is for network connection consideration..
    pls advice .
    thanks

    Winanjaya
    Reply With Quote Reply With Quote
  4. May 24th, 2004, 07:00 PM #4
    Pirate
    Pirate is offline
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083
    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 .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width