| <EditFormSettings ColumnNumber="2" CaptionDataField="CodigoProduto" CaptionFormatString="Edit properties of Product {0}"> |
| <FormTemplate> |
| <table style="width:100%;"> |
| <tr> |
| <td><asp:Label ID="lblProduto" runat="server" Text="Código do produto:" CssClass="cad-lbl" /></td> |
| <td colspan="5"> |
| <asp:TextBox ID="txtProdutoCodigo" runat="server" ReadOnly="true"></asp:TextBox> |
| <asp:HiddenField ID="hdfProdutoCodigo" runat="server" |
| onvaluechanged="hdfProdutoCodigo_ValueChanged" /> |
| <button onclick="openWin(); return false;" class="btn"> |
| Buscar</button> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| <asp:Label ID="lblQuantidade" runat="server" Text="Quantidade (m):" CssClass="cad-lbl"/> |
| <asp:RequiredFieldValidator ID="rfvQuantidade" ValidationGroup="Produto" runat="server" |
| ControlToValidate="ntxtQuantidade" ErrorMessage="O campo Quantidade é obrigatório." |
| Text="*"></asp:RequiredFieldValidator> |
| </td> |
| <td> |
| <vm2:NumericTextBox ID="ntxtQuantidade" runat="server" MinValue="0" onblur="onblurQuantidade()" CssClass="cad-txt" EnableEmbeddedSkins="false" Skin=""/> |
| </td> |
| <td> |
| <asp:Label ID="lblLances" runat="server" Text="Lances:" CssClass="cad-lbl"></asp:Label> |
| <asp:RequiredFieldValidator ID="rfvLances" ValidationGroup="Produto" runat="server" |
| ControlToValidate="ntxtLances" ErrorMessage="O campo Lances é obrigatório." Text="*"></asp:RequiredFieldValidator> |
| </td> |
| <td> |
| <vm2:NumericTextBox ID="ntxtLances" NumberFormat-DecimalDigits="0" onblur="onblurLance()" |
| runat="server" MinValue="0" CssClass="cad-txt" EnableEmbeddedSkins="false" Skin=""/> |
| </td> |
| <td> |
| <asp:Label ID="lblMetragem" runat="server" Text="Metragem:" CssClass="cad-lbl"></asp:Label> |
| </td> |
| <td> |
| <asp:TextBox ID="txtMetragem" runat="server" ReadOnly="true" CssClass="cad-txt"></asp:TextBox> |
| <asp:HiddenField ID="hdfMetragem" runat="server" /> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| <asp:Label ID="lblPrecoAplicado" runat="server" Text="Preço Aplicado:" CssClass="cad-lbl"></asp:Label> |
| </td> |
| <td> |
| <asp:TextBox ID="txtPrecoAplicado" runat="server" ReadOnly="true" CssClass="cad-txt"></asp:TextBox> |
| <asp:HiddenField ID="hdfPrecoAplicado" runat="server" /> |
| </td> |
| <td> |
| <asp:Label ID="lblAcondicionamento" runat="server" Text="Acondicionamento:" CssClass="cad-lbl"></asp:Label> |
| <asp:CompareValidator ID="cpvAcondicionamento" runat="server" ValueToCompare="-- Selecione --" |
| ValidationGroup="Produto" ControlToValidate="ddlAcondicionamento" Operator="NotEqual" |
| ErrorMessage="O campo Acondicionamento é obrigatório." Text="*"></asp:CompareValidator> |
| </td> |
| <td> |
| <vm2:Combobox ID="ddlAcondicionamento" runat="server" Skin="Office2007" CssClass="cad-ddl" |
| ZIndex="9000" OnItemDataBound="ddlAcondicionamento_ItemDataBound"> |
| </vm2:Combobox> |
| </td> |
| <td colspan="2"> |
| <asp:Button ID="btnAdicionarProduto" runat="server" Text="Adicionar" ValidationGroup="Produto" |
| OnClick="btnAdicionarProduto_Click" CssClass="btn" /> |
| </td> |
| </tr> |
| </table> |
| </FormTemplate> |
| </EditFormSettings> |
I am getting an Ajax error when I use the following code when I add an appoint. the error is as follows:
-----------------------------------------------------------------------------------------------
Sys.Webforms.pagerequestmanagerServerErrorException:Item has already been added. Key in dictionary:;'ID' key being added: 'ID'.
--------------------------------------------------------------------------------------------------
I am getting similar errors when I delete or update. There is no codebehind code, I am just uing SQLDatasource. I checked that the Appointments table has ID field which is an identity field.
Please let me know.
----------------------------------------------------Code----------------------------------------------------------
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RadSchedulerConnectionString %>"
SelectCommand="SELECT * FROM [Appointments]" ProviderName="System.Data.SqlClient"
InsertCommand ="INSERT INTO [Appointments] ([Subject], [Start], [End], [RoomID], [UserID], [RecurrenceRule], [RecurrenceParentID]) VALUES (@Subject, @Start, @End , @RoomID, @UserID, @RecurrenceRule, @RecurrenceParentID)"
UpdateCommand="UPDATE [Appointments] SET [Subject] = @Subject, [Start] = @Start, [End] = @End, [RoomID] = @RoomID, [UserID] = @UserID, [RecurrenceRule] = @RecurrenceRule, [RecurrenceParentID] = @RecurrenceParentID WHERE (ID = @ID)"
DeleteCommand="DELETE FROM [Appointments] WHERE [ID] = @ID"
>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="RecurrenceRule" Type="String" />
<asp:Parameter Name="RecurrenceParentID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="RecurrenceRule" Type="String" />
<asp:Parameter Name="RecurrenceParentID" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<
telerik:RadScheduler ID="RadScheduler1" runat="server" DataEndField="End"
DataKeyField="ScheduleID" DataRecurrenceField="ScheduleID"
DataRecurrenceParentKeyField="ScheduleID" DataSourceID="AccessDataSource1"
DataStartField="Start" DataSubjectField="Subject">
</telerik:RadScheduler>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/Database/AmbLL.mdb"
DeleteCommand="DELETE FROM [Schedule] WHERE [ScheduleID] = ?"
InsertCommand="INSERT INTO [Schedule] ([ScheduleID], [Subject], [Start], [End]) VALUES (?, ?, ?, ?)"
SelectCommand="SELECT * FROM [Schedule]"
UpdateCommand="UPDATE [Schedule] SET [Subject] = ?, [Start] = ?, [End] = ? WHERE [ScheduleID] = ?">
<DeleteParameters>
<asp:Parameter Name="ScheduleID" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="ScheduleID" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ScheduleID" Type="String" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
</InsertParameters>
</asp:AccessDataSource>
Any suggestions?