I need to know how I could create a drop down list to represent all the categories in my "Categories" table.
I have already extracted the names and the values of each category I need, using this LINQ query :
var dbcontext = new LNQ2SQLDataContext();
var Q = from P in dbcontext.Categories
where P.SUB_CAT == null
select P;
I can pass this "Q" to my view like this : In Controller :
return View(Q);
And in the View :
@model IEnumerable<MyAppName.Models.Category>
But I have no idea how to use @html.DropDownListFor()
to make a darn good drop down list out of the model. :|
PLUS:
I could make a SelectList
from the query "Q" like this :
var category_list = new SelectList(Q, "CAT_ID", "CAT_Name");
BUT I don't know how to create a drop down list (without using ViewBag
to pass the category_list
to the view) from a simple SelectList
, either :|
I searched through as many blogs and websites as I could. But they didn't have the solution for my problem. I only got more and more confused!
So can anybody help please ? :/