我想从服务器端传一个dataTable到客户端,由JS来处理。
大家一般采用何种方式?把dataTable 转化为二维数组进行传输?还是有其他更加简便的技术?
请各位指点!

解决方案 »

  1.   

    没必要啊
    为什么有这样的需求?
    可以通过其他方式来解决吧
    非要在客户端处理
    转换成XML比较好
    而且datatable本来就有个WriteXml的方法
      

  2.   

    不用轉換啊,js可以直接訪問DataTable的啊
      

  3.   

    $.ajax({
              type:"POST",
              url:"jsondata/json.aspx", 
              data:{"page":"1","userName":$("#userName").val(),"group":userGroup,"state":$("#state").val()},
              dataType:"json",
              success:function(data){
                                 //alert(data);
                              
                         for(var i=0;i<data.length;i++)
                         {                       $("#"+i+"").remove();                          $("#firsttr").after("<tr id='"+i+"'></tr>");
                             
                                if(i%2 == 0){    
                                    
                                      }else{    
                            $("#"+i+"").css("background-color", "#EEF9FF");   
                                       }     
                              $.each(data[i],function(j,n){
                               if(j=="SU_ID")
                              {
                               $("<td></td>").html("<input type='checkbox'  name='checkbox' title='选择/ 不选 'value='"+data[i].SU_ID+"' onmousemove='toolTip('选择/不选', '#000000', '#FEF3D1')' onMouseOut='toolTip()'  />").appendTo("#"+i+"");
                              }
                            if(j=="SU_CNAME")
                            {
                             $("<td></td>").html(" <a href='Suser_edt.aspx?id="+data[i].SU_ID+"&cn="+escape(data[i].SU_CNAME)+"&en="+escape(data[i].SU_ENAME)+"&right="+escape(data[i].SU_TYPE)+"&sate="+escape(data[i].SU_STATE)+"'>"+data[i].SU_CNAME+"</a>").appendTo("#"+i+"");
                            }       
                            if(j=="SU_ENAME")
                             {
                                  //alert("en:"+data[i].Su_Ename) ;
                                 $("<td></td>").html(data[i].SU_ENAME).appendTo("#"+i+"");
                            }              
                             if(j=="SU_TYPE")
                            {
                                   //alert(data[i].SU_RIGHT);
                                 $("<td></td>").html(data[i].SU_TYPE).appendTo("#"+i+"");
                            } 
                            if(j=="SU_STATE")
                            {
                                 if(n==0)
                                {
                            
                                   $("<td></td>").html("未开通").appendTo("#"+i+"");
                                }
                                 if(n==1)
                                {
                                 $("<td></td>").html("已开通").appendTo("#"+i+"");
                                } 
                            } 
                           
                            
                              })
                            if(group=="hide")
                              {
                               $("<td></td>").html("<a href='Suser_edt.aspx?id="+data[i].SU_ID+"&cn="+escape(data[i].SU_CNAME)+"&en="+escape(data[i].SU_ENAME)+"&right="+escape(data[i].SU_TYPE)+"&sate="+escape(data[i].SU_STATE)+"' title='编辑'><img src='../img/cdimg/scoll.gif'  alt='编辑' class='action' /></a>┃<a href='Suser_list.aspx?deleteUser="+data[i].SU_ID+"' onclick=' return confirm_()' title='删除'><img src='../img/cdimg/gif_47_049.gif'  alt='删除' class='action' /></a>┃<a href='#'><img src='../img/cdimg/15_mb5ucom.gif'  alt='权限' class='action' /></a>").appendTo("#"+i+"");                   
                              }
                              else
                              
                              {
                              $("<td></td>").html("<a href='Suser_edt.aspx?id="+data[i].SU_ID+"&cn="+escape(data[i].SU_CNAME)+"&en="+escape(data[i].SU_ENAME)+"&right="+escape(data[i].SU_TYPE)+"&sate="+escape(data[i].SU_STATE)+"' title='编辑'><img src='../img/cdimg/scoll.gif'  alt='编辑' class='action' /></a>┃<a href='Suser_list.aspx?deleteUser="+data[i].SU_ID+"' onclick=' return confirm_()' title='删除'><img src='../img/cdimg/gif_47_049.gif'  alt='删除' class='action' /></a>").appendTo("#"+i+"");                   
                             }                     }
                         
                         
                         },
                         error:function(data){
                          alert("没有数据");
                         } 
             
         
         
         })
        }
     
     //查询用户组end
     if(getCookie("Group_hide")==""||getCookie("Group_hide")==null)
     {
             group=$("#hide").val();
     }
      else
     {
           group=getCookie("Group_hide");
     };