SqlDataSource - command timeout?

[Sasa .]

Hello,

I was wondering if it is possible to set command timeout for the
SQLDataSource control. Documentation on this topic is scarce and I
could not find anything on the internet either. Anybody has an idea?

Thanks,
Sasa .

 

[chanmmn]

I would suggest you give the precise error. At the mean time this might
helps:

http://msdn.microsoft.com/library/d...nectionPoolingForSQLServerNETDataProvider.asp

chanmm

 

[Sasa .]

As the selectQuery of my SQLDataSource control I have a parameterized
query that depending on parameters supplied sometimes takes quite a
long time to execute.

SQLDataSource control is a data source for GridView control.
Sometimes, using this setup, I get error:
"System.Data.SqlClient.SqlException: Timeout expired."

If I bind GridView to say SqlDataReader that is created
programmatically, I can set up command timeout to any desired value
and get the thing working without problems. However, I would like to
use SQLDataSource control as data source but I do not know how to set
up command timeout... Idea, anybody?

Sasa .

 

[WertmanTheMad]

I found it in case anyone at a later date looks for this.

Add a Selecting Event to the SqlDataSource and then add

the following to the Selecting

e.Command.CommandTimeout = 5000 'For example

Have Fun

Chris