How to Store multiple checkbox values in Database using MVC?

Amit Makhija

Hello Sir,

I want to store multiple selected checkbox values in a single coloumn of table of MS SQL Database on click on submit button using MVC without use of Entity Framework.

Please Clarify this how it is done?

After that...

I also want to fetch this Multiple checkbox values(which already stored by admin in database) fetch from single coloumn of table of database & this fetch valTues show in form of checkbox selected values in view page of MVC.

This is my 2 queries....Please give me the answer how it is possible..??

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano8y ago
Here: https://www.aspsnippets.com/Articles/Save-Insert-multiple-CheckBoxes-CheckBoxList-values-to-database-in-ASPNet-MVC.aspx
Jayakumar Balasubramaniam8y ago
Hi Amit,

In MVC we can achieve this logic by using the logic like below, for the all the checkboxes you use in your view give the same name like below,
<input type="checkbox" name="chkMulti" value="Test 1" />
<input type="checkbox" name="chkMulti" value="Test 2" />
<input type="checkbox" name="chkMulti" value="Test 3" />
In your controller you just look for the FormValues of chkMulti, you will get the selected values as string separated with Commas. Save it in DB.