MVC Dropdown list bind

Anilananda Chakrabortty

I am using code first approach

[Table("tblDepartment")]
public class Department
{
[DatabaseGenerated(DatabaseGeneratedOption.Identity), Key]
public int id { get; set; }
[Required(ErrorMessage = "Plz enter department name")]
public string deptName { get; set; }
[Column(TypeName = "nvarchar"), MaxLength(500)]
public string deptDescriptions { get; set; }
public virtual ICollection Students { get; set; }
}
[Table("tblStudents")]
public class Student
{
[DatabaseGenerated(DatabaseGeneratedOption.Identity), Key]
public int stu_id { get; set; }
[Required(ErrorMessage = "Plz enter Students name")]
public string stuName { get; set; }
public int age { get; set; }
// Foreign key
public int id { get; set; }
// Navigation properties
public virtual Department Department { get; set; }
}

here the database context

public DatabaseContext()
: base("StudentDatabase")
{
Database.SetInitializer(new CreateDatabaseIfNotExists());
}
public DbSet Departments { get; set; }
public DbSet Student { get; set; }

First class Departments i completed CRUD operation, but problem with the second class...

I want the department name should display in the Student view page, and when i will submit the details of a student in the database it should save only department id , but in view i want to see all the department name inside a dropdown list , form there i'll select a department and will submit....

i have no idea how to do that ... i am new in MVC ... can anyone help me plz???

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhrutika Rathod8y ago
Accepted answer
In submit, you will get "StateID" as defined in view as below:

@Html.DropDownListFor(m => m.StateID, new SelectList(Model.States, "StateID", "State"), "--Select State--", new { id = "StateID", Name = "StateID", placeholder = "State", @class = "form-control" })

When you submit the form you will get the selected value in "StateID" in your model at controller side.
Anilananda Chakrabortty8y ago
got it .. thank you so much

@Dhrutika Rathod
Anilananda Chakrabortty8y ago
In submit how i will get the id form dropdown list ?
Dhrutika Rathod8y ago
In view

@Html.DropDownListFor(m => m.StateID, new SelectList(Model.States, "StateID", "State"), "--Select State--", new { id = "StateID", Name = "StateID", placeholder = "State", @class = "form-control" })

In Controller,

var s = new StateViewModel();
s.States= entities.Statelist.ToList();
return View(s);