Hi,<BR><BR>Think this is like the prior thread....<BR><BR>Is it possible to create a database connection in the page_load event handler and pass it to different ascx controls embedded thoughout the page?<BR><BR>I.
Ok then. Excuse my ignorance but I'm working on my first html type site.....<BR><BR>Is it normal to connect to a database several different times during the generation of a single page in order to create different sections such as menu bars and a list of products being browsed?<BR><BR>I.
You'll want to research connection pooling and how it works in .NET. Closing the connection to a DB in your code doesn't exactly close the connection as beginners understand it. .NET holds onto the connection and passes it off to the next request or closes it itself after a certain timeframe.<BR><BR>It is what allows high traffic DB oriented sites in .NET to work so well.