• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 566
  • Last Modified:

Javascript to Populate ASP Form Fields based on Dropdown Selection

I have a form where the customer would like a JavaScript array created so when the user selects a name from a dropdown box the associated fields on the form are populated from the array.  The only call to the SQL database would be when the form first loads to create the JavaScript array.

Here is the form:

Name:  This is the dropdown box
Age:      Textbox
Grade:  Textbox

I am assuming I use onchange to call a function to get the values but I am unclear on how to create the array or populate the textboxs on the form.  

I am somewhat new to JavaScript so code examples would be greatly appreaciated.


Thank you.
David
0
skinsfan99
Asked:
skinsfan99
  • 4
  • 2
1 Solution
 
sivagnanam chandrakanthTechnical LeadCommented:
in select box write Onchange event to call javascript function and in js function find the equivalent age and grade value from array based on selected name field value
Note your array should be accessible from jS

see this example

http://stackoverflow.com/questions/13271027/javascript-filling-dropdown-from-array-based-on-another-value-of-another-dropdow
0
 
skinsfan99Author Commented:
You description is accurate but I don't see that the example shows what I need.

I am looking for a code example of how to create a javascript array after doing a SQL select.  The onchange on the dropdown would populate text boxes from the array, not another dropdown box.  If your example could be modified to show that solution maybe it will work but as I mention I am new to JavaScript.

Thanks
0
 
sivagnanam chandrakanthTechnical LeadCommented:
Example for creating JS array from sql query

http://aspdotnetcodebook.blogspot.in/2008/03/how-to-fill-javascript-array-from.html

use indexOf function to find the equivalent value in age array and grade array
and fill values using

document.getElementById(age).value='equivalent value from array'
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
skinsfan99Author Commented:
I am using Classic ASP not ASP.NET.  I should have been more clear about that.

Thanks
0
 
skinsfan99Author Commented:
After some trial and error I figured out the code.
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
I'm glad you figured it out.  Just remember the client side code (javascript) loads on the page last.  Your asp/vb code gets processed before the page loads, then html and js gets written to the page and finally the js code gets processed.

With this in mind, if you want to end up with generated code like below

<script>
var mycars = new Array();
mycars[0] = "Saab";
mycars[1] = "Volvo";
mycars[2] = "BMW";
</script>

but the data is in your database, you can generate it with your serverside code like

jsCode="<script>"
jsCode=jsCode&"var mycars = new Array();"
jsCode=jsCode&"mycars[0] = ""Saab"";"
jsCode=jsCode&"mycars[1] = ""Volvo"";"
jsCode=jsCode&"mycars[2] = ""BMW"";"
jsCode=jsCode&"</script>"
response.write jsCode
0
 
skinsfan99Author Commented:
Feedback provided did not solve the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now