TableAdapter and CommandTimeout

[Guest]

Is there any way to change CommandTimeout on commands that are generated
using TableAdapter wizard?

 

[AMDRIT]

the timeout is not set by the wizard and takes the default timeout (30
seconds). In the InitializeComponents code section is where all of your
generated code will live. You can specify it there.

 

[Guest]

There is no InitializeComponents method in wizard generated code. And even ih
there were one, modifing wizard generated code is not a solution for me
becaouse every time i change something in DataSet design the code is
regenerated.
Maybe i should point out that i mean about new TableAdapter wizard
funcionality in VS 2005, not DataAdapter wizard that is used to generate
untyped DataAdapters.

 

[Guest]

Is there any way to change CommandTimeout on commands that are generated
using TableAdapter wizard?

A colleague and I hit the same problem yesterday. The only work-around is to
alter the generated code in xxxDataSet.Designer.cs which is no solution.

The xxxTableAdapter should expose the Command objects (they're private) or
at least their CommandTimeout properties. They should in fact be exposed in
the designer.

I just took a quick look to see if I could find the template that's used, in
hopes of altering it, but didn't find it. Anyone know where it can be found?

 

[Guest]

Is there any way to change CommandTimeout on commands that are generated
using TableAdapter wizard?

Ah, the power of partial classes! Create and include a file that contains
something like below (make it match the generated code) then in, for instance
Form1.cs, do:

private void Form1_Load ( object sender , EventArgs e )
{
this.xxxTableAdapter.SelectCommandTimeout = 0 ;
this.xxxTableAdapter.Fill ( this.xxxDataSet.xxx );
}

-----------------------

namespace xxx.xxxDataSetTableAdapters
{
public partial class xxxTableAdapter
{
public int InsertCommandTimeout
{
get
{
return ( this._adapter.InsertCommand.CommandTimeout ) ;
}

set
{
this._adapter.InsertCommand.CommandTimeout = value ;
}
}

public int UpdateCommandTimeout
{
get
{
return ( this._adapter.UpdateCommand.CommandTimeout ) ;
}

set
{
this._adapter.UpdateCommand.CommandTimeout = value ;
}
}

public int DeleteCommandTimeout
{
get
{
return ( this._adapter.DeleteCommand.CommandTimeout ) ;
}

set
{
this._adapter.DeleteCommand.CommandTimeout = value ;
}
}

public int SelectCommandTimeout
{
get
{
return ( this._commandCollection[0].CommandTimeout ) ;
}

set
{
for ( int i = 0 ; i < this._commandCollection.Length ; i++ )
{
if ( ( this._commandCollection [ i ] != null ) )
{
( (System.Data.SqlClient.SqlCommand) (
this._commandCollection [ i ] ) ).CommandTimeout = value ;
}
}
}
}
}
}