MVC Json Ajax 二級 級連

<script type="text/javascript"></p><p> $(document).ready(function() {<br /> $("#teamName").change(function() {<br /> $.getJSON('/team/SelectProduct', { teamName: $("#teamName").val() }, function(data) {<br /> $("#productID").empty();</p><p> $.each(data, function(i, item) {<br /> $("<option></option>")<br /> .val(item)<br /> .text(item)<br /> .appendTo($("#productID"))<br /> });</p><p> });</p><p> })<br /> });

 

controller:

public ActionResult SelectProduct()<br /> {</p><p> string teamName = Request.Params["teamName"];</p><p> int teamID = dc.TestTeams.Where(x => x.Name == teamName).SingleOrDefault().Id;<br /> var productCollection = dc.Products.Where(x => x.TestTeamId == teamID).Select(x=> x.ShortName);</p><p> return Json(productCollection);</p><p> }