Following is the table structure, and code for creating and filling the n level heirarchical treeview control using Recursion on your web (aspx) page, In my case I used the Component Art grid control, It can be any heirarchical control with Node property.Here is an assumption that there is a TreeviewControl On your page. Table Structure [ID] [Data] [ParentId]101 Node1 Null102 Node2 Null103 Node1_Node1 101104 Node1_Node2 101 105 Node2_Node1 102 106 Node2_Node2 102107 Node2_Node1_Node1 102 Function ......
By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions: ERROR: MSDTC on server 'servername' is unavailable. RESOLUTIONOn the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL ......