AJAX中使用JAVA脚本访问DataSet数据

在AJAX中从服务器获取的DataSet数据的访问：

var dt = response.value.Tables[0]; //dt就是DataSet的表0

for (var i = index;i < dt.Rows.length;i++)//遍历数据行

var rowvalue ＝ dt.Rows[i].Name;//获取Name字段的值

dt.Columns.length    //获取表中字段的数量

 dt.Rows.length        //获取表中行的数量

var row ＝ dt.Rows[i][dt.Columns[k].Name];//获取行i字段k的值

 

 

下面的例子，处理了按dt的数据构造一个table显示在指定的td节点中,并按实际行大小添加了上一页下一页的导航按钮：

function NextPage(pgIndex) {

//表头 var shtml ="";

 var tdWidth = 50;

if(_Resuldt.Columns.length > 10) {

   shtml = "<TABLE cellSpacing=0 cellPadding=0 border = 1  width="+_Resuldt.Columns.length * 40+ ">" +
       "<tr height=18 bgcolor=#cccc99> ";
        tdWidth = 40;

}

else {

         shtml ="<TABLE cellSpacing=0 cellPadding=0 border = 1 width=730><tr height=18  bgcolor=#cccc99> ";
tdWidth = 62;

}

for (var i = 1;i < _Resuldt.Columns.length;i++)//添加表头{
     if(i==1)
          shtml+= "<td width=120 align=center>"+_Resuldt.Columns[i].Name+"</td>";
      else
            shtml+= "<td width="+tdWidth+" align=center>"+_Resuldt.Columns[i].Name+"</td>";
       
 } 
    shtml += "</tr>";   
    var count = 0;
    var cg = false;//行与行之间变色标志
    for( i= pgIndex * pageCount;i<_Resuldt.Rows.length;i++)//遍历行填充table
    {
          if(cg)
          {
                  shtml+="<tr height = 18 bgcolor=#cccc99>";
                  cg = !cg;
           }
          else
          {
               shtml+="<tr height = 18>";
               cg = !cg;
            }
     
           for( k=1;k<_Resuldt.Columns.length;k++)//字段遍历
          {
               if(k==1)
              {
                     shtml+= "<td width=120 align=center><a href=javascript:SHowMessage("+
                    _Resuldt.Rows[i].VehicleID+")>"+_Resuldt.Rows[i][_Resuldt.Columns[k].Name] +"</a></td>"  
                }
                else
               {
                      var result = _Resuldt.Rows[i][_Resuldt.Columns[k].Name];
                           shtml+="<td align=center >" +result  + "</td>";
                }
       
     }
     shtml += "</tr>";
     count ++;
     if(count == pageCount)
     {      
      break;
     }
    }

 //添加导航按钮
    var nexttd = "<td height = 20 id = nextid width = 100></td>";
    var pretd = "<td height =20 id=preid width = 100></td>";
    
    //添加导航按钮
     if(_Resuldt.Columns.length > 10)
     {    
      shtml += "</table><TABLE cellSpacing=0 cellPadding=0 border = 0 width=730>" +
         "<tr height=18 bgcolor=#ffffff> ";
         
     }
     else
     {
      shtml += "</table><TABLE cellSpacing=0 cellPadding=0 border = 0 width=730>" +
        "<tr height=18 bgcolor=#ffffff> ";        
     }  
     shtml += "<td width = 100>&nbsp;</td>   ";
     shtml += pretd;
     shtml += "<td width = 100>&nbsp;</td>   ";
     shtml += nexttd;
     shtml += "</tr></table>";
    var area_father = document.getElementById("tblVehicle");
    area_father.innerHTML = shtml;

var pageCount ＝ 25;//每页显示行数

if(_Resuldt.Columns.length > 10)

{

      shtml = "";

       var area_father = document.getElementById("tblResult");

        area_father.innerHTML = shtml;

         if(pageCount * (pgIndex + 1) < _Resuldt.Rows.length)//有下一页

        {

                  var npagef = document.getElementById("nextid");

                  var np = document.createElement("a");

                   np.href = "javascript:NextPage(" + eval(pgIndex+1) + ")";

                   np.innerHTML = "下一页";

                   npagef.appendChild(np);

        }

        if(pgIndex > 0)//有上一页

       {

                var npagef = document.getElementById("preid");

                var np = document.createElement("a");

              np.href = "javascript:NextPage(" + eval(pgIndex-1) + ")";

              np.innerHTML = "上一页";

              npagef.appendChild(np);

    }