jquery datagrid填充

最近一直在接触这些东西，javascript 脚本看了一大堆，遇到过很多的困难，最终都克服了，做技术真不容易，遇到一个问题，项目卡在那里好久，折磨的人翻来覆去，google搜索，效果甚微，

jquery datagrid 数据填充，一直没填充出来,url直接到json文件，也没数据出来，但是直接打开HTMl文件又可以有数据，用IIS和VS打开就是填充不了，我以为网上搜索能搜索到这样的问题，可就是没人提，后来在csdn上提问，有个人给我启示，

填充datagrid ，url设置成aspx样的文件，然后在aspx文件里输出json格式的字符串，就可以了，

 

代码稍后放上

 

$(function(){ $('#tabList').datagrid({ iconCls : 'icon-forward', fit : true, border : false, rownumbers : true, striped : true, pageList: [30,50,100], pagination : true, singleSelect : true, //toolbar : toolbar, url: "a.aspx", idField: 'code', datatype:'json', // frozenColumns : frozenColumns, width:300, height:250, nowrap: false, striped: true, fit: true, // url: 'type.ashx?type=loadorder', sortName: 'code', sortOrder: 'desc', idField: 'code', columns:[[ {title:'工单号',field:'code',width:130,sortable:true}, {field:'totalPrice',title:'价格',width:40,sortable:true}, {field:'precontractTime',title:'预约时间',width:120,sortable:true}, {field:'reason',title:'状态',width:90} ]], pagination:true, rownumbers:true, onDblClickRow: doDblClickRow }); $(".datagrid-view").css({ width: "300px", height: "205px" }); });

a.aspx代码出来

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Text; namespace map { public partial class a : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ssodsn"].ConnectionString); conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter("select a.orderID as code,a.charge as totalPrice,a.freightTime as precontractTime,b.statusID as reason from WorkOrder a inner join OStatus b on a.statusID=b.statusID ", conn); da.Fill(ds); StringBuilder sbvoca = new StringBuilder(); // sbvoca.Append("{/"voce/":["); sbvoca.Append("{"); if (ds != null && ds.Tables[0].Rows.Count > 0) { sbvoca.Append("/"total/":" + ds.Tables[0].Rows.Count + ","); sbvoca.Append("/"rows/":["); int i = 1; int count = ds.Tables[0].Rows.Count; foreach (DataRow dr in ds.Tables[0].Rows) { if (i == count) { sbvoca.Append("{/"code/":/"" + dr[0] + "/",/"totalPrice/":/"" + dr[1] + "/",/"freightTime/":/"" + dr[2] + "/",/"reason/":/"" + dr[3] + "/"}"); } else { sbvoca.Append("{/"code/"/":/"" + dr[0] + "/",/"totalPrice/":/"" + dr[1] + "/",/"freightTime/":/"" + dr[2] + "/",/"reason/":/"" + dr[3] + "/"},"); } i++; } } else { sbvoca.Append("total:" + 0 + ","); sbvoca.Append("rows:["); } sbvoca.Append("]}"); da.Dispose(); ds.Dispose(); conn.Close(); Response.Write(sbvoca.ToString()); Response.Flush(); } } }