Winforms - Multi select dropdown list

November 16, 2017 12:37

Menu Script

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mnu_parent](
[MENUPARVAL] [int] NOT NULL,
[MAINMNU] [nvarchar](30) NULL CONSTRAINT [DF__mnu_paren__MAINM__7E6CC920] DEFAULT (NULL),
[STATUS] [bit] NULL CONSTRAINT [DF__mnu_paren__STATU__7F60ED59] DEFAULT (NULL),
CONSTRAINT [PK_mnu_parent] PRIMARY KEY CLUSTERED
(
[MENUPARVAL] 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
/****** Object: Table [dbo].[mnu_submenu] Script Date: 11/16/2017 1:59:38 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mnu_submenu](
[MENUPARVAL] [int] NOT NULL,
[FRM_CODE] [nvarchar](255) NULL,
[FRM_NAME] [nvarchar](255) NULL,
[STATUS] [bit] NULL
) ON [PRIMARY]

GO
UPDATE STATISTICS [dbo].[mnu_submenu] WITH ROWCOUNT = 5, PAGECOUNT = 1
GO
/****** Object: Table [dbo].[mnu_userrole] Script Date: 11/16/2017 1:59:38 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mnu_userrole](
[ID] [int] NULL,
[UID] [int] NULL,
[FRM_CODE] [nvarchar](255) NULL,
[STATUS] [bit] NULL
) ON [PRIMARY]

GO
UPDATE STATISTICS [dbo].[mnu_userrole] WITH ROWCOUNT = 10, PAGECOUNT = 1
GO
/****** Object: Table [dbo].[tbl_user] Script Date: 11/16/2017 1:59:38 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_user](
[UID] [int] NULL,
[UserName] [nvarchar](255) NULL,
[Position] [nvarchar](255) NULL,
[Password] [nvarchar](255) NULL
) ON [PRIMARY]

GO
UPDATE STATISTICS [dbo].[tbl_user] WITH ROWCOUNT = 3, PAGECOUNT = 1
GO
/****** Object: Table [dbo].[vw_pagerole] Script Date: 11/16/2017 1:59:38 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vw_pagerole](
[MENUPARVAL] [int] NULL,
[FRM_NAME] [nvarchar](255) NULL,
[FRM_CODE] [nvarchar](255) NULL,
[UID] [int] NULL,
[STATUS] [bit] NULL
) ON [PRIMARY]

GO
UPDATE STATISTICS [dbo].[vw_pagerole] WITH ROWCOUNT = 0, PAGECOUNT = 0
GO
INSERT [dbo].[mnu_parent] ([MENUPARVAL], [MAINMNU], [STATUS]) VALUES (1, N'Transactions', 1)
INSERT [dbo].[mnu_parent] ([MENUPARVAL], [MAINMNU], [STATUS]) VALUES (2, N'Inventory', 1)
INSERT [dbo].[mnu_parent] ([MENUPARVAL], [MAINMNU], [STATUS]) VALUES (3, N'Test', 1)
INSERT [dbo].[mnu_parent] ([MENUPARVAL], [MAINMNU], [STATUS]) VALUES (4, N'New1', 1)
INSERT [dbo].[mnu_parent] ([MENUPARVAL], [MAINMNU], [STATUS]) VALUES (5, N'Exit', 1)
INSERT [dbo].[mnu_submenu] ([MENUPARVAL], [FRM_CODE], [FRM_NAME], [STATUS]) VALUES (1, N'FrmAccount', N'Accounting', 1)
INSERT [dbo].[mnu_submenu] ([MENUPARVAL], [FRM_CODE], [FRM_NAME], [STATUS]) VALUES (1, N'FrmFinance', N'Finance', 1)
INSERT [dbo].[mnu_submenu] ([MENUPARVAL], [FRM_CODE], [FRM_NAME], [STATUS]) VALUES (3, N'Test', N'Test', 1)
INSERT [dbo].[mnu_submenu] ([MENUPARVAL], [FRM_CODE], [FRM_NAME], [STATUS]) VALUES (5, N'Login', N'Exit', 1)
INSERT [dbo].[mnu_submenu] ([MENUPARVAL], [FRM_CODE], [FRM_NAME], [STATUS]) VALUES (1, N'ManageUser', N'Manage User', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (1, 1001, N'FrmAccount', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (2, 1001, N'FrmFinance', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (3, 1001, N'test', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (4, 1001, N'Login', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (5, 1001, N'ManageUser', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (NULL, 1002, N'FrmAccount', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (NULL, 1002, N'FrmFinance', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (NULL, 1002, N'Test', 0)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (NULL, 1002, N'Login', 1)
INSERT [dbo].[mnu_userrole] ([ID], [UID], [FRM_CODE], [STATUS]) VALUES (NULL, 1002, N'ManageUser', 1)
INSERT [dbo].[tbl_user] ([UID], [UserName], [Position], [Password]) VALUES (1001, N'admin', N'admin', N'a')
INSERT [dbo].[tbl_user] ([UID], [UserName], [Position], [Password]) VALUES (1002, N'jeo', N'User', N'a')
INSERT [dbo].[tbl_user] ([UID], [UserName], [Position], [Password]) VALUES (1003, N'a', N'a', N'a')
/****** Object: Statistic [_WA_Sys_00000003_00551192] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000003_00551192] ON [dbo].[mnu_parent]([STATUS]) WITH STATS_STREAM = 0x0100000001000000000000000000000035AC1FE700000000C801000000000000880100000000000068020000680000000100010000000000000000000000000007000000F752E6002DA8000005000000000000000500000000000000000000000000803F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000100000001000000110000000000803F0000A040000000000000803F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000001C0000000000000024000000000000000800000000000000100011000000A040000000000000803F010400000500000000000000
GO
/****** Object: Statistic [PK_mnu_parent] Script Date: 11/16/2017 1:59:38 PM ******/
UPDATE STATISTICS [dbo].[mnu_parent]([PK_mnu_parent]) WITH STATS_STREAM = 0x010000000100000000000000000000006C32CBA500000000CB010000000000008B01000000000000380300003800000004000A0000000000000000000000000007000000412ED8002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000010000000100000014000000000080400000803F00000000000080400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000001F0000000000000027000000000000000800000000000000100014000000803F000000000000803F010000000400000100000000000000, ROWCOUNT = 5, PAGECOUNT = 1
GO
/****** Object: Statistic [_WA_Sys_00000001_0519C6AF] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000001_0519C6AF] ON [dbo].[mnu_submenu]([MENUPARVAL]) WITH STATS_STREAM = 0x01000000010000000000000000000000C93FB04C00000000EA01000000000000AA01000000000000380300003800000004000A00000000000000000000000000070000007DD6D8002DA80000030000000000000003000000000000000000803FABAAAA3E000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000020000000100000014000000000080400000404000000000000080400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000003E00000000000000460000000000000010000000000000002700000000000000100014000000803F000000000000803F01000000040000100014000000803F0000803F0000803F030000000400000300000000000000
GO
/****** Object: Statistic [_WA_Sys_00000002_0519C6AF] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000002_0519C6AF] ON [dbo].[mnu_submenu]([FRM_CODE]) WITH STATS_STREAM = 0x01000000010000000000000000000000515DD3B000000000AE020000000000006E02000000000000E7020000E7000000FE0100000000000008D00034000000000700000090A4D8002DA800000300000000000000030000000000000000000000ABAAAA3E000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000030000000100000010000000000080410000404000000000000080410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000130000000000000000000000000000008D00000000000000FA000000000000000201000000000000180000000000000043000000000000006E00000000000000300010000000803F000000000000803F04000001002B00460072006D004100630063006F0075006E007400300010000000803F000000000000803F04000001002B00460072006D00460069006E0061006E0063006500300010000000803F000000000000803F04000001001F005400650073007400FF010000000000000003000000030000002800000028000000000000000000000015000000460072006D004100630063006F0075006E007400460069006E0061006E00630065005400650073007400050000004000000000C003000000810703000001070A00000104110000000300000000000000
GO
/****** Object: Statistic [_WA_Sys_00000003_0519C6AF] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000003_0519C6AF] ON [dbo].[mnu_submenu]([FRM_NAME]) WITH STATS_STREAM = 0x0100000001000000000000000000000045436D2700000000A3020000000000006302000000000000E7020000E7000000FE0100000000000008D00034000000000700000090A4D8002DA800000300000000000000030000000000000000000000ABAAAA3E000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000030000000100000010000000000060410000404000000000000060410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000130000000000000000000000000000008700000000000000EF00000000000000F700000000000000180000000000000043000000000000006800000000000000300010000000803F000000000000803F04000001002B004100630063006F0075006E00740069006E006700300010000000803F000000000000803F04000001002500460069006E0061006E0063006500300010000000803F000000000000803F04000001001F005400650073007400FF0100000000000000030000000300000028000000280000000000000000000000150000004100630063006F0075006E00740069006E006700460069006E0061006E00630065005400650073007400040000004000000000810A00000081070A00000104110000000300000000000000
GO
/****** Object: Statistic [_WA_Sys_00000004_0519C6AF] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000004_0519C6AF] ON [dbo].[mnu_submenu]([STATUS]) WITH STATS_STREAM = 0x01000000010000000000000000000000E188481000000000C801000000000000880100000000000068020C0268000000010001000000000000000000FFFFFFFF070000008FA4D8002DA8000003000000000000000300000000000000000000000000803F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000100000001000000110000000000803F00004040000000000000803F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000001C00000000000000240000000000000008000000000000001000110000004040000000000000803F010400000300000000000000
GO
/****** Object: Statistic [_WA_Sys_00000001_07020F21] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000001_07020F21] ON [dbo].[mnu_userrole]([ID]) WITH STATS_STREAM = 0x010000000100000000000000000000003FC0B0B900000000CB010000000000008B0100000000000038020C023800000004000A000000000000000000FFFFFFFF070000000786D9002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000010000000100000014000000000080400000803F00000000000080400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000001F0000000000000027000000000000000800000000000000100014000000803F000000000000803F010000000400000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000002_07020F21] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000002_07020F21] ON [dbo].[mnu_userrole]([UID]) WITH STATS_STREAM = 0x010000000100000000000000000000003B9CE10600000000CB010000000000008B0100000000000038020C023800000004000A000000000000000000FFFFFFFF070000000786D9002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000010000000100000014000000000080400000803F00000000000080400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000001F0000000000000027000000000000000800000000000000100014000000803F000000000000803FE90300000400000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000003_07020F21] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000003_07020F21] ON [dbo].[mnu_userrole]([FRM_CODE]) WITH STATS_STREAM = 0x01000000010000000000000000000000AE17445100000000DB010000000000009B01000000000000E7020000E7000000FE0100000000000008D0003401000000070000000686D9002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000010000000000000000000803F0000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000002F000000000000003700000000000000FF010000000100000001000000010000002800000028000000000000000000000000000000010000000000000000000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000004_07020F21] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000004_07020F21] ON [dbo].[mnu_userrole]([STATUS]) WITH STATS_STREAM = 0x01000000010000000000000000000000E95E9DF300000000A4010000000000006401000000000000680200006800000001000100000000000000000000000000070000000686D9002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000011000000000000000000803F0000803F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000008000000000000000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000001_07F6335A] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000001_07F6335A] ON [dbo].[tbl_user]([UID]) WITH STATS_STREAM = 0x010000000100000000000000000000003751786A00000000CB010000000000008B01000000000000380200003800000004000A000000000000000000010000000700000069F1DA002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000010000000100000014000000000080400000803F00000000000080400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000001F0000000000000027000000000000000800000000000000100014000000803F000000000000803FE90300000400000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000002_07F6335A] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000002_07F6335A] ON [dbo].[tbl_user]([UserName]) WITH STATS_STREAM = 0x01000000010000000000000000000000B7643568000000000B02000000000000CB01000000000000E7020000E7000000FE0100000000000008D00034000000000700000068F1DA002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000010000000100000010000000000000400000803F0000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013000000000000000000000000000000210000000000000057000000000000005F000000000000000800000000000000300010000000803F000000000000803F040000010019006100FF01000000000000000100000001000000280000002800000000000000000000000100000061000200000040000000000101000000000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000003_07F6335A] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000003_07F6335A] ON [dbo].[tbl_user]([Position]) WITH STATS_STREAM = 0x010000000100000000000000000000001AA2F617000000000B02000000000000CB01000000000000E7020000E7000000FE0100000000000008D00034000000000700000068F1DA002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000010000000100000010000000000000400000803F0000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013000000000000000000000000000000210000000000000057000000000000005F000000000000000800000000000000300010000000803F000000000000803F040000010019006200FF01000000000000000100000001000000280000002800000000000000000000000100000062000200000040000000000101000000000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000004_07F6335A] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000004_07F6335A] ON [dbo].[tbl_user]([Password]) WITH STATS_STREAM = 0x010000000100000000000000000000006B0EAAE600000000DB010000000000009B01000000000000E7020000E7000000FE0100000000000008D00034000000000700000067F1DA002DA8000001000000000000000100000000000000000000000000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000010000000000000000000803F0000803F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000002F000000000000003700000000000000FF010000000100000001000000010000002800000028000000000000000000000000000000010000000000000000000100000000000000
GO
/****** Object: Statistic [_WA_Sys_00000001_08EA5793] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000001_08EA5793] ON [dbo].[vw_pagerole]([MENUPARVAL]) WITH STATS_STREAM = 0x0100000001000000000000000000000039E92B750000000040000000000000000000000000000000380200003800000004000A00000000000000000000000000
GO
/****** Object: Statistic [_WA_Sys_00000004_08EA5793] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000004_08EA5793] ON [dbo].[vw_pagerole]([UID]) WITH STATS_STREAM = 0x0100000001000000000000000000000039E92B750000000040000000000000000000000000000000380200003800000004000A00000000000000000000000000
GO
/****** Object: Statistic [_WA_Sys_00000005_08EA5793] Script Date: 11/16/2017 1:59:38 PM ******/
CREATE STATISTICS [_WA_Sys_00000005_08EA5793] ON [dbo].[vw_pagerole]([STATUS]) WITH STATS_STREAM = 0x010000000100000000000000000000007981C3CC0000000040000000000000000000000000000000680200006800000001000100000000000000000000000000
GO