Solved

xsd Command Timeout

Posted on 2009-05-07
1
1,115 Views
Last Modified: 2013-11-26
Afternoon,

I've googled this topic and found a few references to it.  As I understand it is pretty simple to set the SqlCommand.commandtimeout = x when dealing with dataadapter built in code but there is no way of doing this with xsd, auto-genereated table adapters.  From what I gather I need to build my own subclass of the command object, here's a few links giving examples of this.  They are in C though so can anyone give me a more detailed example in VB.

http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic33902.aspx


http://www.velocityreviews.com/forums/t123018-p2-how-to-set-commandtimeout-for-objectdatasource-aspnet-20.html


Many thanks
0
Comment
Question by:nick210577
1 Comment
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 24332312
Code conversion:

http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic33902.aspx

Namespace programTableAdapters
    Public Partial Class OrderTableAdapter
        Public Sub SetCommandTimeout(ByVal timeout As Integer)
            For Each command As IDbCommand In CommandCollection
                command.CommandTimeout = timeout
            Next
        End Sub
    End Class
End Namespace
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now