Click here to Skip to main content
15,895,084 members

How get selected value of dropdownlist in MVC3

Revision 1
Hi please help me out i want to get selected text from DDL in MVC3

Here is the follwing code

In model
SQL
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

@Html.DropDownList("SelectedValue", (SelectList)Model.Ddl)


Please help me out.
Posted 3-Nov-12 17:43pm by Himanshu Yadav.
Tags: , , ,