Click here to Skip to main content
11,503,839 members (77,035 online)
Click here to Skip to main content

Accesing CommandTimeout properties in a TableAdapter

, 9 Feb 2006 CPOL 94.1K 23
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)

Share

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, acknowledged contrarian

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

"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

 
Questionand no extension method '_adapter' Pin
bb46thor20-Oct-08 11:40
memberbb46thor20-Oct-08 11:40 
GeneralCode Issue/Problem Pin
Pete79631-Mar-08 4:03
memberPete79631-Mar-08 4:03 
GeneralRe: Code Issue/Problem Pin
bgeo22-Aug-08 4:16
memberbgeo22-Aug-08 4:16 
Yeap, same problem for me (Visual Studio 2005, C#, .NET Framework 2.0); with the original code I have this exception :
System.NullReferenceException: Object reference not set to an instance of an object.
at XXXX.dsGetProduseNomenclator_TableAdapters.getProduseNomenclatorTableAdapter.set_SelectCommandTimeout(Int32 value) in ....

After I changed _commandCollection with CommandCollection everything works fine.
GeneralVB.NET 2005 - Version of Code for Partial Class Pin
gratroweb20-Feb-08 6:01
membergratroweb20-Feb-08 6:01 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 9:35
memberrckrll4ever6-Aug-08 9:35 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 10:58
memberPIEBALDconsult6-Aug-08 10:58 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 11:26
memberrckrll4ever6-Aug-08 11:26 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 11:34
memberPIEBALDconsult6-Aug-08 11:34 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 11:40
memberrckrll4ever6-Aug-08 11:40 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 11:45
memberPIEBALDconsult6-Aug-08 11:45 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 12:54
memberrckrll4ever6-Aug-08 12:54 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 13:02
memberPIEBALDconsult6-Aug-08 13:02 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
BISolutionBuilders7-Mar-10 1:22
memberBISolutionBuilders7-Mar-10 1:22 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult7-Mar-10 3:13
mvpPIEBALDconsult7-Mar-10 3:13 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
brrg588-Aug-10 8:07
memberbrrg588-Aug-10 8:07 
GeneralNew Revision 2 (for SQLDataSource and DataSet objects) Pin
gmhwn23-Jun-07 9:40
membergmhwn23-Jun-07 9:40 
GeneralNew Revision Pin
gmhwn17-May-07 23:09
membergmhwn17-May-07 23:09 
GeneralRe: New Revision Pin
PIEBALDconsult18-May-07 15:41
memberPIEBALDconsult18-May-07 15:41 
GeneralRe: New Revision Pin
Bob Crowley18-May-10 8:00
memberBob Crowley18-May-10 8:00 
GeneralRe: New Revision Pin
PIEBALDconsult18-May-10 8:28
mvpPIEBALDconsult18-May-10 8:28 
GeneralMinor Code Glitch Pin
msorens9-May-06 8:39
membermsorens9-May-06 8:39 
GeneralRe: Minor Code Glitch Pin
PIEBALDconsult11-May-06 7:51
memberPIEBALDconsult11-May-06 7:51 
GeneralRe: Minor Code Glitch Pin
SMOR31-May-06 5:41
memberSMOR31-May-06 5:41 
GeneralRe: Minor Code Glitch Pin
PIEBALDconsult31-May-06 13:55
memberPIEBALDconsult31-May-06 13:55 
GeneralRe: Minor Code Glitch Pin
PIEBALDconsult1-Jun-06 8:29
memberPIEBALDconsult1-Jun-06 8:29 

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 | Terms of Use | Mobile
Web04 | 2.8.150520.1 | Last Updated 9 Feb 2006
Article Copyright 2006 by PIEBALDconsult
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid