服务端：
1 string pseries = context.Request["ajaxSearch"].ToString().Trim(); 2 var jsonMap = new Dictionary<string, object>(); 3 StringBuilder sb = new StringBuilder(); 4 sb.AppendFormat("select * from [DB].[dbo].[config] where {0}", pseries); 5 string sql = sb.ToString(); 6 DataSet ds = DbHelperSQL.Query(sql); 7 if (ds.Tables[0].Rows.Count > 0) 8 { 9 jsonMap.Add("total", ds.Tables[0].Rows.Count); 10 Newtonsoft.Json.Linq.JArray jArry = JsonConvert.DeserializeObject<Newtonsoft.Json.Linq.JArray>(JsonConvert.SerializeObject(ds.Tables[0], Formatting.Indented).Trim()); 11 jsonMap.Add("rows", jArry); 12 } 13 context.Response.Write(JsonConvert.SerializeObject(jsonMap));
客户端：
1 var jsonstr = data;//为服务端传来数据，格式如下：{"total":1,"rows":[{"id":"001","name":"男装"}]}; 2 var jsondata = $.parseJSON(jsonstr); 3 $('#dg').datagrid('loadData', jsondata); //将数据绑定到datagrid
Better not to ignore the past but learn from it instead. Otherwise, history has a way of repeating itself.
