Rod,
You are not the first one, however adviced is for SQLserver to open and
dispose it.
For a webform I do it always in that way. A webform is stateless so
everything should be build everytime new with every visit to the server.
What not does mean that you cannot create a class for your database handling
which you can instance everytime new. (Do not make a shared class for a
webpage).
Don't as well not forget that it is very easy to hold a dataset in a
session, what is probably a better solution in your case.
I hope this helps?
Cor