MultiCheckbox In ASP.NET MVC

In this article we are going to create a form with a multi-checkboxes option and on form submit store the values.

You will learn more about the following things,

• What is FormCollection and its uses?
• How to do ViewBag stored LIST object iteration
• How to iterate collections of CheckBoxes which are marked as checked

What is FormCollection and Its Uses?

FormCollection class is part of System.Web.MVC .

FormCollection is another way to access the form element in action method of the controller.

Example

How to do ViewBag stored LIST object iteration?

ViewBag is used for transferring the value from Controller to View.

Example

How to iterate collection of CheckBoxes which are marked as checked?

Now back to implementation of the task

Before creating a project now we are going to create a table where we are going to store selected checkbox values.

We are going to create three tables,

SR. NO.	TABLE NAME	DESCRIPTION
1	tblSkills	To manage various types of skills.
2	tblMembers	To manage members information.
3	tblMemberSkills	To manage members skills.

1. tblSkills structure
   
   1. CREATE TABLE tblSkills (
   2. SkillID int NOT NULL PRIMARY KEY Identity,
   3. Title varchar(50),
   4. );

2. tblMembers structure
   
   1. CREATE TABLE [dbo].[tblMembers](
   2. [MemberID] [int] IDENTITY(1,1) NOT NULL,
   3. [MemberName] [varchar](50) NULL,
   4. [Address] [varchar](50) NULL,
   5. [City] [varchar](50) NULL,
   6. PRIMARY KEY CLUSTERED
   7. (
   8. [MemberID] ASC
   9. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
   10. ) ON [PRIMARY]

3. tblMemberSkills structure,
   
   1. CREATE TABLE tblMemberSkills (
   2. MemberSkillID int NOT NULL PRIMARY KEY Identity,
   3. SkillID int,
   4. MemberID int
   5. );

Now insert some data/records into tblSkills

In tblMembers and tblMemberSkills we save the data through coding.

I am using Visual Studio 2015

Now your screen should look like this:

We had created a project called “ “now we are going to add Linq to SQL Class

Now right click on Project name or icon --->Add-->New Item

or

Simply press Ctrl + Shift + A (To add a new item from the dialog box)

I gave it the name “MultiBoxDataClasses.dbml”

Server explorer can be visible / ON by pressing CTRL+ALT+S. Now click on Server Explorer and establish your connection with sql server.

Drag and drop your table on MultiBoxDataClasses.dbml file canvas.

Now switch to solution explorer again and right click on MODELS folder and insert a CLASS file. Give the class file name “MemberEntryModel.cs”

Now switch to solution explorer again and double click on CONTROLLERS folder then HomeController.cs.

In this we are not going to create separate controller for our task we will use HOME controller.

Create an two InsertMember method in HomeController.cs

1. HttpGet
2. HttpPost

• HttpGet - This method will get executed first time in url call.
• HttpPost - This method will get executed while form submitted.

Example