September 26, 2011 at 7:31 am
The SQLDataSource Control placed on a aspx page has a default time-out of 30. (I think). How do you change that to make it longer until I can get my query worked out faster?
I thought it was: (CacheDuration)
<asp:SqlDataSource id="Test" CacheDuration="Infinite" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SP_Test" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="UNV" Name="DropDownList1" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
September 26, 2011 at 7:36 am
No the setting is timeout.
How about we fix your code instead??
Can you post the tables definitions, including keys and indexes and most importantly the actual execution plan?
September 26, 2011 at 7:39 am
Yes, I posted and you guys gave me some great suggestions that I am working on. (for fixing the code)
September 26, 2011 at 7:42 am
Setting is timeout ----- Would you give me an example?
<asp:SqlDataSource id="Test" CacheDuration="Infinite" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SP_Test" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="UNV" Name="DropDownList1" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
September 26, 2011 at 7:44 am
I'm no asp expert. That setting used to be in the command or dataset object.
However I think you'll be getting a page or server timeout well before your ds command fails.
Might I suggest an asp forum for such help assuming F1 doesn't solve it for ya?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply