我希望技術框將顯示在Create的下拉串列中

我希望我的技術文本框將顯示在下拉串列中，但課程不同專案是一個課程，技術是另一個課程，例如

public class Project
    {
        public int ProjectId { get; set; }

        [StringLength(60, MinimumLength = 3)]
        [Required]
        public string? ProjectName { get; set; }

        [Required]
        public string? Description { get; set; }

        [Required]
        public DateTime Start { get; set; }

        public DateTime? End { get; set; }

        [Required]
        public string? ProjectHead { get; set; }

        [Required]
        public string? Status { get; set; }

        public string? Technology { get; set; }

        public ICollection<ProjectTechnology>? ProjectTechnology { get; set; }
}

public class Technology
    {
        public int TechnologyId { get; set; }
        public string? TechnologyName { get; set; }

        public ICollection<ProjectTechnology>? ProjectTechnology { get; set; }
    }

public class ProjectTechnology
    {
        public int Id { get; set; }
        public int ProjectId { get; set; }
        public int TechnologyId { get; set; }

        public Project? Project { get; set; }
        public Technology? Technology { get; set; }
    }

這是我的 Css html 頁面，它將使用腳手架創建我希望這將顯示在從技術領域的資料庫中獲取資料的下拉串列中。

<div class="row">
        <div class="form-group col-md-6">
            <label asp-for="Technology" class="control-label"></label>
            <input asp-for="Technology" class="form-control" />
            <span asp-validation-for="Technology" class="text-danger"></span>
        </div>
    </div>

uj5u.com熱心網友回復：

嘗試

專案.cs：

public class Project
        {
            public int ProjectId { get; set; }
    
            [StringLength(60, MinimumLength = 3)]
            [Required]
            public string? ProjectName { get; set; }
    
            [Required]
            public string? Description { get; set; }
    
            [Required]
            public DateTime Start { get; set; }
    
            public DateTime? End { get; set; }
    
            [Required]
            public string? ProjectHead { get; set; }
    
            [Required]
            public string? Status { get; set; }
    
            
           public int TechnologyId { get; set; }
           public Technology Technology{ get; set; } 

            
    }

技術.cs

public class Technology
    {
        public int TechnologyId { get; set; }
        public string? TechnologyName { get; set; }

        public ICollection<Project>? Project { get; set; }
    }

在 Program.cs 中，添加如下代碼：

builder.Services.AddDbContext<MyDbContext>(options =>
    options.UseSqlite(builder.Configuration.GetConnectionString("MyDbContext")));

在 appsettings.json 中：

"ConnectionStrings": {
    "MyDbContext": "Filename= C:\\Users\\Administrator\\sqlite\\ITProjectDB.db"
  }

我的資料庫背景關系：

public class MyDbContext : DbContext
    {
        public MyDbContext(DbContextOptions<MyDbContext> options) : base(options) { }
        public DbSet<Technology> Technology { get; set; }
        public DbSet<Project> Project { get; set; }

       
    }

結果：

標籤：asp.net-mvc asp.net 核心 asp.net-core-mvc

上一篇：如何將頁面內容加載到另一個頁面的彈出視窗中？

下一篇：無法列出所有角色