Updating values using UserControl/FormTemplate

Contents

At a glance
Installation and deployment
DNN
Licensing
Already using the control
Functional overview
ASP.NET 2.0 Features
Getting Started
Grid columns
Grid rows
Defining Structure
Visible/Enabled conventions
Populating the control with data
AJAX
Sorting
Paging
Scrolling
Grouping
Filtering
Selecting grid items
Insert/Update/Delete records
- DataSourceHelper files used in some of the examples
- Edit mode
- Grid editors
- Data editing support
- Default edit mode for grid items on initial load
- Retrieving original values for edited item
- Retrieving primary key field values for selected items
- Extracting primary key value for parent item in hierarchy on Update/Insert
- Going into edit mode with AJAX double-click
- Update records
  - Updating values in-place and with edit forms
  - Updating values using UserControl/FormTemplate
  - Performing batch updates
- Insert records
- Binding description (.NET 1.x) and Bind() method (.NET 2.0)
- Distinguish edit/insert mode on ItemCreated/ItemDataBound
- Collecting data in a new window
- Validation
- Delete records
- Automatic DataSource operations
- Insert/Update/Delete at database level with queries
- API For Controlling the Automatic Operations
- Error handling automatic operations
- Population/data editing with XmlDataSource control
- CommandItem
- How-to
Hierarchical grid types and Load modes
Design-time support
Controlling visual appearance
Localization/Accessibility
RadGrid export
The control lifecycle
Performance tips and tricks
Getting familiar with server-side API
Getting familiar with client-side API
Telerik RadGrid inheritance
How-to
Troubleshooting
Integration with other controls
Client-side API Reference
API Reference
Need for help

Send comments on this topic.

Insert/Update/Delete records > Update records > Updating values using UserControl/FormTemplate

Visual Basic .NET
C#

Glossary Item Box

Referring Controls in UserControls

Retrieving values on update

The code below shows to retrieve a value from a control in a user control custom edit form in Telerik RadGrid. The example demonstrates how to refer a controls obtaining references to them with the FindControl(controlId) method in such type of edit form. This text can be used to update your DataSource (you can also see this online demo for more info):

VB.NET

Copy Code

Private Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As Telerik.WebControls.GridCommandEventArgs) Handles RadGrid1.UpdateCommand
        Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
        Dim MyUserControl As UserControl = CType(e.Item.FindControl(GridEditFormItem.EditFormUserControlID), UserControl)
        'Locate the changed row in the DataSource
        Dim changedRows As DataRow() = Me.Employees.Select("EmployeeID = " & editedItem.OwnerTableView.DataKeyValues(editedItem.ItemIndex)("EmployeeID"))

        If (Not changedRows.Length = 1) Then
            e.Canceled = True
            Return
        End If
        'Update new values
        Dim newValues As Hashtable = New Hashtable
        newValues("Country") = CType(MyUserControl.FindControl("TextBox7"), TextBox).Text
        newValues("City") = CType(MyUserControl.FindControl("TextBox8"), TextBox).Text
        newValues("Region") = CType(MyUserControl.FindControl("TextBox9"), TextBox).Text
        newValues("HomePhone") = CType(MyUserControl.FindControl("TextBox10"), TextBox).Text
        newValues("BirthDate") = CType(MyUserControl.FindControl("TextBox11"), TextBox).Text
        newValues("TitleOfCourtesy") = CType(MyUserControl.FindControl("ddlTOC"), DropDownList).SelectedItem.Value
        newValues("Notes") = CType(MyUserControl.FindControl("TextBox1"), TextBox).Text
        newValues("Address") = CType(MyUserControl.FindControl("TextBox6"), TextBox).Text
        newValues("FirstName") = CType(MyUserControl.FindControl("TextBox2"), TextBox).Text
        newValues("LastName") = CType(MyUserControl.FindControl("TextBox3"), TextBox).Text
        newValues("HireDate") = CType(MyUserControl.FindControl("Textbox5"), TextBox).Text
        newValues("Title") = CType(MyUserControl.FindControl("TextBox4"), TextBox).Text
        changedRows(0).BeginEdit()
        Try
            Dim entry As DictionaryEntry
            For Each entry In newValues
                changedRows(0)(CType(entry.Key, String)) = entry.Value
            Next
            changedRows(0).EndEdit()
            Me.Employees.AcceptChanges()
        Catch ex As Exception
            changedRows(0).CancelEdit()
            e.Canceled = True
        End Try
End Sub

Copy Code

protected void RadGrid1_UpdateCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
{
           GridEditableItem editedItem = e.Item as GridEditableItem;
           UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
           //Prepare new row to add it in the DataSource
           DataRow[] changedRows = this.Employees.Select("EmployeeID = " + editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["EmployeeID"]);
           if (changedRows.Length != 1)
           {
               RadGrid1.Controls.Add(new LiteralControl("Unable to locate the Employee for updating."));
               e.Canceled = true;
               return;
           }
           //Update new values
           Hashtable newValues = new Hashtable();
           newValues["Country"] = (userControl.FindControl("TextBox7") as TextBox).Text;
           newValues["City"] = (userControl.FindControl("TextBox8") as TextBox).Text;
           newValues["Region"] = (userControl.FindControl("TextBox9") as TextBox).Text;
           newValues["HomePhone"] = (userControl.FindControl("TextBox10") as TextBox).Text;
           newValues["BirthDate"] = (userControl.FindControl("TextBox11") as TextBox).Text;
           newValues["TitleOfCourtesy"] = (userControl.FindControl("ddlTOC") as DropDownList).SelectedItem.Value;
           newValues["Notes"] = (userControl.FindControl("TextBox1") as TextBox).Text;
           newValues["Address"] = (userControl.FindControl("TextBox6") as TextBox).Text;
           newValues["FirstName"] = (userControl.FindControl("TextBox2") as TextBox).Text;
           newValues["LastName"] = (userControl.FindControl("TextBox3") as TextBox).Text;
           newValues["HireDate"] = (userControl.FindControl("Textbox5") as TextBox).Text;
           newValues["Title"] = (userControl.FindControl("TextBox4") as TextBox).Text;
           changedRows[0].BeginEdit();
           try
           {
               foreach (DictionaryEntry entry in newValues)
               {
                   changedRows[0][(string)entry.Key] = entry.Value;
               }
               changedRows[0].EndEdit();
               this.Employees.AcceptChanges();
           }
           catch (Exception ex)
           {
               changedRows[0].CancelEdit();
               RadGrid1.Controls.Add(new LiteralControl("Unable to update Employees. Reason: " + ex.Message));
               e.Canceled = true;
           }
}

Referring controls in FormTemplate

Retrieving values on update

The code below shows to retrieve a value from a control in a form template custom edit form in Telerik RadGrid. The example demonstrates how to refer a controls obtaining references to them with the FindControl(controlId) method in such type of edit form. This text can be used to update your DataSource manually:

Copy Code

private void RadGrid1_ItemCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
{
           if (e.CommandName == RadGrid.UpdateCommandName)
           {
               GridEditableItem editedItem = e.Item as GridEditableItem;
               //Locate the changed row in the DataSource
               DataRow[] changedRows = this.Employees.Select( "EmployeeID = " + editedItem["EmployeeID"].Text );

               if (changedRows.Length != 1)
               {
                   this.Label1.Text += "Unbale to locate the Employee for updating.";
                   e.Canceled = true;
                   return;
               }
               //Update new values
               Hashtable newValues = new Hashtable();
               newValues["Country"] = (editedItem.FindControl("TextBox7") as TextBox).Text;
               newValues["City"] = (editedItem.FindControl("TextBox8") as TextBox).Text;
               newValues["Region"] = (editedItem.FindControl("TextBox9") as TextBox).Text;
               newValues["HomePhone"] = (editedItem.FindControl("TextBox10") as TextBox).Text;
               newValues["BirthDate"] = (editedItem.FindControl("TextBox11") as TextBox).Text;
               newValues["TitleOfCourtesy"] = (editedItem.FindControl("ddlTOC") as DropDownList).SelectedItem.Value;
               newValues["Notes"] = (editedItem.FindControl("TextBox1") as TextBox).Text;
               newValues["Address"] = (editedItem.FindControl("TextBox6") as TextBox).Text;
               newValues["FirstName"] = (editedItem.FindControl("TextBox2") as TextBox).Text;
               newValues["LastName"] = (editedItem.FindControl("TextBox3") as TextBox).Text;
               newValues["HireDate"] = (editedItem.FindControl("Textbox5") as TextBox).Text;
               newValues["Title"] = (editedItem.FindControl("TextBox4") as TextBox).Text;
               changedRows[0].BeginEdit();
               try
               {
                   foreach( DictionaryEntry entry in newValues )
                   {
                       changedRows[0][(string)entry.Key] = entry.Value;
                   }
                   changedRows[0].EndEdit();
               }
               catch( Exception ex )
               {
                   changedRows[0].CancelEdit();
                   Label1.Text += "Unable to update Employees. Reason: " + ex.Message;
                   e.Canceled = true;
               }
               //Code for updating the database can go here...
               Label1.Text += "Employee " + editedItem["EmployeeID"].Text + " updated";
           }
}

VB.NET

Copy Code

Private Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As WebControls.GridCommandEventArgs) Handles RadGrid1.ItemCommand
            If (e.CommandName = RadGrid.UpdateCommandName) Then
                Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
                'Locate the changed row in the DataSource
                Dim changedRows As DataRow() = Me.Employees.Select("EmployeeID = " + editedItem("EmployeeID").Text)
                If (Not changedRows.Length = 1) Then
                    Me.Label1.Text += "Unbale to locate the Employee for updating."
                    e.Canceled = True
                    Return
                End If
                'Update new values
                Dim newValues As Hashtable = New Hashtable
                newValues("Country") = CType(editedItem.FindControl("TextBox7"), TextBox).Text
                newValues("City") = CType(editedItem.FindControl("TextBox8"), TextBox).Text
                newValues("Region") = CType(editedItem.FindControl("TextBox9"), TextBox).Text
                newValues("HomePhone") = CType(editedItem.FindControl("TextBox10"), TextBox).Text
                newValues("BirthDate") = CType(editedItem.FindControl("TextBox11"), TextBox).Text
                newValues("TitleOfCourtesy") = CType(editedItem.FindControl("ddlTOC"), DropDownList).SelectedItem.Value
                newValues("Notes") = CType(editedItem.FindControl("TextBox1"), TextBox).Text
                newValues("Address") = CType(editedItem.FindControl("TextBox6"), TextBox).Text
                newValues("FirstName") = CType(editedItem.FindControl("TextBox2"), TextBox).Text
                newValues("LastName") = CType(editedItem.FindControl("TextBox3"), TextBox).Text
                newValues("HireDate") = CType(editedItem.FindControl("Textbox5"), TextBox).Text
                newValues("Title") = CType(editedItem.FindControl("TextBox4"), TextBox).Text
                changedRows(0).BeginEdit()
                Try
                    Dim entry As DictionaryEntry
                    For Each entry In newValues
                        changedRows(0)(CType(entry.Key, String)) = entry.Value
                    Next
                    changedRows(0).EndEdit()
                Catch ex As Exception
                    changedRows(0).CancelEdit()
                    Label1.Text += "Unable to update Employees. Reason: " & ex.Message
                    e.Canceled = True
                End Try
                'Code for updating the database can go here...
                Label1.Text += "Employee " & editedItem("EmployeeID").Text & " updated"
            ElseIf e.CommandName = "PerformInsert" Then
                Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
                'Create new row in the DataSource
                Dim newRow As DataRow = Me.Employees.NewRow
                Dim newValues As Hashtable = New Hashtable
                'Insert new values
                newValues("Country") = CType(editedItem.FindControl("TextBox7"), TextBox).Text
                newValues("City") = CType(editedItem.FindControl("TextBox8"), TextBox).Text
                newValues("Region") = CType(editedItem.FindControl("TextBox9"), TextBox).Text
                newValues("HomePhone") = CType(editedItem.FindControl("TextBox10"), TextBox).Text
                newValues("BirthDate") = CType(editedItem.FindControl("TextBox11"), TextBox).Text
                newValues("TitleOfCourtesy") = CType(editedItem.FindControl("ddlTOC"), DropDownList).SelectedItem.Value
                newValues("Notes") = CType(editedItem.FindControl("TextBox1"), TextBox).Text
                newValues("Address") = CType(editedItem.FindControl("TextBox6"), TextBox).Text
                newValues("FirstName") = CType(editedItem.FindControl("TextBox2"), TextBox).Text
                newValues("LastName") = CType(editedItem.FindControl("TextBox3"), TextBox).Text
                newValues("HireDate") = CType(editedItem.FindControl("Textbox5"), TextBox).Text
                newValues("Title") = CType(editedItem.FindControl("TextBox4"), TextBox).Text
                'make sure that unique primary key value is generated for the inserted row
                newValues("EmployeeID") = (CType(Me.Employees.Rows((Me.Employees.Rows.Count - 1))("EmployeeID"), Integer) + 1)
                Try
                    Dim entry As DictionaryEntry
                    For Each entry In newValues
                        newRow(CType(entry.Key, String)) = entry.Value
                    Next
                    Me.Employees.Rows.Add(newRow)
                    Me.Employees.AcceptChanges()
                Catch ex As Exception
                    RadGrid1.Controls.Add(New LiteralControl(("Unable to update/insert Employees. Reason: " + ex.Message)))
                    e.Canceled = True
                End Try
            End If
End Sub

Note that with form template you may prefer the codeless approach by enabling the automatic operations supported by Telerik RadGrid.

RadGrid for ASP.NET

Referring Controls in UserControls

Retrieving values on update

Referring controls in FormTemplate

Retrieving values on update