New to Telerik UI for ASP.NET AJAXStart a free 30-day trial

Database Level Editing

In numerous cases you may want to perform data editing operations at database level with Update/Insert/Delete commands from the code-behind. This can be done wiring the UpdateCommand/InsertCommand/DeleteCommand events of RadGrid and executing appropriate Update/Insert/Delete queries which refresh the data in the underlying database. Below are the code snippets from a simple example which uses auto-generated edit form:

ASP.NET
<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" Skin="Lime" GridLines="None" AllowPaging="True"
  AllowSorting="True" AutoGenerateColumns="False" Width="97%" OnNeedDataSource="RadGrid1_NeedDataSource"
  OnDeleteCommand="RadGrid1_DeleteCommand" OnInsertCommand="RadGrid1_InsertCommand"
  OnUpdateCommand="RadGrid1_UpdateCommand">
  <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
  <MasterTableView DataKeyNames="EmployeeID" GridLines="None" Width="100%" CommandItemDisplay="Top">
    <Columns>
      <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="Delete">
      </telerik:GridButtonColumn>
      <telerik:GridBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" UniqueName="EmployeeID"
        ReadOnly="True">
      </telerik:GridBoundColumn>
      <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" UniqueName="LastName">
      </telerik:GridBoundColumn>
      <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" UniqueName="FirstName">
      </telerik:GridBoundColumn>
      <telerik:GridBoundColumn DataField="Title" HeaderText="Title" UniqueName="Title">
      </telerik:GridBoundColumn>
      <telerik:GridBoundColumn DataField="Address" HeaderText="Address" UniqueName="Address">
      </telerik:GridBoundColumn>
      <telerik:GridBoundColumn DataField="City" HeaderText="City" UniqueName="City">
      </telerik:GridBoundColumn>
      <telerik:GridEditCommandColumn>
      </telerik:GridEditCommandColumn>
    </Columns>
    <EditFormSettings ColumnNumber="2" CaptionFormatString="Edit details for employee with ID {0}"
      CaptionDataField="EmployeeID">
      <FormTableItemStyle Wrap="False"></FormTableItemStyle>
      <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle>
      <FormMainTableStyle CellSpacing="0" CellPadding="3" Width="100%" />
      <FormTableStyle GridLines="Horizontal" CellSpacing="0" CellPadding="2" CssClass="module"
        Height="110px" Width="100%" />
      <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle>
      <FormStyle Width="100%" BackColor="#EEF2EA"></FormStyle>
      <EditColumn UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit">
      </EditColumn>
      <FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle>
    </EditFormSettings>
    <ExpandCollapseColumn Visible="False">
      <HeaderStyle Width="19px"></HeaderStyle>
    </ExpandCollapseColumn>
    <RowIndicatorColumn Visible="False">
      <HeaderStyle Width="20px" />
    </RowIndicatorColumn>
  </MasterTableView>
</telerik:RadGrid>

You can also review the forthcoming code library thread for different scenarios:

Manual Update/Insert/Delete with FormTemplate and SQL backend

Not finding the help you need?
Contact Support