Pass dropdown lselected item back to controller

Question

I am trying to pass the selected item in a dropdown list back to the controller to fire a stored procedure.

Controller that populates the list:

public ActionResult Activate()
{
    var query = db.Certificates
                  .Where(a => a.Active == "Y")
                  .Select(cer => cer.CertificateNumber.Substring(0, 4))
                  .Distinct()
                  .OrderBy(cer => cer);

    ViewBag.BoxNumber = new SelectList(query.ToList());

    return View();
}

View I want tet the value from.

@{
    ViewBag.Title = "Activate";
}
<h2>@ViewBag.Title.</h2>
<h3>@ViewBag.Message</h3>

@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()
    @Html.DropDownList("BoxNumber", String.Empty)
    <input type="submit" value="Activate" class="btn btn-default" />
}

Action I want to use it in:

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Activate(string BoxNumber)
{
    var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["GrandCelebration"].ConnectionString);

    var command = new SqlCommand("ActivateCertificates", connection);
    command.CommandType = CommandType.StoredProcedure;
    command.Parameters.AddWithValue("@BoxNumber", BoxNumber);

    connection.Open();

    command.ExecuteNonQuery();

    connection.Close();

    return RedirectToAction("Activate");
}

The selected item is not being returned.

check this question, I answered in detail there: http://stackoverflow.com/questions/27901175/how-to-get-dropdownlist-selectedvalue-in-controller-in-mvc4 — Ehsan Sajjad, Jan 15 '15 at 15:26
Also check this one :http://stackoverflow.com/questions/27916642/there-is-no-viewdata-item-of-type-ienumerableselectlistitem-that-has-the-key — Ehsan Sajjad, Jan 15 '15 at 15:29
you can upvote my answer which helped you as a thanks to me..:) — Ehsan Sajjad, Jan 15 '15 at 16:08

Pass dropdown lselected item back to controller

0 Answers0