Solved

xsd Command Timeout

Posted on 2009-05-07
1
1,121 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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