or
In a formTemplate I have a rad combobox so that I can look at a dropdown of present items and type in new ones if needed. Looks fine on the screen but clicking on update or insert the new item does not show up.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TRTaskBuilder.aspx.cs" Inherits="TRTaskBuilder" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> <Scripts> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> </Scripts> </telerik:RadScriptManager> <telerik:RadFormDecorator ID="FormDecorator1" runat="server" DecoratedControls="all" DecorationZoneID="hr-zone"></telerik:RadFormDecorator> <div id="hr-zone"> <telerik:RadGrid ID="RadGridTasks" runat="server" DataSourceID="TRHRTask" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True"> <MasterTableView CommandItemDisplay="Top" DataKeyNames="TaskID" DataSourceID="TRHRTask" AutoGenerateColumns="false"> <DetailTables> <telerik:GridTableView DataKeyNames="TaskID" DataSourceID="TRHRTaskNotify" CommandItemDisplay="Top" AutoGenerateColumns="False"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="TaskID" MasterKeyField="TaskID" /> </ParentTableRelation> <Columns> <telerik:GridDropDownColumn DataSourceID="Users" ListValueField="doc_id" ListTextField="username" UniqueName="username" DataField="doc_id" HeaderText="User to notify"></telerik:GridDropDownColumn> <telerik:GridBoundColumn ReadOnly="True" DataField="ID" Visible="false" UniqueName="ID"></telerik:GridBoundColumn> <telerik:GridBoundColumn ReadOnly="True" DataField="TaskID" Visible="false" UniqueName="TaskID"></telerik:GridBoundColumn> <telerik:GridBoundColumn ReadOnly="True" DataField="UserID" Visible="false" UniqueName="UserID"></telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn ReadOnly="True" DataField="TaskID" UniqueName="TaskID" Visible="false" HeaderText="ID"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TaskCategory" UniqueName="TaskCategory" HeaderText="Category"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TaskName" UniqueName="TaskName" HeaderText="Name"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TaskDescription" UniqueName="TaskDescription" HeaderText="Description"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TaskInterval" UniqueName="TaskInterval" HeaderText="Interval"></telerik:GridBoundColumn> <telerik:GridBoundColumn ReadOnly="True" DataField="TaskLastDate" UniqueName="TaskLastDate" Visible="false"></telerik:GridBoundColumn> <telerik:GridBoundColumn ReadOnly="True" DataField="TaskCreatedDate" UniqueName="TaskCreatedDate" Visible="false"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TaskEndDate" UniqueName="TaskEndDate" HeaderText="End Date"></telerik:GridBoundColumn> </Columns> <EditFormSettings EditFormType="Template"> <FormTemplate> <table> <tr> <td style="vertical-align: top; white-space: nowrap;"> <label>Category</label><br /> <telerik:RadComboBox ID="TaskCategory" SelectedValue='<%# Bind("TaskCategory") %>' DataSourceID="TaskCategorySelect" runat="server" TabIndex="201" DataTextField="TaskCategory" DataValueField="TaskCategory" AllowCustomText="true" AppendDataBoundItems="true" > </telerik:RadComboBox> </td> </tr> <tr> <td style="vertical-align: top; white-space: nowrap;"> <label>Name</label><br /> <asp:TextBox ID="TaskName" Text='<%# Bind( "TaskName") %>' runat="server" Style="width: 150px" TabIndex="202"></asp:TextBox> </td> </tr> <tr> <td style="vertical-align: top; white-space: nowrap;"> <label>Description</label><br /> <asp:TextBox ID="TaskDescription" Text='<%# Bind( "TaskDescription") %>' runat="server" Style="width: 150px" TabIndex="203"></asp:TextBox> </td> </tr> <tr> <td style="vertical-align: top; white-space: nowrap;"> <label>Interval</label><br /> <asp:DropDownList ID="TaskInterval" SelectedValue='<%# Bind("TaskInterval") %>' AppendDataBoundItems="true" runat="server" Style="width: 150px" TabIndex="204"> <asp:ListItem Selected="True" Text="Select" Value="" /> <asp:ListItem Text="Select Interval" Value="0" /> <asp:ListItem Text="Once" Value="1" /> <asp:ListItem Text="Every Month" Value="2" /> <asp:ListItem Text="Every 3 Months" Value="3" /> <asp:ListItem Text="Every 6 Months" Value="4" /> <asp:ListItem Text="Each Year" Value="5" /> </asp:DropDownList> </td> </tr> <tr> <td style="vertical-align: top; white-space: nowrap;"> <label>TaskEndDate</label><br /> <telerik:RadDatePicker ID="TaskEndDate" DbSelectedDate='<%# Bind("TaskEndDate") %>' runat="server" Style="width: 150px" TabIndex="205"></telerik:RadDatePicker> </td> </tr> <tr> <td> <asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'></asp:Button> <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button> </td> </tr> </table> </FormTemplate> </EditFormSettings> </MasterTableView> </telerik:RadGrid> </div> <asp:SqlDataSource runat="server" ID="TRHRTask" ConnectionString="<%$ ConnectionStrings:Client_Files %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [TRHRTasks] where TaskDeleted=0 ORDER By TaskCategory" UpdateCommand="UPDATE [TRHRTasks] SET [TaskCategory] = @TaskCategory,[TaskName] = @TaskName,[TaskDescription] = @TaskDescription,[TaskInterval] = @TaskInterval,[TaskLastDate] = CURRENT_TIMESTAMP,[TaskEndDate] = @TaskEndDate where TaskID=@TaskID" DeleteCommand="UPDATE [TRHRTasks] set TaskDeleted=1 where TaskID = @TaskID" InsertCommand="INSERT INTO [TRHRTasks] ([TaskCategory],[TaskName],[TaskDescription],[TaskInterval],[TaskLastDate],[TaskCreatedDate],[TaskEndDate]) VALUES (@TaskCategory,@TaskName,@TaskDescription,@TaskInterval,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,@TaskEndDate)" > <InsertParameters> <asp:Parameter Name="TaskCategory" Type="string"></asp:Parameter> <asp:Parameter Name="TaskName" Type="string"></asp:Parameter> <asp:Parameter Name="TaskDescription" Type="string"></asp:Parameter> <asp:Parameter Name="TaskInterval" Type="Int16"></asp:Parameter> <asp:Parameter Name="TaskLastDate" Type="datetime"></asp:Parameter> <asp:Parameter Name="TaskCreatedDate" Type="datetime"></asp:Parameter> <asp:Parameter Name="TaskEndDate" Type="datetime"></asp:Parameter> <asp:Parameter Name="TaskDeleted" Type="Int16"></asp:Parameter> </InsertParameters> <UpdateParameters> <asp:Parameter Name="TaskID" Type="Int32"></asp:Parameter> <asp:Parameter Name="TaskCategory" Type="string"></asp:Parameter> <asp:Parameter Name="TaskName" Type="string"></asp:Parameter> <asp:Parameter Name="TaskDescription" Type="string"></asp:Parameter> <asp:Parameter Name="TaskInterval" Type="Int16"></asp:Parameter> <asp:Parameter Name="TaskLastDate" Type="datetime"></asp:Parameter> <asp:Parameter Name="TaskCreatedDate" Type="datetime"></asp:Parameter> <asp:Parameter Name="TaskEndDate" Type="datetime"></asp:Parameter> <asp:Parameter Name="TaskDeleted" Type="Int16"></asp:Parameter> </UpdateParameters> </asp:SqlDataSource> <asp:SqlDataSource runat="server" ID="TRHRTaskNotify" ConnectionString="<%$ ConnectionStrings:Client_Files %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [last_name]+', '+[first_name] as username,[TRHRTaskNotify].[ID],[TaskID],[UserID],doc_id FROM [TRHRTaskNotify],[TRHR] where doc_id=[TRHRTaskNotify].UserID and TaskID=@TaskID" UpdateCommand="UPDATE [client_files].[dbo].[TRHRTaskNotify] set [UserID] = @doc_id where ID=@ID" DeleteCommand="DELETE FROM [client_files].[dbo].[TRHRTaskNotify] where ID=@ID" InsertCommand="INSERT INTO [client_files].[dbo].[TRHRTaskNotify] ([TaskID],[UserID]) VALUES (@TaskID,@doc_id)"> <SelectParameters> <asp:Parameter Name="TaskID" Type="Int32"></asp:Parameter> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource runat="server" ID="Users" ConnectionString="<%$ ConnectionStrings:Client_files %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [doc_id],[last_name]+', '+[first_name] as username FROM [TRHR] order by last_name" /> <asp:SqlDataSource runat="server" ID="TaskCategorySelect" ConnectionString="<%$ ConnectionStrings:Client_Files %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT distinct [TaskCategory] FROM [TRHRTasks] where TaskDeleted=0 ORDER By TaskCategory" /> </form></body></html>