TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abraham Lukwesa
NA
15
5.4k
How to filter Dropdowns and filter a table in ASp.net
Jul 20 2015 6:34 AM
Hi All,
I have a got database of vehicles. The database contains properties such as manufacturers, models, engine size and fueltype.
Now in my project(View) I am displaying this data in a table and using dropdowns to filter the table. At the moment i have got a manufacturer dropdown and a car model dropdown. when a user selects the dropdowns they click a search button that that filters the according to the drop downs. This is how my project is working at the moment.
Is there anyway i could filter the dropdowns? what i mean by this is that is there a way i could select the manufacturer dropdown and this then filters all car Models according to the slected manufacturer .. so instead of showing all the models just show the selected manufacturer dropdowns?
Controller
public ActionResult BrowseCars( string manufacturer, string model)
{
ViewBag.manufacturer = (from m in _carCatalogue.CarsTable
select m.Name).Distinct();
ViewBag.model = (from v in _carCatalogue.CarsTable
select v.Vehicle).Distinct();
var car = from t in _carCatalogue.CarsTable
orderby t.Name
where t.Name == manufacturer || manufacturer == null || manufacturer == ""
where t.Vehicle == model || model == null || model == ""
select t;
return PartialView("_BrowseCars", car);
}
View
@model IEnumerable<Model.CarsTable>
<p> Use the relevant dropdowns below to find the vehicle </p>
<p>
@using (Html.BeginForm())
{
<text> Manufacturer </text>@Html.DropDownList("manufacturer", new SelectList(ViewBag.manufacturer))
<text> Model </text>@Html.DropDownList("model", new SelectList(ViewBag.model))
<input type="submit" value="search"/>
}
</p>
<div>
<table>
<tr>
<th>
Mnaufacturer
</th>
<th>
Model
</th>
<th>
Engine Size
</th>
<th>
BHP
</th>
</tr>
@foreach (var item in Model)
{
<tr>
<td>
@Html.DisplayFor(modelItem => item.Name)
</td>
<td>
@Html.DisplayFor(modelItem => item.Vehicle)
</td>
<td>
@Html.DisplayFor(modelItem => item.EngineSize)
</td>
<td>
@Html.DisplayFor( modelItem => item.Bhp)
</td>
}
</table>
Thank you for your time
Reply
Answers (
0
)
Win form application created in vs 2010 not working on win 8
How to mapping Database First Model with existing Database?