Results 1 to 5 of 5

Thread: Is this bad? sqlConnection and command [RESOLVED]

Threaded View

  1. Jul 22nd, 2004, 08:31 PM #1
    Andy
    Andy is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2003
    Posts
    1,489

    Is this bad? sqlConnection and command [RESOLVED]

    I declared a public SqlConnection and SqlCommand in a module and made it public. I re-use those throughout the life of the app and simply open and close as necessary the connection object and change the command.commandText property as needed. Is that better or worse or the same as going through that process time and time again for each function/sub that may need it?
    Last edited by Andy; Aug 13th, 2004 at 11:55 AM.
    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