如何使用java脚本连接MS SQL Server数据库并执行存储过程 [英] How to Connect MS SQL Server Database using java script and execute Stored Procedue

问题描述

嗨！



任何机构都可以指导我使用javascript连接MS Sql Server数据库的程序我正在使用C＃3.5并希望通过以下方式检索数据一个存储过程。



我试图使用带有下拉框的javascript gridview，我想在每个新行创建时在下拉框中填充数据一个网格视图。



ADO连接正在工作，但它显示一条警告消息，即''此网站使用的数据提供程序可能不安全''。此外，我不确定今天的网络项目是多少可靠。所以，请。其他流行的连接方法也很有帮助。喜欢.net中的Sqlconnection。



请帮忙。



谢谢

Nirbhay

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

推荐答案

数据库将在服务器端。为了与数据库通信，您需要从客户端到服务器端进行通信。



通过客户端（Javascript）与服务器端进行交互的方法很少：

1. XMLHttpRequest [ ^ ]

2. 回调 [ ^ ]

3. WebService调用 [ ^ ]

4. PageMethod [ ^ ]



试试你认为合适。

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.

这篇关于如何使用java脚本连接MS SQL Server数据库并执行存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！