Objectdatasource / Table Adapter Command Time Out

testinrepviewer

New member
Joined
Sep 23, 2014
Messages
1
Programming Experience
1-3
Hello. I am not sure if this is posted in exactly the right place / new to this.... Here is the background:

Visual Studio 2013
ASPX with ReportViewer Control included on page.
ReportViewer Control is pulling from a ObjectDataSource
Report (.rdlc file) is referencing back to a Dataset (.xsd file)
Dataset (.xsd file) includes the Table Adapter.
Page Language="VB"
ASPX File is named Default.aspx
CodeFile="Default.aspx.vb"

ObjectDataSources and SQLDataSources both have a default timeout of 30 Seconds. That is ok for most small select statements. However, for something a little larger - it could go over. I know how to override a SQLDataSource CommandTimeout. Something like this:

Protected Sub SqlDataSource1_WhatType_Selecting(sender As Object, e As SqlDataSourceSelectingEventArgs) Handles SqlDataSource1_WhatType.Selecting
e.Command.CommandTimeout = ######
End Sub

However, for a objectdatasource I am stumped. From the hours of research I have done - it seems to be tied back to the dataset or even the table adapter -- needs to be set there.

Anyways, I am starting over with this to see if anyone here has run in to this? Things to try?

Thank you!!
 
Back
Top