in web pages how do i do about sql connections? u have a public sqlconnection that u use for all ur querys about ur current web page or for each one u have one connection?

i mean..i have to make a query about some posts, then have another one to get the current files on the server, then another one on users preferences..what u do? for each one create another connetion or across all the app u use the same connection? and how u do it then? how to share it thru all the web controls in a page?