how to get value in dropdown list from to db in mvc?

Anjali Khan

9y1.3k.NET

Hi frnds

i am updating form in db with dropdown list in mvc

it is working fine also means updating in db.

but once i select form for update here dropdown list coimng blank i want which value i select for inserting same value should be come
when i updating in dropdown list

6 Replies

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

Anjali Khan9y ago
Hi Already post data also..it is inserted properly.now want to edit and update so edit time not bind the perticular value which i select n inserted.
Gnanavel Sekar9y ago
before posting data hold that selected value in variable/state's after posting data to db, Once the post happen rebind the dropdown as well as set as selected value whatever you holded in variable/stat's..

Note: Rebind dropdown after post, and manaually assign selected value from serverside or view itself
Anjali Khan9y ago
i want which i insert the data in data base that value should be come when i want to update and save
but its not coming value.
Joginder Banger9y ago
I clear every thing where you stuck???
Anjali Khan9y ago
Hi joginder

these my dropdown

@Html.LabelFor(model => model.Type, new { @class = "control-label col-md-2" })

@Html.DropDownListFor(model => model.TYPE, new SelectList((System.Collections.IEnumerable)ViewData["ListCriteriaType"], "Value", "Text"), new { @class = "dropdown-header" })
@Html.ValidationMessageFor(model => model.TYPE, "", new { @class = "text-danger" })

@Html.LabelFor(model => model.Data, new { @class = "control-label col-md-2" })

@Html.DropDownListFor(model => model.Data, new SelectList((System.Collections.IEnumerable)ViewData["ListCriteriaType"], "Value", "Text"), new { @class = "dropdown-header" })
@Html.ValidationMessageFor(model => model.Data, "", new { @class = "text-danger" })

and controller

public ActionResult Update(int id)
{
updateViewModel um = new updateViewModel ();
um.INCIDENT_ID = id;

Filldata();
return View(um);

}

public ActionResult Update(dataViewModel objModel, SessionViewModel s)
{
try
{
if (ModelState.IsValid)
{

(dataViewModel obj = new (dataViewModel ();
string loginId = SessionManagement.GetSessionValue(SessionManagement.SessionType.Login);
var sessionVal = objLoginDl.GetServiceSessionValues(loginId);

if (result.IsSuccess == true)
TempData["Msg"] = SuccessMessage.Replace("##msg##", result.Message);
else
TempData["Msg"] = FailureMessage.Replace("##msg##", result.Message);
(dataViewModel obj1 = new (dataViewModel ();

ModelState.Clear();
}
}
Joginder Banger9y ago
first you store the select value in controller like

Set the Value:

TempData["ddselected"]="some values";

Get the Value and set in dropdownlist.
$(document).ready(function () {
if(@TempData["ddselected"]!='')

{         $('#TemplateId').find('option[value=@TempData["ddselected"]]').attr('selected','selected');

}
      });