How to store multiple dropdown check box values in database in MVC C#

Accepted answer

You can pass all selected checkbox values as a comma seperated string in query. In database side, you can split that string in insert to table operation.

+1

Rachit Patel5y ago

Hi Balaji,

If your dropdown list has fixed value then you can store that value in enum like below.

public enum SignerRole

{

val1 = 1,

val2 = 2,

val3 = 4,

val4 = 8,

val5 = 16,

val6 = 32,

val7 = 64,

val8 = 128,

val9 = 256,

val10 = 512

}

if user selected (val1, val4 , val6) then you can sum value like ( 1 + 8 + 32) = 41 and stored in database.

now, in c# you can check selected value exist or not by below code.

dbValue.HasFlag(SignerRole.val1))

+1

Salman Beg5y ago

See this below link, https://www.aspsnippets.com/Articles/Multiple-Select-Multi-Select-DropDownList-with-CheckBoxes-in-ASPNet-MVC-Razor.aspx In the above link it is mentioned how to retrieve multiple checkbox value and after that save those values in database. Thanks

+1