specified cast is not valid while i am trying to bind dropdownlist value to db **I want to Take the value from dropdown from model and when i click on create it should insert into db table instead of inserting deptartment names interger values are assigning to the column Pls help me ** My Model
public Departments DeptNames { get; set; }
public enum Departments
{
ECE=1,
CSE=2,
MECH=3,
CIVIL=4
}
MY Repository
public List<ModelClass> ShowListOfUserDetails()
{
List<ModelClass> models = new List<ModelClass>();
SqlCommand cmd = new SqlCommand("sp_ShowUserDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
con.Open();
da.Fill(dt);
con.Close();
foreach (DataRow dr in dt.Rows)
{
models.Add(new ModelClass
{
Id = Convert.ToInt32(dr["pid"]),
Name = Convert.ToString(dr["namee"]),
City = Convert.ToString(dr["city"]),
Address = Convert.ToString(dr["addresss"]),
Gender = Convert.ToString(dr["gender"]),
DeptNames = (ModelClass.Departments)dr["department"]
});
}
return models;
}
MY View
@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem =>item.Id)
</td>
<td>
@Html.DisplayFor(modelItem => item.Name)
</td>
<td>
@Html.DisplayFor(modelItem => item.City)
</td>
<td>
@Html.DisplayFor(modelItem => item.Address)
</td>
<td>
@Html.DisplayFor(modelItem=>item.Gender)
</td>
<td>
@Html.DisplayFor(modelItem=>item.DeptNames)
</td>
<td>
</tr>