How to store multiple listbox values in db using asp.net mvc

Question

Hi all i want to store multiple listbox values in database using mvcs please provide soultion regarding this.

Nilesh Shah · Answer

did any answer work for you? If the reply was helpful then please mark it as Answer. Please close this question if you don't need any more answer posts. Thanks!

Rajkiran Swain · Answer

In Controller Part:- public bool ReportToFavourites(ReportsModel model) { var NewReport = new Report { TableName=model.Tables ColumnName=model.SelectedFields }; bool Result = DBFunctionOBj.SaveNewReportToFavourites(NewReport); return Result; } In view Part:- @Html.ListBoxFor(m => m.SelectedFields new SelectList( new [] {  }) new { @ class = form-control editable })

Nilesh Shah · Answer

you have not provided what your DB table structure is anyways you can get all the selected values of listbox in a string variable separated by comma or some other special character then pass this to a stored procedure and in SQL SP separate values and insert into table. this is generic solution if you want some specific solution provide your details of table and UI etc.