Always close and destroy your connection once you're done with it. To comment on your code though, I would use a different connection object for each logical query I perform.

Also, store your connection string in the web.config file, this way using the same connection object becomes an idiotic matter for you.