I have this aspx code: and i received an Error On Page: DataBinding: Telerik.Web.Ui.Appoint Does not contain a property with a name 'Remark'
I have checked on my store proc for insert and update and select and they are working fine. Where did i go wrong? Thanks
<telerik:RadScheduler ID="RadScheduler1" runat="server"
DataEndField="EDateTime" DataKeyField="Appt_ID"
DataSourceID="sdsAppointment" DataStartField="SDateTime" DayEndTime="21:00:00"
DataSubjectField="Remark" HoursPanelTimeFormat="htt" Skin="Outlook"
ValidationGroup="RadScheduler1">
<InlineInsertTemplate>
<asp:TextBox runat="server" ID="RemarkTextBox" Text='<%# Bind("Remark") %>' Width="99%"></asp:TextBox>
User:
<asp:TextBox runat="server" ID="LNameTextBox" Text='<%# Bind("LName") %>' Width="99%"></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>
<asp:TextBox runat="server" ID="RemarkTextBox" Text='<%# Bind("Remark") %>' Width="99%"></asp:TextBox>
User:
<asp:TextBox runat="server" ID="LNameTextBox" Text='<%# Bind("LName") %>' Width="99%"></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>
</telerik:RadScheduler>
<
asp:SqlDataSource ID="sdsAppointment" runat="server"
ConnectionString="<%$ ConnectionStrings:ClinicMgmtConnectionString %>"
DeleteCommand="spAppointment_Delete" DeleteCommandType="StoredProcedure"
InsertCommand="spAppointment_Insert" InsertCommandType="StoredProcedure"
SelectCommand="spAppointment_Select" SelectCommandType="StoredProcedure"
UpdateCommand="spAppointment_Update" UpdateCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="Appt_ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Appt_ID" Type="Int32" />
<asp:Parameter Name="SDateTime" Type="DateTime" />
<asp:Parameter Name="EDateTime" Type="DateTime" />
<asp:Parameter Name="Remark" Type="String" />
<asp:Parameter Name="LName" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="SDateTime" Type="DateTime"/>
<asp:Parameter Name="EDateTime" Type="DateTime" />
<asp:Parameter Name="Remark" Type="String" />
<asp:Parameter Name="LName" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
4 Answers, 1 is accepted
I have two questions:
1. Can you send us the select statement from this stored procedure: spAppointment_Select
2. Why do you need to use the Bind expression in the controls in the InlineInsertTemplate? It is an insert operation so I suppose this is not useful in this case.
Sincerely yours,
Veselin Vasilev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Rank 1
here it is:
Create Proc spAppointment_Select
as
Select Appt_ID, SDateTime,EDateTime,Remark,LName from tblAppointment.
2. Why do you need to use the Bind expression in the controls in the InlineInsertTemplate? It is an insert operation so I suppose this is not useful in this case.
How should i go about it? Thanks
Just remove the Bind expressions and let us know the results.
Kind regards,
Veselin Vasilev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Rank 1
I used EnableCustomAttributeEditing="true" CustomAttributeNames="LName,Remark" and it is solved. Thanks