Dynamically Remove MenuItem and Its ChildItem

Hi,

Inorder to delete Menus, first you need to delete the Child Menus and then delete the Parent Menu.

DECLARE @MenuId INT = 2
-- Delete Child Menu
DELETE FROM Menus WHERE ParentMenuId = @MenuId
-- Delete Parent Menu
DELETE FROM Menus WHERE MenuId = @MenuId

Ok thanks Joey. Kindly demonstrate this answer with above link

How you want to delete the node.

Are you using TextBox with Button, or Node click to delete the record?

Please elaborate.

Thanks. For example if Textbox value is A then button click to remove both parent and child in the referenced DB Menu structure

Although i would like it more if the foreach loop is modified to remove the menu nodes of Services, Consulting and Outsourcing

Check foreach recursive used in 

https://www.aspsnippets.com/Articles/941/Database-driven-ASPNet-Menu-control-Populating-Menu-items-from-the-Database-in-ASPNet-using-C-and-VBNet/