New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

Manual data editing

Next database reset in 0 hours, 53 minutes, 4 seconds

ID	Last Name	First Name	Title	Notes
27	1112222	pileshkiq	Dr.
34	Chutiya Gaandoz	lkkjjjkjlh
35	TT	test-mere
36	xxxxxxxxxxxxxxxx	15
37	Bob	Billy0000
41	H	HH	Mr	HH
42	sssss	mario
43	wqAA	qwqq
45	a	a
46	bbG	bb
47	weqwe	wrqewq
48	eqewqw	weqeqw
49	sdadasdsadasdasdasds	wrqewq
50	Dario	Hernan
51	FHJKJHF	JFGJ555
52	Dario	Hernan
53	123	123
54	dddd444	aaaa
55	123	123
56	Me	Testa
57	a	a
58	Bas	Pa
59	dd	dd
60	Smith	Test
62	a	a
63	Test	Test
64	85	55
68	21e	1e2e
69	1	34
70	yool	sofia
72	G	Y
73	b	a
75	aa	aaaaaa
78	test	test
79	test	test
80	pj	pk
82	1	1
83	1	pk1
84	d	a
85	1	1
86	j	j
87	ccccc	aaaa
88	222	222
89	DSFGSDFGSDFGFD	FDSG	test
90	Bob	Billy
91	Test	th
92	hj	hhgj	Dr.
93	1	1
94	sasdasda	asdas
95	dasda	asdasd
96	adasd	dasd
97	tt	tt
98	No nbv	Cm n en j
99	ádas	sf
102	23	23	Mr.
103	23	23
104	121	523
105	1212	12
106	111	miguel
107	asd	asd
108	asda	asda
109	a	a
110	ginanjar	dani
111	bbbbb	aaaaa
112	xx	xx
113	edward	james
114	Name	My
118	fff	13231231
119	r	l
120	f	f
121	hkheqjkehjqw	eqw
122	Smith	Ed
123	ty	ra
124	a	a
129	test123	test123
131	asd	asd
132	дса	дса
133	сда	дса
134	sad happy	dsa
135	Test	Test
136	aa	aa
137	emmanuel	fedddd
138	Condo	Xtra1
139	bb	aa
140	again	test
141	s	s
143	asdfsss	asdfsss
146	test	test
147	sfsfd	fds

About this demo
C#
VB
Download demo code files
Isolate this demo as a stand-alone application

This demo shows how to manually update/insert items to the database. The new values are extracted from the current item using the ExtractValues method.

Note that, when inserting a child item to a parent data item, the foreign key values (the ReportsTo field in our case, specified by the ParentDataKeyNames array in RadTreeList) are extracted into the Hashtable with ExtractValues. We need to check if the foreign key is present in the Hashtable and add it to the insert parameters. When inserting a root item, however, foreign keys are not populated and thus, DbNull should be explicitly added as a foregn key.

<%@ Page Language="VB" Inherits="Telerik.Web.Examples.TreeList.DataEditing.ManualDataEditing.DefaultVB"CodeFile="DefaultVB.aspx.vb"  %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
<div class="demo-container no-bg">
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"></telerik:RadAjaxLoadingPanel>
    <telerik:RadAjaxPanel ID="RadAjaxPanel1" LoadingPanelID="RadAjaxLoadingPanel1" runat="server">
        <telerik:RadTreeList RenderMode="Lightweight" ID="RadTreeList1" runat="server" OnNeedDataSource="RadTreeList1_NeedDataSource" OnUpdateCommand="RadTreeList1_UpdateCommand" OnInsertCommand="RadTreeList1_InsertCommand" OnDeleteCommand="RadTreeList1_DeleteCommand" ParentDataKeyNames="ReportsTo" DataKeyNames="EmployeeID" AutoGenerateColumns="false">
            <Columns>
                <telerik:TreeListEditCommandColumn UniqueName="InsertCommandColumn" ButtonType="FontIconButton" ShowEditButton="false" HeaderStyle-Width="30px" ItemStyle-HorizontalAlign="Center"></telerik:TreeListEditCommandColumn>
                <telerik:TreeListButtonColumn CommandName="Edit" Text="Edit" UniqueName="EditCommandColumn" ButtonType="FontIconButton" HeaderStyle-Width="30px" ItemStyle-HorizontalAlign="Center"></telerik:TreeListButtonColumn>
                <telerik:TreeListButtonColumn UniqueName="DeleteCommandColumn" Text="Delete" CommandName="Delete" ButtonType="FontIconButton" HeaderStyle-Width="30px"></telerik:TreeListButtonColumn>
                <telerik:TreeListBoundColumn DataField="EmployeeID" HeaderText="ID" ReadOnly="true" UniqueName="EmployeeID" HeaderStyle-Width="60px" ForceExtractValue="Always"></telerik:TreeListBoundColumn>
                <telerik:TreeListBoundColumn DataField="LastName" HeaderText="Last Name" UniqueName="LastName" HeaderStyle-Width="75px"></telerik:TreeListBoundColumn>
                <telerik:TreeListBoundColumn DataField="FirstName" HeaderText="First Name" UniqueName="FirstName" HeaderStyle-Width="75px"></telerik:TreeListBoundColumn>
                <telerik:TreeListBoundColumn DataField="TitleOfCourtesy" HeaderText="Title" UniqueName="Title" HeaderStyle-Width="60px"></telerik:TreeListBoundColumn>
                <telerik:TreeListBoundColumn DataField="Notes" HeaderText="Notes" UniqueName="Notes" HeaderStyle-Width="280px"></telerik:TreeListBoundColumn>
                <telerik:TreeListBoundColumn DataField="ReportsTo" HeaderText="ReportsTo" HeaderStyle-Width="60px" ReadOnly="true" ForceExtractValue="Always"></telerik:TreeListBoundColumn>
            </Columns>
        </telerik:RadTreeList>
    </telerik:RadAjaxPanel>
    </div>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance

Submit a support ticket if you have an active license or trial
Post in the forum if you don't have access to support