Insert, update and preview
with CheckBoxList in asp.net using c#.
USE
[PrasaTest]
GO
/******
Object: Table [dbo].[HandicappedType] Script Date: 06/05/2013 10:18:49
******/
SET
ANSI_NULLS ON
GO
SET
QUOTED_IDENTIFIER ON
GO
SET
ANSI_PADDING ON
GO
CREATE
TABLE [dbo].[HandicappedType](
[SlNo] [bigint]
IDENTITY(1,1)
NOT NULL,
[Name] [varchar](50)
COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL,
[HandicappedType] [varchar](max)
COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL,
[IsSelected] [bit]
NOT NULL
)
ON [PRIMARY]
GO
SET
ANSI_PADDING OFF
USE
[PrasaTest]
GO
/******
Object: Table [dbo].[Category] Script Date: 06/05/2013 10:18:43 ******/
SET
ANSI_NULLS ON
GO
SET
QUOTED_IDENTIFIER ON
GO
SET
ANSI_PADDING ON
GO
CREATE
TABLE [dbo].[Category](
[Id] [bigint]
IDENTITY(1,1)
NOT NULL,
[Handicap_Type] [varchar](50)
COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL
)
ON [PRIMARY]
GO
SET
ANSI_PADDING OFF