Connect to database between postback [modified]

[Civic06]

I have a form with many controls and on several of the controls there is a on leave handler added. where each one connects to db and does validation and disconnects. is there a way i can connect to the db only once and then when submit is hit...disconnect. so i don't have many connect disconnects. This is for ASP.net website form.

modified on Friday, March 27, 2009 9:25 PM

[tech603]

You should try using a dataset instead of making mutiple calls to the database. When you use a dataset, you'll make one query to your database and populate the dataset with that information. At which point you can bind that data to your controls. The link below is the msdn article for working with Datasets. http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx[^] hope this helps

Matthew Vass QA Analyst mvass@hostmysite.com HostMySite.com

[Civic06]

I can't use that because the reason i am making multiple calls is to validate the value in the text box control. So there are many controls that need validation..so on postback all this happens. Is there any other way ... to keep a global db connection open for that page till submit is hit.