How to Connect MS SQL Server Database using java script and execute Stored Procedue

Question

0.00/5 (No votes)

See more:

Hi!

Can any body guide me the procedue to connect a MS Sql Server database using javascript I am using C#3.5 and want to retrive the data through a stored procedure.

I was trying to use a 'javascript gridview' with dropdown boxes where i want to populate the data in dropdown box on every new line creation of a gridview.

ADO Connection is Working but it shows a warning message i.e. 'This website uses a data provider that may be unsafe'. Also I am not sure how much would it be reliable as per today's web project. So please. Other popular connection method can also be helpful. Like Sqlconnection in .net.

Please Help.

Thanks
Nirbhay

Posted 6-Feb-13 4:32am

Member 3583629

Updated 6-Feb-13 4:42am

Kishor Deshpande

v3

Add a Solution

Comments

ZurdoDev 6-Feb-13 11:05am

One way is to create a webservice that does your database work. Then use jQuery's ajax() to call that webservice.

Irbaz Haider Hashmi 6-Feb-13 11:07am

Are you using your Connection String in the javascript?

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)

Sandeep Mewara · Answer 1 · 2013-02-06T06:38:00

Database will be on server side. In order to talk to database, you need to communicate from client side to server side.

There are few ways to interact with server side through client side(Javascript):
1. XMLHttpRequest[^]
2. Callback[^]
3. WebService call[^]
4. PageMethod[^]

Try that you find fit.