How to set commandTimeout for ObjectDataSource (ASP.NET 2.0)?

Hi Juan.

> It's simpler to set the Timeout in code :
I know that, however as I said I did not write any line of code -
everything was autogenerated by DataSet Designer. It would be great if
I could change this generated code by setting there timeout.
Unfortunately I cannot find this code. Morover I think that every time
I change something in my dataset then this code would be generated one
more time and my changes would be overridden.

Piotrek

Piotrek

Hey, did you ever figure this out?
I am having the same problem - in the DataSet desginer, I do not see a
way to set the CommandTimeout (just the CommandText, CommandType,
etc.).
Changing the code... well I would lose it on the next auto-generate.
And the command variables are private.
ARGH.



Piotrek wrote:
> Hi Juan.
>
> > It's simpler to set the Timeout in code :
> I know that, however as I said I did not write any line of code -
> everything was autogenerated by DataSet Designer. It would be great if
> I could change this generated code by setting there timeout.
> Unfortunately I cannot find this code. Morover I think that every time
> I change something in my dataset then this code would be generated one
> more time and my changes would be overridden.
>
> Piotrek

usenetlex@yahoo.com

No I didn't. I just wrote my own DAL class instead of that one, which
was generated by DataSet Designer.

Piotrek

Piotrek

[EJocys]

Originally Posted by Piotrek

HI all.

In my web site I have some ObjetDataSource. Its business object
property is set to my dataset I created in dataset designer (this
dataset has table adapter).

My question is: how can I set command time-out property for fill method
from this table adapter?

Thanks in advance,
Piotrek.

Here is your answer:

1. Open your Dataset (lets say MyDataSet.xsd file).
2. Double click on your table adapter (lets say MyTableAdapter)
Visual Studio will switch you to MyDataSet.cs file and will generate similar code for you:

namespace Company.Project.DataProvider {
    partial class MyDataSet
    {
        partial class MyDataTable
        {
        }
    }
}

3. Now you need to add new property which will help to set command time-out for all commands controller by MyTableAdapter:

namespace Company.Project.DataProvider {
    partial class MyDataSet
    {
        partial class MyDataTable
        {
        }
    }
}

namespace Company.Project.DataProvider.MyDataSetTableAdapters
{
    public partial class MyTableAdapter
    {
        public int CommandTimeout
        {
            set
            {
                for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1))
                {
                    if ((this.CommandCollection[i] != null))
                    {
                        this.CommandCollection[i].CommandTimeout = value;
                    }
                }
            }
        }
    }
}

4. Open ASPX page where you are using ObjetDataSource (lets say MyObjetDataSource
5. Select MyObjetDataSource, click with right-mouse on it and from menu choose Properties
6. Visual studio will open Properties window for MyObjetDataSource
On top of all properties list there is toolbar. Click lightning icon to see all events of MyObjetDataSource.
7. Double click on ObjectCreated event
8. Visual Studio will open source code of ASPX page and will generate event function for you:

protected void MyDataSource_ObjectCreated(object sender, ObjectDataSourceEventArgs e)
{
}

9. Create code which will set Command Timeout just after MyDataSource has been created created

protected void MyDataSource_ObjectCreated(object sender, ObjectDataSourceEventArgs e)
{
    Company.Project.DataProvider.MyDataSetTableAdapters.MyTableAdapter adapter;
    adapter = (Company.Project.DataProvider.MyDataSetTableAdapters.MyTableAdapter)e.ObjectInstance;
    // Set command timeout to 2 minutes
    adapter.CommandTimeout = 120;
}

Done.

Keywords: C#, commandTimeout, ObjectDataSource, DataSet, TableAdapter, Designer, Solution, Code Example, Resolved, www.jocys.com

EJocys

[BlahBlahBlah]

Hi EJocys,
That approach does not work for me.

The "code behind" for my XSD file is XML. In other words, I get as far as this step:
1. Open your Dataset (lets say MyDataSet.xsd file).
2. Double click on your table adapter (lets say MyTableAdapter)

Double-clicking my table adapter does nothing. When I right-click and select "View Code" I see only XML.

Anyone know what gives?

BlahBlahBlah

[amchi]

I made it work.
I had the same issue like you ... code view only showing XML junk.

Added a new PARTIAL class with namespace matching my TableAdapter.
Something like

namespace CAATTableAdapters 
    {
    public partial class SomeTableAdapterInsideCAATTableAdapter
        {
            public int CommandTimeout
            {
                set
                {
                    for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1))
                    {
                        if ((this.CommandCollection[i] != null))
                        {
                            this.CommandCollection[i].CommandTimeout = value;
                        }
                    }
                }
            }
        }
    }

Then added following to my ObjectDataSource event
CAATDataSource_ObjectCreated

Dim adapter As New CAATTableAdapters.SomeTableAdapterInsideCAATTableAdapter
        adapter = CType(e.ObjectInstance, CAATTableAdapters.SomeTableAdapterInsideCAATTableAdapter)
        adapter.CommandTimeout = 300

And yes I mixed VB and C# .. it's all same to me.

amchi