how to multi select the data from drop down and save it in sql as csv

Question

Good Morning, how to multi select the data from drop down and save it in sql as comma seperated value using ASP.Net core 6?

Sachin Singh · Answer

public class Person // Main EF class { public int Id { get; set; } public string Name { get; set; } } public class MultiDropDownListViewModel //View model for get { public string Name { get; set; } public List ItemList { get; set; } } public class PostSelectedViewModel (view model for post) { public string[] SelectedNames { get; set; } } public IActionResult Index() { var data = new List { new MultiDropDownListViewModel { Name= "Sachin" }, new MultiDropDownListViewModel { Name= "singh" }, }; MultiDropDownListViewModel model = new (); model.ItemList = data.Select(x => new SelectListItem { Text = x.Name, Value = x.Name}).ToList(); return View(model); } @model MultiSelectAspNet.Models.MultiDropDownListViewModel @{ ViewData[ "Title" ] = "Home Page" ; } class = "container" > class = "card" > class = "card-text text-center" > Multi Dropdownlist example "Home" asp-action= "PostSelectedValues" > class = "card-body" > class = "row" > class = "col" > "dropDownList-example" name= "SelectedNames" asp-items= "@Model.ItemList" multiple class = "form-control" > "submit" value= "Save" class = "btn btn-primary" /> [HttpPost] public IActionResult PostSelectedValues(PostSelectedViewModel model) { var str = String.Join( "," , model.SelectedNames); _context.Persons.Add(str); _context.SaveChanges(); return View(); }