各位高手,小弟实在是搞不出来了,我使用的是Jqgrid 3.5版本的插件,可为什么只显示一些空白行但看不到行内的数据呀,请各位高手帮忙看看,急,在线等,分不多了,请见谅。
代码如下:html:<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="Hitech.Web.Paper.test" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><link href="../Style/Index.css" rel="Stylesheet" />
<link rel="stylesheet" type="text/css" media="screen" href="../themes/redmond/jquery-ui-1.7.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="../themes/ui.jqgrid.css" />
<script src="../js/jquery.js" type="text/javascript"></script>
<script src="../js/jquery.jqGrid.js" type="text/javascript"></script>
<script src="../js/jquery-ui-1.7.1.custom.min.js" type="text/javascript"></script>
<script src="../js/jquery.layout.js" type="text/javascript"></script>
<script src="../js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="../js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="../js/jquery.tablednd.js" type="text/javascript"></script>
<script src="../js/jquery.contextmenu.js" type="text/javascript"></script>
<link href="../Style/dhtmlwindow-system.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../Script/dhtmlwindow.js"></script>
<script type="text/javascript">
var curRowId;
//加载数据表格
function createGrid() { var pageIndex = 1;
var pageSize = 10; jQuery('#jsonopt').jqGrid({
url: 'test.aspx?Action=GetData',
datatype: "json",
fixedRowNum: 0,
fixedColNum: 0,
colNames: ['仓库编码', '仓库名称', '检码', '简称', '使用状态', '备注'],
colModel: [{ name: 'WareHouseCode', index: 'WareHouseCode', width: 120, align: 'left', editable: true, sortable: false },
{ name: 'WareHouseName', index: 'WareHouseName', width: 100, align: 'right', editable: true, sortable: false },
{ name: 'SearchCode', index: 'SearchCode', width: 80, align: 'right', editable: true, sortable: false },
{ name: 'SimpleName', index: 'SimpleName', width: 80, align: 'right', editable: true, sortable: false },
{ name: 'State', index: 'State', width: 50, align: 'right', editable: true, sortable: false },
{ name: 'Note', index: 'Note', align: 'right', editable: true, sortable: false}],
rowNum: 10,
rowList: [10, 20, 30],
pager: $('#pjopt'),
loadui: "disable",
keyId: 'WareHouseCode',
keyIndex: 'WareHouseCode',
tags: [], //页面附加属性,值必须在数据源最后按序添加进去
width: 'auto',
height: 'auto',
pgtext: ' of',
mtype: "POST",
viewrecords: true,
recordtext: 'View {0} – {1} of {2}',
pgtext: 'Page {0} of {1}',
multiselect: true,
arrayData: true,
sortorder: 'desc',
jsonReader: {
root: "rows", //our data
page: "page", //current page
total: "total", //total pages
records: "records", //total records
repeatitems: false,
id: 'WareHouseCode'
},
caption:"JSON Example",
footerrow: true, userDataOnFooter: true,
rownumbers: true, rownumWidth: 40, gridview: true,
onSelectRow: function(ids) { curRowId = ids;
var data = $("#jsonopt").getRowData(ids);
} }); } $(document).ready(function() { createGrid();
});</script>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div id="outterDiv" align="center">
<tr>
<td valign="top">
<table id="jsonopt" class="scroll" cellpadding=0 cellspacing=0>
</table>
</td> </tr>
<div id="pjopt" class=scroll style="text-align:left; " align=left>
</div>
</div>
</form>
</body>
</html>后台代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;namespace Hitech.Web.Paper
{
public partial class test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Action"] == "GetData")
{
//列名
string[] columns = new string[] { "WareHouseCode","WareHouseName","SearchCode","SimpleName","State","Note" };
String pageIndex = "1";
String pageSize = "20";
//读取数据库中的数据
int sum = 0;
DataTable dt = new Hitech.BLL.T_PM_PaperWareHouse().GetDataTable(Convert.ToInt32(pageIndex), Convert.ToInt32(pageSize), out sum); //将数据拼凑成json格式
string dataStr = "";
dataStr = Hitech.Common.BasePage.DtToSON2(dt, columns, pageIndex, pageSize, sum.ToString()); //返回客户端
Response.Clear();
Response.Write(dataStr);
Response.End(); }
}
}
}
代码如下:html:<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="Hitech.Web.Paper.test" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><link href="../Style/Index.css" rel="Stylesheet" />
<link rel="stylesheet" type="text/css" media="screen" href="../themes/redmond/jquery-ui-1.7.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="../themes/ui.jqgrid.css" />
<script src="../js/jquery.js" type="text/javascript"></script>
<script src="../js/jquery.jqGrid.js" type="text/javascript"></script>
<script src="../js/jquery-ui-1.7.1.custom.min.js" type="text/javascript"></script>
<script src="../js/jquery.layout.js" type="text/javascript"></script>
<script src="../js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="../js/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="../js/jquery.tablednd.js" type="text/javascript"></script>
<script src="../js/jquery.contextmenu.js" type="text/javascript"></script>
<link href="../Style/dhtmlwindow-system.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../Script/dhtmlwindow.js"></script>
<script type="text/javascript">
var curRowId;
//加载数据表格
function createGrid() { var pageIndex = 1;
var pageSize = 10; jQuery('#jsonopt').jqGrid({
url: 'test.aspx?Action=GetData',
datatype: "json",
fixedRowNum: 0,
fixedColNum: 0,
colNames: ['仓库编码', '仓库名称', '检码', '简称', '使用状态', '备注'],
colModel: [{ name: 'WareHouseCode', index: 'WareHouseCode', width: 120, align: 'left', editable: true, sortable: false },
{ name: 'WareHouseName', index: 'WareHouseName', width: 100, align: 'right', editable: true, sortable: false },
{ name: 'SearchCode', index: 'SearchCode', width: 80, align: 'right', editable: true, sortable: false },
{ name: 'SimpleName', index: 'SimpleName', width: 80, align: 'right', editable: true, sortable: false },
{ name: 'State', index: 'State', width: 50, align: 'right', editable: true, sortable: false },
{ name: 'Note', index: 'Note', align: 'right', editable: true, sortable: false}],
rowNum: 10,
rowList: [10, 20, 30],
pager: $('#pjopt'),
loadui: "disable",
keyId: 'WareHouseCode',
keyIndex: 'WareHouseCode',
tags: [], //页面附加属性,值必须在数据源最后按序添加进去
width: 'auto',
height: 'auto',
pgtext: ' of',
mtype: "POST",
viewrecords: true,
recordtext: 'View {0} – {1} of {2}',
pgtext: 'Page {0} of {1}',
multiselect: true,
arrayData: true,
sortorder: 'desc',
jsonReader: {
root: "rows", //our data
page: "page", //current page
total: "total", //total pages
records: "records", //total records
repeatitems: false,
id: 'WareHouseCode'
},
caption:"JSON Example",
footerrow: true, userDataOnFooter: true,
rownumbers: true, rownumWidth: 40, gridview: true,
onSelectRow: function(ids) { curRowId = ids;
var data = $("#jsonopt").getRowData(ids);
} }); } $(document).ready(function() { createGrid();
});</script>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div id="outterDiv" align="center">
<tr>
<td valign="top">
<table id="jsonopt" class="scroll" cellpadding=0 cellspacing=0>
</table>
</td> </tr>
<div id="pjopt" class=scroll style="text-align:left; " align=left>
</div>
</div>
</form>
</body>
</html>后台代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;namespace Hitech.Web.Paper
{
public partial class test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Action"] == "GetData")
{
//列名
string[] columns = new string[] { "WareHouseCode","WareHouseName","SearchCode","SimpleName","State","Note" };
String pageIndex = "1";
String pageSize = "20";
//读取数据库中的数据
int sum = 0;
DataTable dt = new Hitech.BLL.T_PM_PaperWareHouse().GetDataTable(Convert.ToInt32(pageIndex), Convert.ToInt32(pageSize), out sum); //将数据拼凑成json格式
string dataStr = "";
dataStr = Hitech.Common.BasePage.DtToSON2(dt, columns, pageIndex, pageSize, sum.ToString()); //返回客户端
Response.Clear();
Response.Write(dataStr);
Response.End(); }
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货