强类型数据集的命令超时 [英] Command Timed Out for Strongly Typed DataSet

问题描述

大家好，

我在ASP.Net中有一个RDLC报告，为了绑定该报告，我们使用的是强类型数据集.绑定报表时，我们将得到Timed Out Expired异常.我们还检查了生产服务器上的存储过程，该过程大约需要5秒钟.但是，当我们尝试从生产网站运行时，它将引发TimedOut Expired Exception.

我们使用SQL事件探查器对此进行检查.当我们从代码中调用SP时，它将执行SP 30秒，并向我们抛出Timed Out Exception.我们还尝试在表适配器中设置CommandTimeout属性.

Hi All,

I have a RDLC report in ASP.Net and to bind that report we are using Strongly Typed DataSet. We are getting Timed Out Expired Exception when we bind the report. We have also checked the Store Procedure on production server that takes approx 5 sec. But when we try to run from production website it throws TimedOut Expired Exception.

We check this with SQL Profiler. When we call the SP from code it execute the SP for 30 sec and throw us the Timed Out Exception. We also tried setting the CommandTimeout Property within the Table Adapter.

((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).CommandTimeout = 120;

但是仍然无法正常工作.我们的SP包含table variable, Function, PIVOT, Group BY, SUM

问候，
Vinod D.

But still it''s not working. Our SP is containing table variable, Function, PIVOT, Group BY, SUM

Regards,
Vinod D.

推荐答案

查看此....

http://blogs.msdn.com/b/angelsb/archive/2004/08/25/220333.aspx [ ^ ]

Check this out....

http://blogs.msdn.com/b/angelsb/archive/2004/08/25/220333.aspx[^]

这篇关于强类型数据集的命令超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！