Drop Down / AutoPostBack refreshes entire page
Posted on 2009-12-16
I'm developing a very simple front end for an asset management system. To make it a short story, I have two drop down boxes, both populated by SQL queries. Let's call them Make and Model.
Make is populated automatically during the page load with data from the Make table. Model is a subsequent query, based on the drop-down selection of the Make. Quick example..
Make = Dell
Model is populated with (select model_name from model where make='Dell').. so it might display the following choices..
The problem arises when 'Make' is chosen. I'm using the AutoPostBack=True method to refresh the model query. This, however, refreshes the entire page. There's a lot on this page that I haven't mentioned, which makes this method very slow.
How do I have just the drop-down list / query results refresh, without the entire page? Is there an easy method using ASP/VB to do this? From what I understand, Ajax would probably be an easy solution, but I don't even know where to being with Ajax (so if that's your suggestion, I would very much appreciate a link to a simple tutorial).