c# 根据数据库动态生成三层treeview导航

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[NT_USER_RIGHT]( [USER_RIGHT_ID] [numeric](15, 0) NOT NULL, [USER_RIGHT_NAME] [varchar](255) NULL, [REMARK] [varchar](255) NULL, [UP_RIGHT_ID] [numeric](15, 0) NULL, CONSTRAINT [NT_USER_RI_2497649162] PRIMARY KEY NONCLUSTERED ( [USER_RIGHT_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 11, '1', '1', NULL ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 13, '2', '2', NULL ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 1101, '1-1', '1-1', 11 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 1102, '1-2', '1-2', 11 ) go go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 1301, '2-1', '2-1', 13 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 1302, '2-2', '2-2', 13 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 110101, '1-1-1', '1-1-1', 1101 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 110102, '1-1-2', '1-1-2', 1101 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 110201, '1-2-1', '1-2-1', 1102 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 130101, '2-1-1', '2-1-1', 1301 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 130102, '2-1-2', '2-1-2', 1301 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 130201, '2-2-1', '2-2-1', 1302 ) go INSERT INTO dbo.NT_USER_RIGHT ( USER_RIGHT_ID, USER_RIGHT_NAME, REMARK, UP_RIGHT_ID ) VALUES ( 130202, '2-2-2', '2-2-2', 1302 ) go