Question

cancer10 · May 14th, 2007, 02:07 AM

Question - ASP + Ajax

Hey!

Not sure if this is the correct section to post this. ;)

Well, I have a table in my sql server 2000 database

***************
tblAddress
----------------------------
City_Name (varchar)
Venue_Name (varchar)
*******************

The "City_Name" column contains all the name of the cities in my country and each city has multiple venues.

Now I have 2 drop-down boxes in my asp page. The first drop-down is already listed with all the cities which are in the "City_Name" column.

What I now want is, when I select a city name from the first drop-down, the second drop down should be populated with all the venue names of that city (of course without refreshing the page)

I know this can be done with ajax.

I got few codes while googling but none of them are working :(

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Banksie · June 17th, 2007, 11:51 AM

If i was doing that in normal asp, i would have a table for each city, containing the venue, and then a table of cities, this would then be related in my access database, then just select them from tables, but im sure there is a easier, faster way to do that!

Im can't really help as im not a ajax user.
But theres a idea for you to think about!

Banksie

DaveGerard · July 30th, 2007, 03:29 PM

Well Banksie you'd be totally UNnormalizing your data by doing it that way.

The process can be done without reloading the page, but will require some javascript and the XMLHttpRequest object. Here is a quick and dirty tutorial.

1) Create 3 pages (Form.asp, Cities.asp, Venues.asp).

2) Form.asp will include two divs (e.g. divCities, divVenues) as well as functions for "GetCities()" and "GetVenues()" in the <HEAD> section of the page.

3) Cities.asp will contain the HTML output for a dropdown called "CityId". The CityId dropdown will call the second function when changed and must pass the CityId and target div to the function as well.

4) Venues.asp will contain the HTML output for a dropdown called "VenueId".

5) In the onload event handler for Form.asp, call the first function, and pass two values for the source and target divs. For example, onload="GetCities('Cities.asp', 'divCities')". The function will make an XML request to the server returning the "Cities.asp" page into the "divCities" div without reloading the page.

6) When the option for the "CityId" dropdown is changed, the Venues function will be called. For example, onchange="GetVenues('Venues.asp?CityId=123', 'divVenues')". Notice the CityId within the values being passed to the GetVenues() function. The function will make an XML request to the server returning the "Venues.asp" page into the "divVenues" div without reloading the page.

If you need a sample of the functions or page structure just say the word and I'll try and put something together.