Click here to Skip to main content
Click here to Skip to main content

Accesing CommandTimeout properties in a TableAdapter

, 9 Feb 2006
Rate this:
Please Sign up or sign in to vote.
Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter.

Introduction

Every Command object has a public CommandTimeout property. A DataAdapter has (up to) four public references to Command objects. Visual Studio 2005 introduced the concept of a TableAdapter, which encapsulates a DataAdapter. The encapsulated DataAdapter is private, and there is no public access to it and its contents.

The result is that you have no access to the Command objects used by the TableAdapter (quite rightly so too). But that allows no access to the CommandTimeout properties!

The code that defines the TableAdapter gets generated automatically (in C#, the file is named xxxDataSet.Designer.cs). Modifying this file is not the solution because any changes to this file will be lost the next time the code is generated.

Solution

.NET V2.0 (or is it just C#?) also introduced "partial classes". The TableAdapter class is a partial class (and you have the source code for it) so you can add any additional functionality to it. Simply create (and include in your project) a file containing whatever code you want to add to the class.

The following code adds public properties for the CommandTimeouts of the Command objects. (Look in your xxxDataSet.Designer.cs file for the name of the class and the namespace for your TableAdapter.)

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;
                    }
                }
            }
        }
    }
}

Then you can access them like this:

this.xxxTableAdapter.SelectCommandTimeout = 0 ;
// Set the CommandTimeout
// for the TableAdapter's Select command(s)

In closing

You can use this technique to add whatever you like to generated partial classes, but be careful what you do!

History

  • First posted 2006/02/08.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

PIEBALDconsult
Software Developer (Senior)
United States United States
BSCS 1992 Wentworth Institute of Technology
 
Originally from the Boston (MA) area. Lived in SoCal for a while. Now in the Phoenix (AZ) area.
 
OpenVMS enthusiast, ISO 8601 evangelist, photographer, opinionated SOB
 
---------------
 
"If you need help knowing what to think, let me know and I'll tell you." -- Jeffrey Snover [MSFT]
 
"Typing is no substitute for thinking." -- R.W. Hamming
 
"I find it appalling that you can become a programmer with less training than it takes to become a plumber." -- Bjarne Stroustrup
 
ZagNut’s Law: Arrogance is inversely proportional to ability.
 
"Well blow me sideways with a plastic marionette. I've just learned something new - and if I could award you a 100 for that post I would. Way to go you keyboard lovegod you." -- Pete O'Hanlon
 
"linq'ish" sounds like "inept" in German -- Andreas Gieriet
 
"Things would be different if I ran the zoo." -- Dr. Seuss
 
"Wrong is evil, and it must be defeated." – Jeff Ello
 
"A good designer must rely on experience, on precise, logical thinking, and on pedantic exactness." -- Nigel Shaw
 
“It’s always easier to do it the hard way.” -- Blackhart

“If Unix wasn’t so bad that you can’t give it away, Bill Gates would never have succeeded in selling Windows.” -- Blackhart

"Omit needless local variables." -- Strunk... had he taught programming
 

 
"We learn more from our mistakes than we do from getting it right the first time."
 
My first rule of debugging: "If you get a different error message, you're making progress."
 
My golden rule of database management: "Do not unto others' databases as you would not have done unto yours."
 
My general rule of software development: "Design should be top-down, but implementation should be bottom-up."

Comments and Discussions

 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pinmemberrckrll4ever6-Aug-08 12:54 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class PinmemberPIEBALDconsult6-Aug-08 13:02 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class PinmemberBISolutionBuilders7-Mar-10 1:22 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class PinmvpPIEBALDconsult7-Mar-10 3:13 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pinmemberbrrg588-Aug-10 8:07 
GeneralNew Revision 2 (for SQLDataSource and DataSet objects) Pinmembergmhwn23-Jun-07 9:40 
GeneralNew Revision Pinmembergmhwn17-May-07 23:09 
GeneralRe: New Revision PinmemberPIEBALDconsult18-May-07 15:41 
GeneralRe: New Revision PinmemberBob Crowley18-May-10 8:00 
GeneralRe: New Revision PinmvpPIEBALDconsult18-May-10 8:28 
GeneralMinor Code Glitch Pinmembermsorens9-May-06 8:39 
GeneralRe: Minor Code Glitch PinmemberPIEBALDconsult11-May-06 7:51 
GeneralRe: Minor Code Glitch PinmemberSMOR31-May-06 5:41 
GeneralRe: Minor Code Glitch PinmemberPIEBALDconsult31-May-06 13:55 
GeneralRe: Minor Code Glitch PinmemberPIEBALDconsult1-Jun-06 8:29 
GeneralRe: Minor Code Glitch Pinmembervlad.pitaru5-Dec-06 22:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 9 Feb 2006
Article Copyright 2006 by PIEBALDconsult
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid