<p>Can I store a database connection in the Session object?</p>

It is generally not recommended to do so, a connection string in the Application variable, with a nice helper function/class is a much preferred method.
Here
is some reference.
(Dead link removed because it now leads to a phishy site)