This is a migrated thread and some comments may be shown as answers.

[Solved] Able to insert but not update

4 Answers 136 Views

Scheduler

This is a migrated thread and some comments may be shown as answers.

L asked on 09 Nov 2009, 03:23 AM

hi

I am able to insert, but when try to update, it doesn't give an error and it didn;t get updated. here is my code

 <telerik:RadScheduler ID="RadScheduler1" runat="server"
 DataEndField="Appt_EDateTime" DataKeyField="Appt_ID"
 DataSourceID="sdsAppointment" DataStartField="Appt_SDateTime"
 DayStartTime="09:00:00" DayEndTime="22:00:00"
 DataSubjectField="Appt_Remark" RowHeight="35px"
 HoursPanelTimeFormat="hh:mm" Skin="Outlook" TimeLabelRowSpan="1"
 EnableCustomAttributeEditing="True" CustomAttributeNames="Cust_Name,Appt_Remark,Room_No"
 ValidationGroup="RadScheduler1" NumberOfHoveredRows="1"
 TimelineView-UserSelectable="False" MonthView-UserSelectable="False"
 SelectedView="WeekView" ShowAllDayRow="False" Width="99.9%" MinimumInlineFormHeight="200"
 style="top: 0px; left: 0px; height: 622px"
 StartEditingInAdvancedForm="False">
 <AppointmentTemplate>
 <%#Eval("Cust_Name")%>
 
 Room:<%#Eval("Room_No")%>
 
 <%#Eval("Appt_Remark")%>
 </AppointmentTemplate>

<InlineInsertTemplate>
 Cust Name: 
 <asp:TextBox runat="server" ID="Cust_NameTextBox" Text='<%# Bind("Cust_Name") %>' Width="200px" BorderColor="DarkGray" BorderWidth="1px" BorderStyle="Solid"></asp:TextBox> 
   
 Room: <telerik:RadComboBox ID="drpRoomSelect" selectedValue='<%# Bind("Room_No") %>' DataSourceID="sdsRoomSelect" DataValueField="Room_No" DataTextField="Room_No" runat="server">
 </telerik:RadComboBox>
   Remark: <asp:TextBox runat="server" ID="Appt_RemarkTextBox" Text='<%# Bind("Appt_Remark") %>' TextMode="MultiLine" Height="100px" Width="200px" BorderColor="DarkGray" BorderWidth="1px" BorderStyle="Solid"></asp:TextBox>

<asp:LinkButton runat="server" ID="InsertLinkButton" CommandName="Insert" Text="Insert"></asp:LinkButton> 
 <asp:LinkButton runat="server" ID="CancelLinkButton" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
 </InlineInsertTemplate>

 <InlineEditTemplate>
  Cust Name: 
  <asp:TextBox runat="server" ID="Cust_NameTextBox" Text='<%# Bind("Cust_Name") %>' BorderColor="DarkGray" BorderWidth="1px" Width="200px" BorderStyle="Solid"></asp:TextBox> 
   
 Room: <telerik:RadComboBox ID="drpRoomSelect" selectedValue='<%# Bind("Room_No") %>' DataSourceID="sdsRoomSelect" DataValueField="Room_No" DataTextField="Room_No" runat="server">
 </telerik:RadComboBox>
   Remark: <asp:TextBox runat="server" ID="Appt_RemarkTextBox" Text='<%# Bind("Appt_Remark") %>' TextMode="MultiLine" BorderColor="DarkGray" BorderWidth="1px" BorderStyle="Solid" Height="100px" Width="200px"></asp:TextBox>

 <asp:LinkButton runat="server" ID="UpdateLinkButton" CommandName="Update" Text="Update"></asp:LinkButton> 
 <asp:LinkButton runat="server" ID="CancelLinkButton" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
 </InlineEditTemplate>

<asp:SqlDataSource ID="sdsAppointment" runat="server"
 ConnectionString="<%$ ConnectionStrings:MConnectionString %>"
 DeleteCommand="spAppointment_Delete" DeleteCommandType="StoredProcedure"
 InsertCommand="spAppointment_Insert" InsertCommandType="StoredProcedure"
 SelectCommand="spAppointment_Select" SelectCommandType="StoredProcedure"
 UpdateCommand="spAppointment_Update" UpdateCommandType="StoredProcedure">
 <SelectParameters>
 <asp:CookieParameter CookieName="branchid" Name="Branch_ID" Type="Int32" />
 </SelectParameters>
 <DeleteParameters>
 <asp:Parameter Name="Appt_ID" Type="Int32" />
 </DeleteParameters>
 <UpdateParameters>
 <asp:Parameter Name="Appt_ID" Type="Int32" />
 <asp:Parameter Name="Appt_SDateTime" Type="DateTime" />
 <asp:Parameter Name="Appt_EDateTime" Type="DateTime" />
 <asp:Parameter Name="Appt_Remark" Type="String" />
 <asp:Parameter Name="Cust_Name" Type="String" />
 <asp:CookieParameter Name="Branch_ID" CookieName="branchid" Type="Int16" />
 <asp:Parameter Name="Room_No" Type="String" />
 </UpdateParameters>
 <InsertParameters>
 <asp:Parameter Name="Appt_SDateTime" Type="DateTime"/>
 <asp:Parameter Name="Appt_EDateTime" Type="DateTime" />
 <asp:Parameter Name="Appt_Remark" Type="String" />
 <asp:Parameter Name="Cust_Name" Type="String" />
 <asp:CookieParameter Name="Branch_ID" CookieName="branchid" Type="Int16" />
 <asp:Parameter Name="Room_No" Type="String" />
 </InsertParameters>
 </asp:SqlDataSource>
 <asp:SqlDataSource ID="sdsRoomSelect" runat="server"
 ConnectionString="<%$ ConnectionStrings:MConnectionString %>"
 SelectCommand="spAppointment_RoomSelect" SelectCommandType="StoredProcedure">
 <SelectParameters>
 <asp:CookieParameter CookieName="branchid" Name="Branch_ID" Type="Int32" />
 </SelectParameters>
 </asp:SqlDataSource>

ALTER proc [dbo].[spAppointment_Update]
@Appt_ID as int,
@Appt_SDateTime datetime = null,
@Appt_EDateTime datetime = null,
@Appt_Remark as nvarchar(1000),
@Cust_Name as Nvarchar(100),
@Branch_ID as int,
@Room_No as Nvarchar(50)
as
UPDATE [dbo].[Appointment]
   SET [Appt_SDateTime] = @Appt_SDateTime
      ,[Appt_EDateTime] = @Appt_EDateTime
      ,[Appt_Remark] = @Appt_Remark
      ,[Cust_Name] = @Cust_Name
      ,[Branch_ID] = @Branch_ID
      ,[Room_No] = @Room_No
    WHERE Appt_ID = @Appt_ID

4 Answers, 1 is accepted

Accepted