How to retrieve data from SQL server database using javascript?

Question

1.00/5 (1 vote)

See more:

Dear All

In the Fee Payment form using ASP.Net webform when I enter student id, the student name should be retrieved and displayed in the display filed from student history table so that Operator confirm that the student ID and the student name are the same student.

in order to accomplish this how to write a javascript function that retrieve the appropriate information as the student id is entered in the asp.net next and hit enter.

Regards

Amy

What I have tried:

I want to accomplish this task by using Javascript on change or some other event. I don't have Idea how to retrieve information using javascript so please help me

Posted 6-Apr-16 0:33am

AmyAli

Updated 6-Apr-16 4:50am

Add a Solution

Comments

Thanks7872 6-Apr-16 6:40am

'What I have tried' is meant to explain what you have done so far,not what you want to do.

F-ES Sitecore 6-Apr-16 7:01am

You have to write a server-side function to get the data, like a webmethod or webservice, and call that webmethod from javascript. Google "call asp.net webmethod from jquery" for examples.

2 solutions

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)

Dave Kreskowiak · Answer 1 · 2016-04-06T02:53:00

Simple. You don't, for a long list of reasons.

It CAN, however, talk to the web server and call methods exposed by the application Controllers to manipulate data, including having methods that query the SQL Server for you and return the data to your javascript code on the client.

Google for "javascript call controller method" for examples.

W∴ Balboos, *GHB* · Answer 2 · 2016-04-06T04:50:00

First, you want an interface that is going to work across all browsers. That being said, ActiveXObject() methods are out (IE, only).

you are publicly exposing information about your server
you are allowing for a duplicate of your page with modified (harmful) SQL

JavaScript, you may have noticed, does not make it easy to do anything to the user's system - let along your server! It would be a security nightmare.

SQL should be called on the server, out of the view of any possible client. PHP is commonly used for this. You can generate the page on the server or use AJAX to retrieve the data and populate your existing page.

Even were you able to get this possibility on you client side you should run head-long in another direction . . . or risk the consequences.

How to retrieve data from SQL server database using javascript?

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0