Save Toolstripmenu to SQL Table

Question

Background:

PROGRAM A needs to save entire Toolstripmenu collection to an SQL table, so PROGRAM B can read it and instantiate the toolstripmenu as if it was its own...

If it is possible, please also let me know what SQL datatype should be used...

Many thanks in advance.

Mahesh Chand · Answer

You need to create a Parent/Child relationship in a table and store the menu and menu items. The Table will have a Parent column that will represent the parent of a child. When you load a menu you will load all items at root level and create your main menu and then you find children of a parent and add sub menu items. ID MenuText Parent Level 1 C# Corner 0 0 2 VB.NET Heaven 0 1 3 Longhorn Corner 0 2 4 ADO.NET 1 0 5 GDI+ 1 1 6 WCF 1 2 Something this above. Here C# Corner VB.NET Heaven and Longhorn Corner are root level menu items. C# Corner has 3 sub menus.