Using Inplace and EditForms Modes

When you want to do manual updates of the treelist data source, in order to do so, you need to get hold of the edited values in the edit form before performing your custom updating logic. This article will elaborate on the two ways to access these values.

Accessing the edited values using ExtractValuesFromItem() method

The ExtractValuesFromItem(dictionaryObject, editableItem, includePrimaryKey) method of RadTreeList takes the following arguments:

• IDictionary dictionaryObject - the collection which will hold the values, using the column UniqueName of each edit field as a key.

• TreeListEditableItem - the current editable item from which the values will be extracted.

• bool includePrimaryKey - indicates whether the primary key value for the current item should be extracted along with the other values.

It would be easy to recognize the currently updated item by its DataKeyValue if the includePrimaryKey is true, thus including this value in the dictionary object.

<telerik:RadTreeList RenderMode="Lightweight" ID="RadTreeList1" runat="server" DataKeyNames="EmployeeID" ParentDataKeyNames="ReportsTo"
    AutoGenerateColumns="false" DataSourceID="SqlDataSource1"
    OnUpdateCommand="RadTreeList1_UpdateCommand">
    <Columns>
        <telerik:TreeListBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" UniqueName="EmployeeID"
            ReadOnly="true" />
        <telerik:TreeListBoundColumn DataField="LastName" HeaderText="LastName" UniqueName="LastName" />
        <telerik:TreeListBoundColumn DataField="FirstName" HeaderText="FirstName" UniqueName="FirstName" />
        <telerik:TreeListBoundColumn DataField="Title" HeaderText="Title" UniqueName="Title" />
        <telerik:TreeListDateTimeColumn DataField="HireDate" HeaderText="HireDate" UniqueName="HireDate" />
        <telerik:TreeListBoundColumn DataField="ReportsTo" HeaderText="ReportsTo" UniqueName="ReportsTo"
            ReadOnly="true" />
        <telerik:TreeListEditCommandColumn UniqueName="EditColumn" />
    </Columns>
</telerik:RadTreeList>

protected void RadTreeList1_UpdateCommand(object sender, TreeListCommandEventArgs e)
{
    //Canceling out the automatic data source operation (needed if you use a data source control)
    e.Canceled = true;


    //Using the ExtractValuesFromItem() method to get hold of the edited values
    System.Collections.Specialized.OrderedDictionary newValues = new System.Collections.Specialized.OrderedDictionary();
    TreeListEditableItem editedItem = e.Item as TreeListEditableItem;
    e.Item.OwnerTreeList.ExtractValuesFromItem(newValues, editedItem, true);


    //Updating logic follows, this part depends on your own custom way of performing CRUD operations
    SqlDataSource1.UpdateParameters["EmployeeID"].DefaultValue = newValues["EmployeeID"].ToString();
    SqlDataSource1.UpdateParameters["LastName"].DefaultValue = newValues["LastName"].ToString();
    SqlDataSource1.UpdateParameters["FirstName"].DefaultValue = newValues["FirstName"].ToString();
    SqlDataSource1.UpdateParameters["Title"].DefaultValue = newValues["Title"].ToString();
    SqlDataSource1.UpdateParameters["HireDate"].DefaultValue = newValues["HireDate"].ToString();

    SqlDataSource1.Update();

    //Closing the edit form and rebinding the treelist control
    RadTreeList1.EditIndexes.Clear();
    RadTreeList1.Rebind();
}

Protected Sub RadTreeList1_UpdateCommand(ByVal sender As Object, ByVal e As TreeListCommandEventArgs) Handles RadTreeList1.UpdateCommand

    'Canceling out the automatic data source operation (needed if you use a data source control)
    e.Canceled = True


    'Using the ExtractValuesFromItem() method to get hold of the edited values
    Dim newValues As New System.Collections.Specialized.OrderedDictionary()
    Dim editedItem As TreeListEditableItem = CType(e.Item, TreeListEditableItem)
    e.Item.OwnerTreeList.ExtractValuesFromItem(newValues, editedItem, True)


    'Updating logic follows, this part depends on your own custom way of performing CRUD operations
    SqlDataSource1.UpdateParameters("EmployeeID").DefaultValue = newValues("EmployeeID").ToString()
    SqlDataSource1.UpdateParameters("LastName").DefaultValue = newValues("LastName").ToString()
    SqlDataSource1.UpdateParameters("FirstName").DefaultValue = newValues("FirstName").ToString()
    SqlDataSource1.UpdateParameters("Title").DefaultValue = newValues("Title").ToString()
    SqlDataSource1.UpdateParameters("HireDate").DefaultValue = newValues("HireDate").ToString()

    SqlDataSource1.Update()

    'Closing the edit form and rebinding the treelist control
    RadTreeList1.EditIndexes.Clear()
    RadTreeList1.Rebind()
End Sub

Accessing the insert values using column editors

This can be achieved by getting hold of the current editable item and then accessing each column editor by column UniqueName. Then you just get the value from the control that the editor holds by using the control's own API.

If you need to access the DataKeyValue of the currently edited item, you should keep in mind that the TreeListEditableItem should be cast to TreeListDataItem if you are using InPlace edit mode, and to TreeListEditFormItem if you are using EditForms . Then you can use the GetDataKeyValue("DataKeyNames") method.

<telerik:RadTreeList RenderMode="Lightweight" ID="RadTreeList2" runat="server" DataKeyNames="EmployeeID" ParentDataKeyNames="ReportsTo"
    AutoGenerateColumns="false" DataSourceID="SqlDataSource1"
    OnUpdateCommand="RadTreeList2_UpdateCommand">
    <Columns>
        <telerik:TreeListBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" UniqueName="EmployeeID"
            ReadOnly="true" />
        <telerik:TreeListBoundColumn DataField="LastName" HeaderText="LastName" UniqueName="LastName" />
        <telerik:TreeListBoundColumn DataField="FirstName" HeaderText="FirstName" UniqueName="FirstName" />
        <telerik:TreeListBoundColumn DataField="Title" HeaderText="Title" UniqueName="Title" />
        <telerik:TreeListDateTimeColumn DataField="HireDate" HeaderText="HireDate" UniqueName="HireDate" />
        <telerik:TreeListBoundColumn DataField="ReportsTo" HeaderText="ReportsTo" UniqueName="ReportsTo"
            ReadOnly="true" />
        <telerik:TreeListEditCommandColumn UniqueName="EditColumn" />
    </Columns>
</telerik:RadTreeList>

protected void RadTreeList2_UpdateCommand(object sender, Telerik.Web.UI.TreeListCommandEventArgs e)
{
    //Canceling out the automatic data source operation (needed if you use a data source control)
    e.Canceled = true;

    //Accessing the DataKeyValue of the edited item, which is used to recognize the edited row in the data source
    TreeListEditFormItem editedItem = (e.Item as TreeListEditFormItem);
    string dataKeyValue = editedItem.ParentItem.GetDataKeyValue("EmployeeID").ToString();

    //For InPlace editing, these two lines would be:
    //TreeListDataItem editedItem = (e.Item as TreeListDataItem);
    //string dataKeyValue = editedItem.GetDataKeyValue("EmployeeID");

    //Accessing the values of the edited item through the column editors
    string lastName = (editedItem.GetColumnEditor("LastName") as TreeListTextBoxColumnEditor).TextBoxControl.Text;
    string firstName = (editedItem.GetColumnEditor("FirstName") as TreeListTextBoxColumnEditor).TextBoxControl.Text;
    string title = (editedItem.GetColumnEditor("Title") as TreeListTextBoxColumnEditor).TextBoxControl.Text;
    DateTime? hireDate = (editedItem.GetColumnEditor("HireDate") as TreeListDateTimeColumnEditor).DatePickerControl.SelectedDate;

    //Updating logic follows, this part depends on your own custom way of performing CRUD operations
    SqlDataSource1.UpdateParameters["EmployeeID"].DefaultValue = dataKeyValue;
    SqlDataSource1.UpdateParameters["LastName"].DefaultValue = lastName;
    SqlDataSource1.UpdateParameters["FirstName"].DefaultValue = firstName;
    SqlDataSource1.UpdateParameters["Title"].DefaultValue = title;
    SqlDataSource1.UpdateParameters["HireDate"].DefaultValue = hireDate.ToString();
    SqlDataSource1.Update();

    //Closing the edit form and rebinding the treelist control
    RadTreeList2.EditIndexes.Clear();
    RadTreeList2.Rebind();
}

Protected Sub RadTreeList1_UpdateCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.TreeListCommandEventArgs) Handles RadTreeList1.UpdateCommand
    'Canceling out the automatic data source operation (needed if you use a data source control)
    e.Canceled = True

    'Accessing the DataKeyValue of the edited item, which is used to recognize the edited row in the data source
    Dim editedItem As TreeListEditFormItem = CType(e.Item, TreeListEditFormItem)
    Dim dataKeyValue As String = editedItem.ParentItem.GetDataKeyValue("EmployeeID").ToString()

    'For InPlace editing, the last two lines would be:
    'Dim editedItem As TreeListDataItem = CType(e.Item, TreeListDataItem)
    'Dim dataKeyValue As String = editedItem.GetDataKeyValue("EmployeeID")

    'Accessing the values of the edited item through the column editors
    Dim lastName As String = CType(editedItem.GetColumnEditor("LastName"), TreeListTextBoxColumnEditor).TextBoxControl.Text
    Dim firstName As String = CType(editedItem.GetColumnEditor("FirstName"), TreeListTextBoxColumnEditor).TextBoxControl.Text
    Dim title As String = CType(editedItem.GetColumnEditor("Title"), TreeListTextBoxColumnEditor).TextBoxControl.Text
    Dim hireDate As System.Nullable(Of DateTime) = CType(editedItem.GetColumnEditor("HireDate"), TreeListDateTimeColumnEditor).DatePickerControl.SelectedDate


    'Updating logic follows, this part depends on your own custom way of performing CRUD operations
    SqlDataSource1.UpdateParameters("EmployeeID").DefaultValue = dataKeyValue
    SqlDataSource1.UpdateParameters("LastName").DefaultValue = lastName
    SqlDataSource1.UpdateParameters("FirstName").DefaultValue = firstName
    SqlDataSource1.UpdateParameters("Title").DefaultValue = title
    SqlDataSource1.UpdateParameters("HireDate").DefaultValue = hireDate.ToString()
    SqlDataSource1.Update()

    'Closing the edit form and rebinding the treelist control
    RadTreeList1.EditIndexes.Clear()
    RadTreeList1.Rebind()
End Sub