Click here to Skip to main content
15,896,726 members

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
C#
public SelectList Ddl { get; set; }
       public List<SelectListItem> SelectedValue { get; set; }


In controler for filling the DDL

C#
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)
C#
[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
<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.
Tags: , , ,