asp.net下ext填充grid代码

/*** &＃64;author fox*/
Ext.onReady(function() {Ext.BLANK_IMAGE_URL &＃61; &＃39;extjs/resources/images/default/s.gif&＃39;;Ext.QuickTips.init();//var sm &＃61; new Ext.grid.CheckboxSelectionModel();var cm &＃61; new Ext.grid.ColumnModel([new Ext.grid.RowNumberer(),//sm,{ header: &＃39;用户编号&＃39;, dataIndex: &＃39;user_code&＃39;, sortable: true },{ header: &＃39;电表编号&＃39;, dataIndex: &＃39;meter_num&＃39; },{ header: &＃39;购电量&＃39;, dataIndex: &＃39;pur_power&＃39; },{ header: &＃39;购电时间&＃39;, dataIndex: &＃39;pur_date&＃39; }]);var ds &＃61; new Ext.data.GroupingStore({proxy: new Ext.data.HttpProxy({ url: &＃39;GetJson.aspx&＃39;,method: &＃39;post&＃39; }),reader: new Ext.data.JsonReader({root: &＃39;data&＃39;,totalProperty: &＃39;totalRecordCount&＃39;}, [{ name: &＃39;user_code&＃39;, mapping: &＃39;user_code&＃39;, type: &＃39;string&＃39; },{ name: &＃39;meter_num&＃39;, mapping: &＃39;meter_num&＃39;, type: &＃39;string&＃39; },{ name: &＃39;pur_power&＃39;, mapping: &＃39;pur_power&＃39;, type: &＃39;int&＃39; },{ name: &＃39;pur_date&＃39;, mapping: &＃39;pur_date&＃39;, type: &＃39;string&＃39; }])});var record_start &＃61; 0; var grid &＃61; new Ext.grid.GridPanel({el: &＃39;grid3&＃39;,ds: ds,// sm: sm,cm: cm,width: 700,height: 280,loadMask:{msg:&＃39;系统正在查询&＃xff0c;请稍候......&＃39;},bbar: new Ext.PagingToolbar({pageSize: 10,store: ds,displayInfo: true,displayMsg: &＃39;显示第 {0} 条到 {1} 条记录&＃xff0c;一共 {2} 条&＃39;,emptyMsg: "没有记录",doLoad　:　function(start){record_start　 &＃61;　start; var　o　&＃61;　{},　pn　&＃61;　this.paramNames; o[pn.start]　&＃61;　start; o[pn.limit]　&＃61;　this.pageSize; this.store.load({params:o}); }})});//el:指定html元素用于显示gridds.load({ params: { start: 0, limit: 10} });grid.render(); //渲染表格});

<%&＃64; Page Language&＃61;"C#" AutoEventWireup&＃61;"true" CodeFile&＃61;"GetJson.aspx.cs" Inherits&＃61;"GetJson" %>
<%&＃61;strJsonSource %>

public partial class GetJson : System.Web.UI.Page
{protected string strJsonSource &＃61; string.Empty;protected void Page_Load(object sender, EventArgs e){int start &＃61; int.Parse(Request.Form["start"].Trim()); //获取页面显示的起始数int limit &＃61; int.Parse(Request.Form["limit"].Trim()); //获取每页记录数SqlConnection conn &＃61; new SqlConnection();conn.ConnectionString &＃61; "server&＃61;(local);database&＃61;cpudata;user id &＃61;sa;password&＃61; 19790601";try{conn.Open();SqlCommand cmd &＃61; new SqlCommand();cmd.Connection &＃61; conn;cmd.CommandText &＃61; "select top 100 user_code,meter_num,pur_power,pur_date from pur_power_detail";SqlDataAdapter sda &＃61; new SqlDataAdapter(cmd);DataSet ds &＃61; new DataSet();sda.Fill(ds);int pageCount &＃61; ds.Tables[0].Rows.Count;DataTable dt &＃61; ds.Tables[0];strJsonSource &＃61; DataTableToJson(dt, "data", start, limit);}catch (Exception ex){Response.Write(ex.Message);}finally{conn.Close();}HttpContext.Current.Response.Write(strJsonSource);HttpContext.Current.Response.End();//strJsonSource &＃61; ReturnJson.JsonString();//HttpContext.Current.Response.Write(strJsonSource);//HttpContext.Current.Response.End();}public static string DataTableToJson(DataTable dt, string strTableName, int start, int limit){StringBuilder jsonBuilder &＃61; new StringBuilder();string head &＃61; "{ success:true,\"totalRecordCount\":\"" &＃43; dt.Rows.Count.ToString() &＃43; "\",\"";//jsonBuilder.Append("{\"");string tmpStr &＃61; "";jsonBuilder.Append(strTableName);jsonBuilder.Append("\":[");if (dt.Rows.Count > 0){int endCount &＃61; start &＃43; limit;if (endCount > dt.Rows.Count)endCount &＃61; dt.Rows.Count;for (int i &＃61; start; i }