ASP MVC Dropdown

Question

Please look at my code. I am trying to display some dynamic customers in the dropdown menu. And after selecting a customer button is pressed. Then products owned by the selected customer should be displayed in the textarea. But the problem is that after selecting a customer and pressing the button, nothing is displayed in the text area !. As i am new to ASP MVC can you help me out this problem?

Controller class-------------------->

public class ProductsController : Controller
{

    CandidateEntities db;

    public ProductsController()
    {
        db = new CandidateEntities();
    }

    public ActionResult Index()
    {
        ViewData["Customers"] = new SelectList(db.Customer.ToList(), "CustomerId", "Firstname");
        return View();
    }

    [AcceptVerbs(HttpVerbs.Post)]
    public ActionResult Index(FormCollection form)
    {
        int customerId = int.Parse(form["Customers"]);
        var cust = db.Customer.First(x=>x.CustomerId == customerId);
        var Query =
            from customer in db.Customer
            join prod in db.Products on customerId equals prod.Customer.CustomerId
            select prod;
        ViewData["Products"] = Query.ToString(); 
        return View("Index");
    }



}

Index view------------------>

Index

<%using(Html.BeginForm()){ %>   
    <%=Html.DropDownList("Customers", "Seletc one")%>
    <input type="submit" value="Click !" />

    <%=Html.TextArea("Textarea", ViewData["Products"]) %>
<%} %>

Paddy · Accepted Answer · 2009-11-06 10:33:17Z

2

Are you sure your query is returning results? It seems to be querying for every product for every customer, it might be rewritten something like:

from product in db.Prodcuts
where product.Customer.CustomerID = customerId
select product

Also, (and it depends on your code), but is calling ToString on a list of Product objects going to return what you want?

answered Nov 6, 2009 at 10:33

Paddy

34k15 gold badges82 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Petter Friberg · Accepted Answer · 2016-09-18 20:59:45Z

1

db.Products.Where(p => p.CustomerId == cust)

or

db.Customer.Find(cust).Products

edited Sep 18, 2016 at 20:59

Petter Friberg

21.8k10 gold badges67 silver badges116 bronze badges

answered Sep 18, 2016 at 20:40

Mzhda Saeed

2232 silver badges4 bronze badges

Collectives™ on Stack Overflow

ASP MVC Dropdown

Index

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Index

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related