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