How to Insert multiple DropDownList selected value in Database using C# in ASP.Net MVC

Question

Hi Guys  I Am Creating on Project Name As DPR Now within that project one page name as Project now within This Project I Have values name as Project Code Location and Activity Now Project Code and Location is in Project Table and Activity is from Activity Table The Question is I Want to Store Multiple Activity Using Multiselect Drodown list in Database using MVC How to Do this i have lots of Searching but nver get the Answer Please help me

AnandM · Accepted Answer

Hi  sandipAPRefer below articlesMultiple Select MultiSelect DropDownList with CheckBoxes in ASPNet MVC RazorBind Populate Multiple Select MultiSelect ListBox from database using Model in ASPNet MVC Razor

AnandM · Answer

Hi  sandipAPThe article just shows how you can get multiple selected items in code and what you need to do is once you get multiple selected items then insert in those selected items text or value in database like belowPlease read the comments section carefullyHttpPostpublic ActionResult IndexFruitModel fruit    fruitFruits  PopulateFruits    if fruitFruitIds  null            ListltSelectListItemgt selectedItems  fruitFruitsWherep gt fruitFruitIdsContainsintParsepValueToList        string allSelectedItem  3434        foreach var selectedItem in selectedItems                    Here you need to write the insert query for saving the value in database but it will add in row in sql table            string singleSelectedItem  selectedItemText                            if you want to save in single row with comma separated then you need to add the values with comma separated like below            allSelectedItem  selectedItem

How to Insert multiple DropDownList selected value in Database using C# in ASP.Net MVC

Company

Explore

Follow us

Contact Us