1
Answer

Trouble putting some things in context

Wes

Wes

17y
2.2k
1

Below is the page that I created in VS2005. I am new to doing things programatically in ASP.Net and so far have gotten everywhere I wanted to go by using the drop in widgets in VS. Now I am faced with a page that gives me a timeout error when updating to a SQL server. The query itself is fairly simple, a stored procedure updates two tables on two differrent servers. The problem is because of distance and other factors it sometimes takes longer than the allowed 30 seconds.

I have seen information that setting the timeout for the sqlcommand can be done, but I am having trouble putting into the context of this project and getting my head around it. Could someone help me understand how to put it all together?

 

Answers (1)
0
Wes

Wes

NA 3 0 17y

Now with more code...

<pre>

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" Title="Edit Sale" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainBody" Runat="Server">

You may edit the sale in the dialer using the form below. All edits are logged.<br />

You are Editing the record as <asp:Label ID="EditUser" runat="server" Text="Wes"></asp:Label>

<br />

<br />

<asp:DetailsView ID="EditSaleForm" runat="server" AutoGenerateRows="False"

DefaultMode="Edit" Height="50px" Width="341px" DataSourceID="sqlEditSale" DataKeyNames="Campaign, crrecordid, crcalldatetime, phonenumber, ccauthcode">

<Fields>

<asp:BoundField DataField="Campaign" HeaderText="Campaign" ReadOnly="True" SortExpression="Campaign" />

<asp:BoundField DataField="crrecordid" HeaderText="crrecordid" ReadOnly="True" SortExpression="crrecordid" />

<asp:BoundField DataField="crcalldatetime" HeaderText="crcalldatetime" ReadOnly="True"

SortExpression="crcalldatetime" />

<asp:BoundField DataField="cragentid" HeaderText="cragentid" SortExpression="cragentid" />

<asp:BoundField DataField="verifierid" HeaderText="verifierid" SortExpression="verifierid" />

<asp:BoundField DataField="PhoneNumber" HeaderText="PhoneNumber" ReadOnly="True"

SortExpression="PhoneNumber" />

<asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />

<asp:BoundField DataField="SpouseName" HeaderText="SpouseName" SortExpression="SpouseName" />

<asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />

<asp:BoundField DataField="Street" HeaderText="Street" SortExpression="Street" />

<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />

<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />

<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />

<asp:BoundField DataField="AltNumber" HeaderText="AltNumber" SortExpression="AltNumber" />

<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />

<asp:BoundField DataField="Adults" HeaderText="Adults" SortExpression="Adults" />

<asp:BoundField DataField="Children" HeaderText="Children" SortExpression="Children" />

<asp:BoundField DataField="TaxPrice" HeaderText="TaxPrice" SortExpression="TaxPrice" />

<asp:BoundField DataField="ResortCode" HeaderText="ResortCode" SortExpression="ResortCode" />

<asp:BoundField DataField="OfferCode" HeaderText="OfferCode" SortExpression="OfferCode" />

<asp:BoundField DataField="Comments" HeaderText="Comments" SortExpression="Comments" />

<asp:BoundField DataField="CCAuthCode" HeaderText="CCAuthCode" ReadOnly="True" SortExpression="CCAuthCode" />

<asp:BoundField DataField="ArrivalDate" HeaderText="ArrivalDate" SortExpression="ArrivalDate" />

<asp:CommandField ButtonType="Button" InsertVisible="False" ShowEditButton="True" />

</Fields>

</asp:DetailsView>

<asp:SqlDataSource ID="sqlEditSale" runat="server" ConnectionString="<%$ ConnectionStrings:PRIS2ConnectionString %>" SelectCommand="sp_GetSales_GetEditSale" SelectCommandType="StoredProcedure" UpdateCommand="sp_GetSales_UpdateEditSaleBP" UpdateCommandType="StoredProcedure">

<SelectParameters>

<asp:QueryStringParameter Name="crrecordid" QueryStringField="crrecordid" Type="Int32" />

</SelectParameters>

<UpdateParameters>

<asp:ControlParameter ControlID="EditUser" Name="EditUser" Type="String" />

<asp:Parameter Name="Campaign" Type="String" />

<asp:Parameter Name="crrecordid" Type="Int32" />

<asp:Parameter Name="crcalldatetime" Type="DateTime" />

<asp:Parameter Name="cragentid" Type="String" />

<asp:Parameter Name="verifierid" Type="String" />

<asp:Parameter Name="PhoneNumber" Type="String" />

<asp:Parameter Name="FirstName" Type="String" />

<asp:Parameter Name="SpouseName" Type="String" />

<asp:Parameter Name="LastName" Type="String" />

<asp:Parameter Name="Street" Type="String" />

<asp:Parameter Name="City" Type="String" />

<asp:Parameter Name="State" Type="String" />

<asp:Parameter Name="Zip" Type="String" />

<asp:Parameter Name="AltNumber" Type="String" />

<asp:Parameter Name="Email" Type="String" />

<asp:Parameter Name="Adults" Type="String" />

<asp:Parameter Name="Children" Type="String" />

<asp:Parameter Name="TaxPrice" Type="Decimal" />

<asp:Parameter Name="ResortCode" Type="String" />

<asp:Parameter Name="OfferCode" Type="String" />

<asp:Parameter Name="Comments" Type="String" />

<asp:Parameter Name="CCAuthCode" Type="String" />

<asp:Parameter Name="ArrivalDate" Type="DateTime" />

</UpdateParameters>

</asp:SqlDataSource>

</asp:Content>

</pre>

Next Recommended Forum