Delete middel node in sql

[Herman]

Please give code example on

I populate my treeview from sql example
Column Name : ID
Column Name : Catalogue
Column Name : ParentID

Data

1    Cataloge1      null
2.   Catalogue2    1
3.   Catalogue3    2

The tree look like this
  

• Catalogue1

              Catalogue2
                       Catalogue3
I want to delete the middel node "Catalogue2" then node 3 "Catalogue3" must move 1 up so the tree just have 2 nodes
    

• Catalogue1

              Catalogue3
How do i do this when treeview is populated from sql  

    

[Nikolay Tsenkov]

Hello Herman,

 Here is a nice and complete overview of Binding in RadTreeView: http://www.telerik.com/help/aspnet-ajax/treeview-data-binding-overview.html

The binding in all navigational controls in RadControls for ASP.NET AJAX is single-directional.
You need to manually apply changes to your data source on the proper events.

For example if you delete nodes using the context menu of RadTreeView, then you can handle the ContextMenuItemClicked server event (attaching the handler in the declaration of the TreeView - e.g. <telerik:RadTreeView runat="server" ID="RadTreeView1" ... OnContextMenuItemClicked="RadTreeView1_ContextMenuItemClicked"...>...</telerik:RadTreeView>) and query the data source accordingly.

I hope this helps.

Regards,
Nikolay Tsenkov
the Telerik team

[Herman]

Sorry still don't come right please see if you can help me with some code

[Herman]

never mind got i working with a store procedure