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?
