How to set sql timeout on the sqldatasource control

[Guest]

Hi
I have a query which takes longer than the default (30seconds I guess) time
to process (I am using the full text index in a sql server stored
procedure!). The results are place on a web page using the gridview and the
sql datasource controls.

In .Net 1.1 I guess I would have used the command.timeout property (I
already know that the web.config httpRuntime executionTimeout setting and the
sql connection timeout don't affect this the timeout I'm getting)

I am wondering how I access the sql timeout property with these new .net 2.0
controls which are great by the way.

I am guessing that I somehow reach into a the equivalent of the sqlcommand
in the datasource_selecting event and set the property. Anyone done this or
have any ideas?

 

[Walter Wang [MSFT]]

Hi,

Thank you for your post.

You can set the select command's timeout value in SqlDataSource's Selecting
event:

protected void SqlDataSource1_Selecting(object sender,
SqlDataSourceSelectingEventArgs e)
{
e.Command.CommandTimeout = 30;
}

Hope this helps.

Regards,
Walter Wang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[marco.nannini]

HI, I'm connecting to the database from an asp page, could you show me the full code to establish the connection using SqlDataSource and setting the commandtimeout option, i'm having the same problem with a long running stored procedure...

 

[cws2]

Excellent, it worked, many thanks!

Hi,

Thank you for your post.

You can set the select command's timeout value in SqlDataSource's Selecting
event:

protected void SqlDataSource1_Selecting(object sender,
SqlDataSourceSelectingEventArgs e)
{
e.Command.CommandTimeout = 30;
}

Hope this helps.

Regards,
Walter Wang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Unsurreality]

Hi,

Thank you for your post.

You can set the select command's timeout value in SqlDataSource's Selecting
event:

protected void SqlDataSource1_Selecting(object sender,
SqlDataSourceSelectingEventArgs e)
{
e.Command.CommandTimeout = 30;
}

Hope this helps.

Regards,
Walter Wang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Excellent, Walter! Thanks for this very helpful tip that I've been looking for too!