中数据库表的值
我是ASP.NET的初学者,所以我可能有愚蠢的问题,但是我需要一些帮助。我有一个模型和控制器主,带有读/写规则。我在Main Controller中有一个创建动作,它有效,但是我需要该字段是下拉列表,并且可以从另一个部门表中进行选项。我已经搜索了答案,但是我没有得到完整的答案。因此,如果可以的话,请帮助我。如果需要,我将编写代码。非常感谢。
MainController
public ActionResult Create()
{
return View();
}
//
// POST: /Main/Create
[HttpPost]
public ActionResult Create(Main main)
{
if (ModelState.IsValid)
{
db.Main.Add(main);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(main);
}
main.cs(型号(
namespace PhoneBook.Models
{
public class Main
{
public int Id { get; set; }
public string F_L_Name { get; set; }
public string Regioni { get; set; }
public string Raioni { get; set; }
public string Department { get; set; }
public string Division { get; set; }
public string Position { get; set; }
public string Mobile { get; set; }
public string I_Phone { get; set; }
public string Email { get; set; }
public int Deleted { get; set; }
public string Comment { get; set; }
public string All_In_One { get; set; }
public DbSet<Department> DepartmentFI { get; set; }
}
}
create.cshtml(view(
@model PhoneBook.Models.Main
@{
ViewBag.Title = "Create";
}
<h2>Create</h2>
@using (Html.BeginForm()) {
@Html.ValidationSummary(true)
<fieldset>
<legend>Main</legend>
<div class="editor-label">
@Html.LabelFor(model => model.F_L_Name)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.F_L_Name)
@Html.ValidationMessageFor(model => model.F_L_Name)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Regioni)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Regioni)
@Html.ValidationMessageFor(model => model.Regioni)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Raioni)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Raioni)
@Html.ValidationMessageFor(model => model.Raioni)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Department)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Department)
@Html.ValidationMessageFor(model => model.Department)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Division)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Division)
@Html.ValidationMessageFor(model => model.Division)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Position)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Position)
@Html.ValidationMessageFor(model => model.Position)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Mobile)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Mobile)
@Html.ValidationMessageFor(model => model.Mobile)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.I_Phone)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.I_Phone)
@Html.ValidationMessageFor(model => model.I_Phone)
</div>
<div class="editor-label">
@Html.LabelFor(model => model.Email)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Email)
@Html.ValidationMessageFor(model => model.Email)
</div>
<p>
<input type="submit" value="Create" />
</p>
</fieldset>
}
<div>
@Html.ActionLink("Back to List", "Index")
</div>
@section Scripts {
@Scripts.Render("~/bundles/jqueryval")
}
使用这样的使用将部门显示为下拉列表
在注意:您需要填充模型。部门使用Controller/Service/P>