Click here to Skip to main content
15,860,972 members
Articles / Programming Languages / C#

Accessing CommandTimeout Properties in a TableAdapter

Rate me:
Please Sign up or sign in to vote.
4.76/5 (12 votes)
9 Feb 2006CPOL1 min read 150.4K   23   26
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.)

C#
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:

C#
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

  • 8th February, 2006: Initial post

License

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


Written By
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 pedant and contrarian

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

"I would be looking for better tekkies, too. Yours are broken." -- Paul Pedant

"Using fewer technologies is better than using more." -- Rico Mariani

"Good code is its own best documentation. As you’re about to add a comment, ask yourself, ‘How can I improve the code so that this comment isn’t needed?’" -- Steve McConnell

"Every time you write a comment, you should grimace and feel the failure of your ability of expression." -- Unknown

"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

"Use vertical and horizontal whitespace generously. Generally, all binary operators except '.' and '->' should be separated from their operands by blanks."

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

Comments and Discussions

 
Questionand no extension method '_adapter' Pin
bb46thor20-Oct-08 11:40
bb46thor20-Oct-08 11:40 
GeneralCode Issue/Problem Pin
Pete79631-Mar-08 4:03
Pete79631-Mar-08 4:03 
GeneralRe: Code Issue/Problem Pin
DanielBelecciu22-Aug-08 4:16
DanielBelecciu22-Aug-08 4:16 
GeneralVB.NET 2005 - Version of Code for Partial Class Pin
gratroweb20-Feb-08 6:01
gratroweb20-Feb-08 6:01 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 9:35
rckrll4ever6-Aug-08 9:35 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 10:58
mvePIEBALDconsult6-Aug-08 10:58 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 11:26
rckrll4ever6-Aug-08 11:26 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 11:34
mvePIEBALDconsult6-Aug-08 11:34 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 11:40
rckrll4ever6-Aug-08 11:40 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 11:45
mvePIEBALDconsult6-Aug-08 11:45 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
rckrll4ever6-Aug-08 12:54
rckrll4ever6-Aug-08 12:54 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult6-Aug-08 13:02
mvePIEBALDconsult6-Aug-08 13:02 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
BISolutionBuilders7-Mar-10 1:22
BISolutionBuilders7-Mar-10 1:22 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
PIEBALDconsult7-Mar-10 3:13
mvePIEBALDconsult7-Mar-10 3:13 
GeneralRe: VB.NET 2005 - Version of Code for Partial Class Pin
ssi1128-Aug-10 8:07
ssi1128-Aug-10 8:07 
GeneralNew Revision 2 (for SQLDataSource and DataSet objects) Pin
gmhwn23-Jun-07 9:40
gmhwn23-Jun-07 9:40 
GeneralNew Revision Pin
gmhwn17-May-07 23:09
gmhwn17-May-07 23:09 
GeneralRe: New Revision Pin
PIEBALDconsult18-May-07 15:41
mvePIEBALDconsult18-May-07 15:41 
GeneralRe: New Revision Pin
Bob Crowley18-May-10 8:00
Bob Crowley18-May-10 8:00 
GeneralRe: New Revision Pin
PIEBALDconsult18-May-10 8:28
mvePIEBALDconsult18-May-10 8:28 
GeneralMinor Code Glitch Pin
msorens9-May-06 8:39
msorens9-May-06 8:39 
GeneralRe: Minor Code Glitch Pin
PIEBALDconsult11-May-06 7:51
mvePIEBALDconsult11-May-06 7:51 
GeneralRe: Minor Code Glitch Pin
SMOR31-May-06 5:41
SMOR31-May-06 5:41 
GeneralRe: Minor Code Glitch Pin
PIEBALDconsult31-May-06 13:55
mvePIEBALDconsult31-May-06 13:55 
Because that would be wrong. But you can do what you like.
GeneralRe: Minor Code Glitch Pin
PIEBALDconsult1-Jun-06 8:29
mvePIEBALDconsult1-Jun-06 8:29 

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

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