Time out problem

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Sabarish_s Members Profile Find Members Posts Newbie Joined: 06 October 2003 Location: India Status: Offline Points: 1	Post Options Post Reply Quote Sabarish_s Report Post Thanks(0) Quote Reply Topic: Time out problem Posted: 06 October 2003 at 4:47am
	I am using a SqldataAdapter to fill in a dataset, which is used to populate a Datagrid, as the queries are complex it is taking 5-10 minutes to execute and i am getting an exception "Time out Expired".Is therse any way to increase the Time out while using SqlDatAdapter and a dataset

Bunce Members Profile Find Members Posts Senior Member Joined: 10 April 2002 Location: Australia Status: Offline Points: 846	Post Options Post Reply Quote Bunce Report Post Thanks(0) Quote Reply Posted: 06 October 2003 at 8:22pm
	you can set the timeout in your connection string, and also on the command object in your data-adapter. I think you can also set a page.(script)timeout setting or something similar too although you might have to research that one. However, 5-10 minutes is a long time, unless you're talking MEGA complex! Perhaps you can look into optimising that first.. Cheers, A
	There have been many, many posts made throughout the world... This was one of them.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.