How to set commandTimeout for getData method of TableAdapter (ASP.NET 2.0)?

[Piotrek]

Hi all.

I am developing some web application in which I use datasets, which
were generated using dataSetDesigner. My dataset has a TableAdapter,
which has GetData method. Users of my application sometimes get timeout
while executing this GetData method.

I would like to increase CommandTimeout for this GetData method, but I
cannot find this property. How can I do that?

Thanks in advance,
Piotrek

[Brock Allen]

You could alter the connection string used to initialize the DataAdapter
to include the timeout desired.

-Brock
http://staff.develop.com/ballen

Hi all.

I am developing some web application in which I use datasets, which
were generated using dataSetDesigner. My dataset has a TableAdapter,
which has GetData method. Users of my application sometimes get
timeout while executing this GetData method.

I would like to increase CommandTimeout for this GetData method, but I
cannot find this property. How can I do that?

Thanks in advance,
Piotrek

[Piotrek]

Hi Brock

I am not sure if it is possible to set CommandTimeout in the connection
string. In my opinion only connectionTimeout can be set there.

Piotrek

[Brock Allen]

I thought those were the same?

In any event, you can access the command timeout via: DataAdapter.SelectCommand.CommandTimeout.

-Brock
http://staff.develop.com/ballen

Hi Brock

I am not sure if it is possible to set CommandTimeout in the
connection string. In my opinion only connectionTimeout can be set
there.

Piotrek

[Piotrek]

I am afraid not.
Try it with TableAdapter and some Fill or GetData method.

Piotrek