上一篇《登记人电话：查询序号仪检名称规格型号出厂编号登记日期登联系电话审核状态

 2、记得添加jQuery文件，下面是js，  样式的话自己去调节咯

<script type=> $(document).ready(function () { $().click(function () {//插叙按钮的单击事件 var item = "";//定义拼接table字符串 $().remove();//这里是为了第二次查询前面插叙的数据清空 $().append();
　　　　　　　　　　//拼接表格头 ).val();//获取查询条件等下作为参数提交到后台 $.ajax({ type: , url: ,//这个提交的路径记住是一个ashx的页面 不是aspx页面 data: { sqltj: _sqltj },//传的参数 success: function (tt) {//成功的函数 里面的tt就是执行成功返回来的string 为什么说是string类型呢 等下到后台再看 var data = JSON.parse(tt);把传过来的字符串转化为一个对象 json alert(tt);//这个是测试的 $.each(data, function (i, s) {//循环赋值到table中 item = + (i + + s[] + + s[] + + s[] + + s[] + + s[] + + s[] + + s[] + $().append(item);//拼接表格 }) }, error: function () { alert(); return; } }); }); }); </script>

大家可能疑惑ajax为啥没有指定dataType是json  我试过 那是不对的  因为后台处理后不是json传过来的

3、从后台数据库获取数据，我用的是原始的方法网站这里只需要查询这一点就不弄那么麻烦了

using System.Data; using System.Configuration; using System.Data.SqlClient; using Newtonsoft.Json; ProcessRequest(HttpContext context) { ];//接收过来的查询条件参数 , tj.ToString()); ; context.Response.ContentType = ; SqlConnection conn = new SqlConnection(); conn.ConnectionString = connectionStringgg; if(conn.State==ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandText = _sql; cmd.Connection=conn; SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; DataSet ds = new DataSet(); sda.Fill(ds); context.Response.Write(JsonConvert.SerializeObject( ds.Tables[0])); }

 后台这里记得一定要写在ProcessRequest(HttpContext context)这个方法里，你可以自己写一个方法在通过自己的处理到你写的方法里（我试过很麻烦的） 调用的路径他只会找到ProcessRequest(HttpContext context)这个方法所以写在里面就可以啦！这里要添加一个Json的处理dll文件Newtonsoft.Json.dl下载（需要的朋友单击链接下载）然后在程序集添加。

 我把字符串复制出来

[{"Name":"苹果手机","Modle":"XM0012","Number":"REQU7986","ADDTIME":"2017-08-01","Person":"魏杨 ","Phone":"17687007837","Status":"未审核"},
{"Name":"一二三四五","Modle":"上山打老虎","Number":"老虎不在家","ADDTIME":"2017-08-01","Person":"秦始皇 ","Phone":"17687007837","Status":"通过审核"},
{"Name":"抽水机","Modle":"CH54353","Number":"KJHGF956","ADDTIME":"2017-08-01","Person":"唐太宗 ","Phone":"17687007837","Status":"未审核"},
{"Name":"打火机","Modle":"YY789","Number":"89+KGF","ADDTIME":"2017-08-01","Person":"朱元璋 ","Phone":"17687007837","Status":"未审核"},
{"Name":"平板电脑","Modle":"YY900","Number":"136689","ADDTIME":"2017-08-01","Person":"赵匡胤 ","Phone":"17687007837","Status":"通过审核"},
{"Name":"鼠标","Modle":"99","Number":"99","ADDTIME":"2017-08-01","Person":"李白 ","Phone":"17687007837","Status":"通过审核"},
{"Name":"自行车","Modle":"HK330","Number":"儿童与爱哦","ADDTIME":"2017-08-01","Person":"杜甫 ","Phone":"17687007837","Status":"未审核"},
{"Name":"蓝牙耳机","Modle":"YC897978","Number":"11","ADDTIME":"2017-08-01","Person":"岑参 ","Phone":"17687007837","Status":"通过审核"},
{"Name":"机械键盘","Modle":"JDVKSL","Number":"uyuyyu","ADDTIME":"2017-08-01","Person":"曹操 ","Phone":"17687007837","Status":"未审核"},
{"Name":"终结者轮胎","Modle":"FRGGT8899","Number":";","ADDTIME":"2017-08-01","Person":"张飞 ","Phone":"17687007837","Status":"通过审核"},
{"Name":"野生鸡枞","Modle":"76HHNH","Number":"","ADDTIME":"2017-08-01","Person":"刘备 ","Phone":"17687007837","Status":"通过审核"},
{"Name":"白菜","Modle":"456","Number":"45","ADDTIME":"2017-08-01","Person":"宋江 ","Phone":"17687007837","Status":"未审核"},
{"Name":"青菜","Modle":"CGJH","Number":"DFGHJK","ADDTIME":"2017-08-02","Person":"maozedong ","Phone":"17687007837","Status":"通过审核"},
{"Name":"柴油机","Modle":"X300","Number":"1314669","ADDTIME":"2017-08-02","Person":"魏杨杨 ","Phone":"17687007837","Status":"通过审核"}]

这个就是context.Response.Write(JsonConvert.SerializeObject( ds.Tables[0])) 的 内容，很有意思看着是json 实际上却是string类型的。所以js里面 var data = JSON.parse(tt);把传过来的字符串转化为一个对象 json这一步不能少，我就在这里纠结了1天，用eval（）方法还是没有达到效果。