Timeout Error for sql data source

Question

Error code:

Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Can someone provide me with code I can copy and paste so I can change the default timeout? I'm not sure where to put it into this code:

<head runat="server">
<title>Proxy Report</title>
</head>
<body>
<form id="form1" runat="server">
<div>

    <asp:Label ID="Label1" runat="server" Text="Proxy Report"></asp:Label>

</div>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ISALog1ConnectionString %>" 
    SelectCommand="ProxyReport" SelectCommandType="StoredProcedure">

</asp:SqlDataSource>
</form>
</body>
</html>

That is much more likely to mean that your connection string is wrong. — SLaks
– SLaks, Commented Jun 29, 2012 at 16:35
There's some help on this over here, too: stackoverflow.com/questions/10286685/… — dash
– dash, Commented Jun 29, 2012 at 16:56

Fraz Sundal · Accepted Answer · 2012-06-29 16:56:20Z

22

You can increase the Timeout property like this

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

Setting timeout to 0 means no timeout

answered Jun 29, 2012 at 16:56

Fraz Sundal

10.4k22 gold badges87 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nurp Over a year ago

Don't forget to attach the event handler if you are creating the datasource on code behind: SqlDataSource1.Selecting += SqlDataSource1_Selecting;

Collectives™ on Stack Overflow

Timeout Error for sql data source

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related