如何使用asp.net中的javascript在sql 2005中获取数据 [英] how to get data in sql 2005 using javascript in asp.net

问题描述

如何使用asp.net中的javascript在sql 2005中获取数据

并在gridview中显示

how to get data in sql 2005 using javascript in asp.net

and show in gridview

推荐答案

一种已知的方法是使用AJAX读取数据.您应该具有服务器端逻辑来获取数据.然后，您可以使用AJAX类将数据加载到网格.

问候
Sebastian

One known method is using AJAX to read data. You should have your server side logic to fetch data. Then you can use your AJAX class to load data to grid .

Regards
Sebastian

您可以使用raw-ajax函数从服务器获取价值
使用XML对象
即

YOu can use raw-ajax function to get value from server
which uses XML Object
i.e.

function getValueByAjax(url,getxml)
   {


       var req;
       try {
        req = new XMLHttpRequest();  //e.g. Firefox
        } catch(err1) {
          try {
          req = new ActiveXObject('Msxml2.XMLHTTP'); // some versions IE
          } catch (err2) {
            try {
            req = new ActiveXObject("Microsoft.XMLHTTP"); // some versions IE
            } catch (err3) {
             req = false;
            }
          }
        }

       req.open("GET", url  ,false);

       req.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

       req.send();
       var item ;
       if(req.readyState == 4)
       {
          if(req.status == 200)
          {
             item = req.responseText;
             if(getxml==1)
             {
                item = req.responseXML;
             }
          }
       }

        return item;
   }

并从服务器端进行处理

并根据需要处理返回的字符串...

and do process from server side

and manupulate returned string as you want...

使用javascript
在sql 2005中获取数据 数据库将在服务器端.因此，您需要使用允许您通过JavaScript与服务器对话的技术.

通过客户端(Javascript)与服务器端进行交互的方法很少:
1. XMLHttpRequest [回调 [ Web服务调用 [ PageMethod [

get data in sql 2005 using javascript
Database will be on server side. So you need to use techniques that will allow you to talk to server from JavaScript.

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

Try the one that suits you.

这篇关于如何使用asp.net中的javascript在sql 2005中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！