Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

xsd Command Timeout

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 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