How get selected value of dropdownlist in MVC3
Revision 2
Hi please help me out i want to get selected text from DDL in MVC3
Here is the follwing code
In model
public SelectList Ddl { get; set; }
public List<SelectListItem> SelectedValue { get; set; }
In controler for filling the DDL
public ActionResult Create()
{
InsertEmp obj = new InsertEmp();
SqlConnection con = GetConnection.GetDbConnection();
SqlCommand cmd = new SqlCommand("select text,value from gender", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
Dictionary<string,> items = new Dictionary<string,>();
foreach (DataRow dr in dt.Rows)
{
items.Add(dr["Value"].ToString(), dr["text"].ToString());
}
obj.Ddl = new SelectList(items, "Key", "Value");
return View(obj);
}
while i am trying to insert selected value i am getting null(in controler)
[HttpPost]
public ActionResult Create(MVCTOSQL.Models.InsertEmp insEmp)
{
if (ModelState.IsValid)
{
string empName = insEmp.EmpName;
SqlConnection con = GetConnection.GetDbConnection();
SqlCommand cmd = new SqlCommand("pInsEmpDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmpName", SqlDbType.VarChar, 50).Value = insEmp.EmpName;
cmd.Parameters.Add("@EmpFName", SqlDbType.VarChar, 50).Value = insEmp.EmpFName;
cmd.Parameters.Add("@MartialStatus", SqlDbType.VarChar, 50).Value = insEmp.MartialStatus;
cmd.Parameters.Add("@Sex", SqlDbType.VarChar, 50).Value =insEmp.SelectedValue;
cmd.Parameters.Add("@Desig", SqlDbType.VarChar, 50).Value = insEmp.Desig;
cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50).Value = insEmp.Address;
cmd.ExecuteNonQuery();
}
return View(insEmp);
}
In view:
<table><tbody><tr><td style="width:80%;text-align:left">
@Html.DropDownList("SelectedValue", (SelectList)Model.Ddl)
</td></tr></tbody></table>
Please help me out.
Posted 3-Nov-12 17:43pm
by
Himanshu Yadav.