从数据库中检索数据集并将其传递给javascript [英] Retrieving dataset from database and passed it to javascript

问题描述

  <script type='text/javascript' src='https://www.google.com/jsapi'></script>
    <script type='text/javascript'>
        google.load('visualization', '1', { packages: ['orgchart'] });
        google.setOnLoadCallback(drawVisualization);
        function drawVisualization() {
            // Create and populate the data table.
            var data = google.visualization.arrayToDataTable([
    //['Name', 'Manager', 'Tooltip'],
   // ['Mike', null, 'The President'],
  //  [{ v: 'Jim', f: 'Jim<br/><font color="red">Vice President</font>' }, 'Mike', null],
   // ['Alice', 'Mike', null],
   // ['Bob', 'Jim', 'Bob Sponge'],
   // ['Carol', 'Bob', null]
 // ]);
            var chart = new google.visualization.OrgChart(document.getElementById('chart_div'));
            chart.draw(data, { allowHtml: true });
        }
    </script>

    <script type="text/javascript">
        function Page_Load()
            {
                
        var conn = "abc";
        SqlConnection con;
        con=new SqlConnection(@conn);
        SqlCommand cmd=new SqlCommand("select Name from tblXYZ where T_Position='Manager'",con);
        DataTable ds=new DataTable();
        SqlDataAdapter da=new SqlDataAdapter();
        da.Fill(ds);
        
            }

    </script>

这里我想在上面的脚本中使用我的数据表，即在注释区域。

首先我不知道如何在脚本中执行sql语句然后如何在脚本中使用它的元素.plzz帮助我提前
thanx ..

Here i wants to use my datatable in the above script i.e. in commented area.
first i dont know how to execute sql statement in script and then how to use element of it in script.plzz help me
thanx in advance..

推荐答案

关于如何在Java Script中执行SQL语句的所有内容（请查看下面的示例代码）。

javscript没有直接支持执行sql查询。但是在激活对象的帮助下你可以完成相同的工作。

Fisrt of all about how to execute SQL Statement in Java Script(Check below sample code).
javscript doesn't have direct support to execute sql query.But with the help of activ object you can accomplish the same.

select

function gen_list_options(query, id, val) {

var conn = Server.CreateObject("ADODB.Connection");
var constr = "DSN=yourdsn; Uid=sa; Pwd=sa";
conn.Open (constr);
var rs = new ActiveXObject("ADODB.Recordset")
rs.open(query, conn, adOpenDynamic, adLockOptimistic)
if(!rs.bof) {
rs.MoveFirst()
while(!rs.eof) {
html += '<option value="' + rs.fields(id).value + '">' + rs.fields(val).value + '</option>'
rs.MoveNext()
}
}
rs.close()
return html
}

Updation

var con = Server.CreateObject("ADODB.Connection");
var constr = "DSN=yourdsn; Uid=sa; Pwd=sa";
con.Open (constr);
var querycompupd = "UPDATE Tasks SET Status='"&status&"' WHERE ID = " + tnum + ";";
con.execute(querycompupd);

现在检查此链接 [ ^ ]详细说明了如何在Java脚本中使用数据库连接的详细信息。

Now Check This Link[^] to understante the enire process in details regarding how to used your database connection within the Java Script.

我有类似字段这个



用户名称位置

ABC SDSD经理

XYZ DSD员工

GHF SD经理

GH DD董事



就像这样，我想要在表格中找回他们之间的层级关系 - 姓名& UPPERPOST





我有代码签署ORG CHAT类似的东西...

I HAVE FIELD LIKE THIS

USERNAME NAME POSITION
ABC SDSD MANAGER
XYZ DSD EMPLOYEE
GHF SD MANAGER
GH DD DIRECTOR

LIKE THIS AND I WANT TO RETRIEVE HIERARCHICAL RELATION BETWEEN THEM IN THE FORM - NAME & UPPERPOST


I HAVE CODE FOR ORG CHAT SOMETHING LIKE THIS...

          <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js" type="text/javascript"></script>
    <script type="text/javascript" src="//www.google.com/jsapi"></script>
    <script type="text/javascript">
        google.load('visualization', '1', { packages: ['orgchart'] });
    </script>
    <script type="text/javascript">

（ document ）。ready（ function （）{

(document).ready(function () {

这篇关于从数据库中检索数据集并将其传递给javascript的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！