油王的菜鳥筆記

在使用RDLC 時, 有時可能資料太多導致TIMEOUT,在SqlDataSource 加入Timeout 設定可解決這問題

.aspx

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" OnSelecting="SqlDataSource1_Selecting" ConnectionString="<%$ ConnectionStrings:XXXConnectionString %>" ></asp:SqlDataSource>

.aspx.cs

 

   protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
            e.Command.CommandTimeout = 999;
        }
    }