How to auto populate textbox value from database based on selecting related value from dropdown list

Question

1.00/5 (1 vote)

See more:

, +

I have a dropdown box in my html body along with two textboxes. The values in Dropdown box is fetched using sql query. I want to autopopulate the textboxes which are 2 in number with related values of the database table whose value I am getting in the dropdown upon selection. Is it possible in Javascript or Ajax or jquery? Kindly help me with code as I am new to these languages?

What I have tried:

I have a dropdown box in my html body along with two textboxes. The values in Dropdown box is fetched using sql query. I want to autopopulate the textboxes which are 2 in number with related values of the database table whose value I am getting in the dropdown upon selection. Is it possible in Javascript or Ajax or jquery? Kindly help me with code as I am new to these languages?

Posted 16-Apr-20 2:18am

Knowledge_Seeker 2

Updated 16-Apr-20 4:23am

Add a Solution

Comments

F-ES Sitecore 16-Apr-20 8:38am

Yes it is possible but your question is essentially "how do I make a website". You say the data comes from a sql query so that will be server-side processing but you haven't said what server-side tech you are using so this is impossible to answer. If I was you I'd start with hard-coded data server side to make it easy, then change to sql queries once that is working. You'll need to use ajax to call a web method of some sort, so choose your server-side text and google how to call it via ajax for examples.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2020-04-16T04:24:00

The most sensible way to do this is AJAX. I don't bother with jquery - using straight javaScript, php, etc.

Here's your AJAX reference (from where I learned it).

AJAX Introduction[^] This makes it pretty straight forward and has examples. Simple examples.

One thing: "new to these languages" is not particularly informative. I cannot tell if you're in over your head or not. I'll presume you created the initial query to populate the droplist. If not - you need to back up and learn how to do that own your own.