Increase DAAB time out

[Phil396]

I am using an old version of the DAAB. I need to set the command timeout
property.
This is my code.

SqlConnection myConnection = new SqlConnection(_ConnectionString);

DataSet ds = SqlHelper.ExecuteDataset(myConnection,sp, spParams);

This works fine for quick queries but of course will timeout with anything
over 30 seconds. I tried to find a way to increase the command timeout but
forthe 9 overload methods of SqlHelper.ExecuteDataset but I do not see a way
to pass this method a command object. How do you increase the command timeout
for executing a stored procedures with SqlHelper.ExecuteDataset.

[Peter Bromberg [C# MVP]]

The V2 SqlHelper class does not have a ComandTimeout setting. I'd recommend
you add a static int field to the class, which can be set prior to making
any method calls, and then this value can be checked inside each method and
the Command.Timeout changed appropriately.

This is fairly common, they just didn't think to put it in.

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Phil396" wrote:

I am using an old version of the DAAB. I need to set the command timeout
property.
This is my code.

SqlConnection myConnection = new SqlConnection(_ConnectionString);

DataSet ds = SqlHelper.ExecuteDataset(myConnection,sp, spParams);

This works fine for quick queries but of course will timeout with anything
over 30 seconds. I tried to find a way to increase the command timeout but
forthe 9 overload methods of SqlHelper.ExecuteDataset but I do not see a way
to pass this method a command object. How do you increase the command timeout
for executing a stored procedures with SqlHelper.ExecuteDataset.