September 24, 2014 at 2:12 am
Hello. I am not sure if this is posted in exactly the right place/new to this. I believe this is tied to SQL Reporting Services?.... 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!!
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply