How to fetch data from sql database and use in javascript

Question

0.00/5 (No votes)

See more:

I am totally new to programming, so please excuse if my question is too lame. I am working in Asp.net. I need my database values in source code of my form. i.e. javascript

What I have tried:

How to fetch data from sql database in javascript and draw line .

Posted 22-Feb-16 11:38am

Member 12312733

Add a Solution

Comments

[no name] 22-Feb-16 23:42pm

Do you want to use AJAX to fetch data from database?

Secondly we are not sure about to draw line, elaborate it more...

Member 12312733 23-Feb-16 5:32am

I have already fetched data from database using ajax. But i am not sure, how can i use that fetched data to draw line. As in below, i want to use database data to make lines accordingly.

e.beginPath();
e.strokeStyle = "Black";
e.lineWidth = width;
e.moveTo(125, 125);
e.lineTo(X[i], Y[i]);
e.stroke();

[no name] 23-Feb-16 6:04am

So you are drawing line, where is the problem? Follow below link:

http://www.w3schools.com/tags/canvas_lineto.asp

Member 12312733 23-Feb-16 8:08am

I want user to input lets suppose his name, that name will be matched from the database, and then "distance" will be used as width of line.

(my database has 2 columns. Lets say name, distance)

[no name] 23-Feb-16 8:11am

It is staright forward. As you are telling, you sent AJAX request to server and check the username then fetch distance.

Once you get the distance, you new to draw line using Canvas HTML5 object.
http://www.w3schools.com/tags/canvas_lineto.asp

Member 12312733 23-Feb-16 8:13am

Alright, Thank you

F-ES Sitecore 23-Feb-16 4:23am

A forum like this is not a good place to learn something from scratch, what you're essentially doing is asking someone to do your work for you. Study how to code in c#\ asp.net, javascript and then how to do these things will become clear, and if you need to ask specific questions about specific problems then feel free to do so, but this is not a code-on-demand site.

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)