Hi Team,

I have a project in which while loading a heavy order its takes around 75 seconds to load it completely.

I want to implement Command timeout in DataAccessAdapter so that if it will take more than 60 seconds then it will throw an exception which will be caught in Catch block.

Can you please tell me how to implement this?

Command timeouts

Firebird and SqlServer CE don't support command timeouts and a CommandTimeOut value is ignored.

As i am using SQL server only then it wont be of any use for me Walaa. IS there any other method to implement command timeout??

You're using sql server, so the command timeout feature as described in the documentation is useful for you. It's only ignored in case of SQL Server CE and firebird (as command timeouts don't work there), but as you're using sql server full that's not applicable to your situation. You can use the timeout feature as described in the docs and it should work fine.