後端資料庫產生Dropdownlist asp.net mvc

public ViewResult Index()
        {
            //Create db context object here 
            AdventureWorksDbContext dbContext = new AdventureWorksDbContext();
            //Get the value from database and then set it to ViewBag to pass it View
            IEnumerable items = dbContext.Employees.Select(c => new SelectListItem
                  {
                      Value = c.JobTitle,
                      Text = c.JobTitle
 
                  });
            ViewBag.JobTitle = items;
            return View();
        }

@Html.DropDownList("JobTitle", "Select a Value")

ASP.NET MVC 從空白專案新增BundleConfig 實做

NuGet:

Install-Package Microsoft.AspNet.Web.Optimization

建立App_Start\BundleConfig.cs:
自行修改要的

public class BundleConfig
{
    public static void RegisterBundles(BundleCollection bundles) {
        bundles.Add(new ScriptBundle("~/Scripts/jquery").Include(
            "~/Scripts/Lib/jquery/jquery-{version}.js",
            "~/Scripts/Lib/jquery/jquery.*",
            "~/Scripts/Lib/jquery/jquery-ui-{version}.js")
        );

        bundles.Add(new ScriptBundle("~/Scripts/knockout").Include(
             "~/Scripts/Lib/knockout/knockout-{version}.js",
             "~/Scripts/Lib/knockout/knockout-deferred-updates.js")
        );
    }
}

 Global.asax 新增這行

using System.Web.Optimization;

protected void Application_Start() {
     ...
     BundleConfig.RegisterBundles(BundleTable.Bundles);
     ...
}

最後別忘了web.config 新增命名空間 不然你也不能用

      <namespaces>
        <add namespace="System.Web.Optimization"></add>
      </namespaces>

讓我的開始Bundle吧

    @Scripts.Render("~/Scripts/jquery")
    @Scripts.Render("~/Scripts/bootstrap")