[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
10/09/2009 at 10:04AM PDT, ID: 24799892 | Points: 500
[x]
Attachment Details

timeout data adapter

Asked by Fraser_Admin in Programming for ASP.NET, .NET Framework 3.x versions, Microsoft Visual Basic.Net

i'm using .net 3.5.  i have my selection in a dataset (.xsd) file.  I have a business logic layer to connect to get the data.  Problem is my sql is timing out.  How do I set it higher?

I tried _da.SelectCommand.CommandTimeout (but there is no selectcommand property)
I tried connection.connectiontimeout but it is read only.

So how do i set this? 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

Public Shared Function Get_Contract_Deliveries_Shared(ByVal Start_Date As String, ByVal End_Date As String, ByVal Contract_ID As Integer) As Scales.ReportingDataTable
        Dim _da As ta_Reporting = Nothing
        Dim _dt As New Scales.ReportingDataTable
        _da = New ta_Reporting
        _da.SelectCommand.CommandTimeout = 120
 
        _da.Connection.ConnectionTimeout = 500
        _dt = _da.Get_Contract_Deliveries(Start_Date:=Start_Date, End_Date:=End_Date, Contract_ID:=Contract_ID)
        Return _dt
    End Function
[+][-]10/09/09 10:41 AM, ID: 25537108

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/09/09 10:43 AM, ID: 25537118

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/27/09 05:19 PM, ID: 25679005

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/19/09 03:39 PM, ID: 25866413

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625