Table adapter timeout problme   

I have a table adapter with the following query

SELECT     viewCoreCheckIn.TonerTypeKey, viewCoreCheckIn.PartNumber,
viewCoreCheckIn.MinCheckInQty, viewCoreCheckIn.MaxCheckInQty,
                     viewCoreCheckIn.StagingCurrentQty,
viewCoreCheckIn.PreInventoryQty,
                     COALESCE (- (viewCoreCheckIn.MinCheckInQty +
viewCoreCheckIn.MinPreInventoryQty +
viewTotalReleasedQtyRemaining.TotalQtyNeeded -
viewCoreCheckIn.StagingCurrentQty
                      + viewCoreCheckIn.PreInventoryQty), 0) AS
TotalQtyNeeded,
                     COALESCE (- (viewCoreCheckIn.MinPreInventoryQty
+ viewTotalReleasedQtyRemaining.TotalQtyNeeded -
viewCoreCheckIn.PreInventoryQty), 0)
                     AS PreInventoryQtyNeeded
FROM         viewCoreCheckIn LEFT OUTER JOIN
                     viewTotalReleasedQtyRemaining ON
viewCoreCheckIn.TonerTypeKey =
viewTotalReleasedQtyRemaining.TonerTypeKey
WHERE     (viewCoreCheckIn.TonerTypeKey = @TonerTypeKey)


If I call the query from code or use preview data on the table
adapter, depending on the @TonerTypeKey the adapter will give me the
following error message

"Timeout expired.  The timeout period elapsed prior to completion of
the operation or the server is not responding"

However, if I run the query from Sql Management studio or do Configure
->Query Builder -> Execute Query in the table adapter the query runs
in less than a second.


Any ideas as to what may be going on?


thanks,

Luis

date: Tue, 26 Feb 2008 11:57:48 -0800 (PST)   author:   unknown

RE: Table adapter timeout problme   

Please try setting the connection timeout property of command object.
Also please verify the below link.

http://forums.asp.net/t/903456.aspx

Regards,
~VInu

"lrlebron@gmail.com" wrote:

> I have a table adapter with the following query
> 
> SELECT     viewCoreCheckIn.TonerTypeKey, viewCoreCheckIn.PartNumber,
> viewCoreCheckIn.MinCheckInQty, viewCoreCheckIn.MaxCheckInQty,
>                      viewCoreCheckIn.StagingCurrentQty,
> viewCoreCheckIn.PreInventoryQty,
>                      COALESCE (- (viewCoreCheckIn.MinCheckInQty +
> viewCoreCheckIn.MinPreInventoryQty +
> viewTotalReleasedQtyRemaining.TotalQtyNeeded -
> viewCoreCheckIn.StagingCurrentQty
>                       + viewCoreCheckIn.PreInventoryQty), 0) AS
> TotalQtyNeeded,
>                      COALESCE (- (viewCoreCheckIn.MinPreInventoryQty
> + viewTotalReleasedQtyRemaining.TotalQtyNeeded -
> viewCoreCheckIn.PreInventoryQty), 0)
>                      AS PreInventoryQtyNeeded
> FROM         viewCoreCheckIn LEFT OUTER JOIN
>                      viewTotalReleasedQtyRemaining ON
> viewCoreCheckIn.TonerTypeKey =
> viewTotalReleasedQtyRemaining.TonerTypeKey
> WHERE     (viewCoreCheckIn.TonerTypeKey = @TonerTypeKey)
> 
> 
> If I call the query from code or use preview data on the table
> adapter, depending on the @TonerTypeKey the adapter will give me the
> following error message
> 
> "Timeout expired.  The timeout period elapsed prior to completion of
> the operation or the server is not responding"
> 
> However, if I run the query from Sql Management studio or do Configure
> ->Query Builder -> Execute Query in the table adapter the query runs
> in less than a second.
> 
> 
> Any ideas as to what may be going on?
> 
> 
> thanks,
> 
> Luis
>

date: Tue, 13 May 2008 03:28:00 -0700   author:   Vinu

RE: Table adapter timeout problme   

Use Partial Classes in VS 2005

e.g.

namespace xxxTableAdapters
{

    public partial class xxxxlTableAdapter
    {

        public int InsertCommandTimeout
        {
            get
            {
                return (this.InsertCommandTimeout);
            }

            set
            {
                this.InsertCommandTimeout = value;
            }
        }

        public int UpdateCommandTimeout
        {

This will give you access to the private timeout properties of the table 
adapter in your code and hance set the values...

"Vinu" wrote:

> Please try setting the connection timeout property of command object.
> Also please verify the below link.
> 
> http://forums.asp.net/t/903456.aspx
> 
> Regards,
> ~VInu
> 
> "lrlebron@gmail.com" wrote:
> 
> > I have a table adapter with the following query
> > 
> > SELECT     viewCoreCheckIn.TonerTypeKey, viewCoreCheckIn.PartNumber,
> > viewCoreCheckIn.MinCheckInQty, viewCoreCheckIn.MaxCheckInQty,
> >                      viewCoreCheckIn.StagingCurrentQty,
> > viewCoreCheckIn.PreInventoryQty,
> >                      COALESCE (- (viewCoreCheckIn.MinCheckInQty +
> > viewCoreCheckIn.MinPreInventoryQty +
> > viewTotalReleasedQtyRemaining.TotalQtyNeeded -
> > viewCoreCheckIn.StagingCurrentQty
> >                       + viewCoreCheckIn.PreInventoryQty), 0) AS
> > TotalQtyNeeded,
> >                      COALESCE (- (viewCoreCheckIn.MinPreInventoryQty
> > + viewTotalReleasedQtyRemaining.TotalQtyNeeded -
> > viewCoreCheckIn.PreInventoryQty), 0)
> >                      AS PreInventoryQtyNeeded
> > FROM         viewCoreCheckIn LEFT OUTER JOIN
> >                      viewTotalReleasedQtyRemaining ON
> > viewCoreCheckIn.TonerTypeKey =
> > viewTotalReleasedQtyRemaining.TonerTypeKey
> > WHERE     (viewCoreCheckIn.TonerTypeKey = @TonerTypeKey)
> > 
> > 
> > If I call the query from code or use preview data on the table
> > adapter, depending on the @TonerTypeKey the adapter will give me the
> > following error message
> > 
> > "Timeout expired.  The timeout period elapsed prior to completion of
> > the operation or the server is not responding"
> > 
> > However, if I run the query from Sql Management studio or do Configure
> > ->Query Builder -> Execute Query in the table adapter the query runs
> > in less than a second.
> > 
> > 
> > Any ideas as to what may be going on?
> > 
> > 
> > thanks,
> > 
> > Luis
> >

date: Thu, 19 Jun 2008 04:34:04 -0700   author:   Abdul Majid Abdul