Unable to insert records in the row :
Error message - {"Unable to cast object of type 'Telerik.Web.UI.GridCommandItem' to type 'Telerik.Web.UI.GridEditFormInsertItem'."}
Am I missing something ??
protected void RadGrid1_InsertCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) |
{ |
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item; |
string Activity = (insertedItem["Activity"].Controls[0] as TextBox).Text; |
string Status = (insertedItem["Status"].Controls[0] as TextBox).Text; |
string Comments = (insertedItem["Comments"].Controls[0] as TextBox).Text; |
try |
{ |
string Query = null; |
Query = "INSERT into SheduleActivityDetails(Activity,Status,Comments) values('" + Activity + "','" + Status + "','" + Comments + "')"; |
objDataLayer.ExecuteNonQuery(Query); |
RebindRadGrid(); |
} |
catch (Exception ex) |
{ |
RadGrid1.Controls.Add(new LiteralControl("Unable to insert Activity. Reason: " + ex.Message)); |
e.Canceled = true; |
} |
<telerik:RadGrid ID="RadGrid1" runat="server" |
Width="600px" AllowMultiRowSelection="false" AllowMultiRowEdit="false" AllowAutomaticInserts="false" |
AllowAutomaticUpdates="false" AllowPaging="true" ShowStatusBar="true" AutoGenerateEditColumn="false" |
EnableAJAX="true" OnNeedDataSource="RadGrid1_NeedDataSource" |
OnInsertCommand="RadGrid1_InsertCommand" OnUpdateCommand="RadGrid1_UpdateCommand" |
ShowFooter="True" OnItemCreated="RadGrid1_ItemCreated" Skin="Office2007"> |
<ClientSettings> |
<Selecting AllowRowSelect="true" EnableDragToSelectRows="true" /> |
</ClientSettings> |
<MasterTableView CommandItemDisplay="Top" DataKeyNames="Id" EditMode="InPlace" AllowAutomaticInserts="False" AutoGenerateColumns="false" Width="100%"> |
<Columns> |
<telerik:GridClientSelectColumn HeaderStyle-Width="40px" /> |
<telerik:GridBoundColumn DataField="Id" Visible="true" HeaderText="Id" |
UniqueName="Id" ReadOnly="True"> |
</telerik:GridBoundColumn> |
<%--<telerik:GridBoundColumn DataField="Activity Id" HeaderText="ID" ReadOnly="True" |
SortExpression="ActivityId" UniqueName="Activity ID" Visible="false"> |
<HeaderStyle Width="20px" ForeColor="Silver" /> |
<ItemStyle ForeColor="Silver" /> |
</telerik:GridBoundColumn>--%> |
<telerik:GridBoundColumn DataField="Activity" HeaderText="Activity" SortExpression="Activity" |
UniqueName="Activity"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Status" HeaderText="Status" SortExpression="Status" |
UniqueName="Status" Visible="true" EditFormColumnIndex="1"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Comments" HeaderText="Comments" SortExpression="Comments" |
UniqueName="Comments" Visible="true" EditFormColumnIndex="1"> |
</telerik:GridBoundColumn> |
</Columns> |
<CommandItemTemplate> |
<div style="padding: 10px 0px;"> |
<asp:LinkButton Style="vertical-align: bottom" ID="btnEditSelected" runat="server" |
CommandName="EditSelected" CausesValidation="false" Visible='<%# RadGrid1.EditIndexes.Count == 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="=../../Images/Edit.gif" /> Edit Selected Activity</asp:LinkButton> |
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="UpdateEdited" Visible='<%# RadGrid1.EditIndexes.Count > 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="=../../Images/Update.gif" /> Update Activity</asp:LinkButton> |
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="CancelAll" CausesValidation="false" |
Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="=../../Images/edit.png" /> Cancel editing</asp:LinkButton> |
<asp:LinkButton ID="LinkButton3" runat="server" CommandName="InitInsert" Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="=../../Images/AddRecord.gif" /> Add new Activity</asp:LinkButton> |
<asp:LinkButton ID="LinkButton4" runat="server" CommandName="PerformInsert" Visible='<%# RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="=../../Images/Insert.gif" /> Add this Activity</asp:LinkButton> |
|
<asp:LinkButton ID="LinkButton5" runat="server" CommandName="RebindGrid"><img style="border:0px;vertical-align:middle;" alt="" src="=../../Images/Refresh.gif"/> Refresh Activities</asp:LinkButton> |
</div> |
</CommandItemTemplate> |
<EditFormSettings ColumnNumber="2" CaptionFormatString="Edit properties of Activity with Id {0}" |
CaptionDataField="ActivityId"> |
<FormTableItemStyle Wrap="False"></FormTableItemStyle> |
<FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle> |
<FormMainTableStyle GridLines="Horizontal" CellSpacing="0" CellPadding="5" BackColor="White" |
Width="100%"/> |
<FormTableStyle CellSpacing="0" CellPadding="2" CssClass="module" Height="110px" |
BackColor="White"/> |
<FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle> |
<EditColumn ButtonType="ImageButton" InsertText="Insert Order" UpdateText="Update record" |
UniqueName="EditCommandColumn1" CancelText="Cancel edit"> |
</EditColumn> |
<FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle> |
</EditFormSettings> |
</MasterTableView> |
</telerik:RadGrid> |