asp + Ext.grid 无数据

lzg208 2009-01-14 07:48:03

html文件：

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link rel="stylesheet" type="text/css" href="extjs/resources/css/ext-all.css" />
<script type="text/javascript" src="extjs/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="extjs/ext-all.js"></script>
<script type="text/javascript" src="array-grid.js"></script>

</head>
<script>
Ext.onReady(function(){

var sm = new Ext.grid.CheckboxSelectionModel();

var cm = new Ext.grid.ColumnModel([
new Ext.grid.RowNumberer(),
sm ,
{header:'编号',dataIndex:'id',sortable:true},
{header:'登录名',dataIndex:'longName',sortable:true},
{header:'名称',dataIndex:'name',sortable:true},
{header:'部门',dataIndex:'descn',sortable:true}
]);

var proxy = new Ext.data.HttpProxy({url:'igetuserlist.asp',method: 'get' }) ;
var reader = new Ext.data.JsonReader({
totalProperty: 'totalProperty',
root: 'root' ,
id: 'id'
},
[
{name: 'id', mapping: 0},
{name: 'longName',mapping:1},
{name: 'name', mapping: 2},
{name: 'descn', mapping: 3}
]
);

var ds = new Ext.data.Store({proxy:proxy,reader : reader});

var grid = new Ext.grid.GridPanel({
el: 'grid',
ds: ds,
cm: cm ,
sm: sm ,
autoHeight: true ,
bbar: new Ext.PagingToolbar({
pageSize: 20,
store: ds,
displayInfo: true,
displayMsg: '显示第 {0} 条到 {1} 条记录，一共 {2} 条',
emptyMsg: "没有记录"
})
});

ds.load();
grid.render();
});
</script>
<body>
<div id="grid" style="width:100%;height:265px"></div>
</body>
</html>

asp 文件:
<%@ EnableSessionState=True Language=VBScript %>
<%Option Explicit%>






<%
dim strSql ,rs ,i
dim start ,limit
dim rscount
start = request("start")
limit = request("limit")

strSql = " select * from 操作员表 "
set rs = fsconn.execute(strsql)

rscount = SafeCLng(ExecuteScalar(" select count(*) from 操作员表 "))
dim json
json = "{totalProperty:"& rscount &",root:["

dim index ,pageSize
index = safeclng(start)
pageSize = safeclng(limit)

while not rs.eof
if i > 0 then json = json & ","
json= json & "{id:"& rs("id") &",longName:'"& rs("登录名") &"',name:'"& rs("姓名") &"',descn:'"& rs("部门") &"'}"
i = i + 1
rs.movenext
wend

json = json & "]}"
response.write(json)
response.End()
%>

直接访问后台文件得到的结果是:

{totalProperty:123,root:[{id:1,longName:'zhaojiangli',name:'aaa',descn:'D01'}
,{id:3,longName:'zhouyongjin',name:'bbb',descn:'B'}
,{id:4,longName:'zhangshanshan',name:'张珊珊',descn:'B'}
,{id:5,longName:'zhangying',name:'张莹',descn:'*'}
,{id:20,longName:'lixiangzhou',name:'李翔宙',descn:'B'}
,{id:230,longName:'cq30',name:'cq30',descn:'D02'}
,{id:231,longName:'liuyang',name:'刘阳',descn:''}
,{id:232,longName:'zhangdong',name:'张冬',descn:''}
,{id:233,longName:'zhaodongsheng',name:'赵东升',descn:'D01'}
,{id:234,longName:'mengxiang',name:'孟翔',descn:'B'}]}

我访问html 页面结果是个空框架没有数据
我 alert(ds.data.length) 的结果也是0

大家帮我看下是怎么回事

...全文

204 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

yakeis 2009-03-06

打赏
举报

[Quote=引用 3 楼 lzg208 的回复:]
我已经找出原因了
不过还是谢谢楼上的回复
[/Quote]

能告诉一下吗，我今天刚刚也碰到这样的问题。是什么原因？

yue242126 2009-02-01

打赏
举报

[Quote=引用 3 楼 lzg208 的回复:]
我已经找出原因了
不过还是谢谢楼上的回复
[/Quote]

是什么原因说出来给我听听我也遇到类似的问题了

lzg208 2009-01-15

打赏
举报

我已经找出原因了
不过还是谢谢楼上的回复

luohuanquan 2009-01-15

打赏
举报

我觉得你的reader有点问题，试试改改。把下面
{name: 'id', mapping: 0},
{name: 'longName',mapping:1},
{name: 'name', mapping: 2},
{name: 'descn', mapping: 3}
换成
{name: 'id', mapping: 'id'},
{name: 'longName',mapping:'longName'},
{name: 'name', mapping: 'name'},
{name: 'descn', mapping: 'descn'}
看看

wjfmail 2009-01-15