SQLDatasource CommandTimeout not working
- by Cedric Aube
Good day,
I'm using a SQLDataSource with a dynamic query generated c#, based on user choices in many fields. However, since our tables are very large, sometimes, I get a command timeout exception.
I tried to set the property in 'Selecting' of the SqlDataSource like so:
protected void SqlDataSource_PSearch_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
e.Command.CommandTimeout = 900;
}
but with not luck, like if this attribute was ignored.
.NET 2.0, Sql server 2005.
Any idea?
