AJAX example

[tototrain]

http://www.w3schools.com/ajax/ajax_database.aspI try to create the sample.But it cannot work at all.Can someone provide the link to download the database and the source code of this example?

[Synook]

The source code is all in the article. The database is the standard "northwind" sample that comes with SQL Server and Access.

[tototrain]

The source code is all in the article. The database is the standard "northwind" sample that comes with SQL Server and Access.

okie but i cant get the sample to work.. anyguys can help?

[Synook]

Well, what happens? Any JavaScript errors? Anyway ASP errors? Are you running a compatible webserver setup?

[tototrain]

When i select the from the dropdownlist nothing happen. no error. no change in address.im running on window 7 with IIS installed and had created a virtual directory. i tried an earlier example , typing the first and last name in the form, and display welcome firstname lastname.That example was working for me.

[tototrain]

Now the program can work, just that the address does not change . it remain as http://localhost/Default.aspx .from what i read, it should change to http://localhost/tryout.asp?value=name or something like that?

[Synook]

No... why would it?

[tototrain]

•Notice that a parameter (q) is added to the URL (with the content of the dropdown list)hmm did i interpret wrongly?

[Synook]

The script sends a HTTP request using AJAX to "getcustomer.asp?q="+str (which contains the ASP code), and gets the result back. The current page does not change.

xmlhttp.open("GET","getcustomer.asp?q="+str,true);

[tototrain]

ok. thanks.

[tototrain]

Is it possible to create dynamically after selecting the ALFKI from the drop down list.Then it shows a table. But The values from the table is able to click and link to another page?

[Synook]

You can modify getcustomer.asp to print out whatever you want, for example a link:

<%'...do until rs.EOF  for each x in rs.Fields	response.write("<tr><td><b>" & x.name & "</b></td>")	response.write("<td><a href=""page"">" & x.value & "</a></td></tr>")  next  rs.MoveNextloop'...%>

[tototrain]

thanks