jquery easyUI datagrid 绑定数据库
后台取数据程序
View Code
1 using System; 2 using System.Collections.Generic; 3 using System.Web; 4 using System.Data; 5 using System.Configuration; 6 using Newtonsoft.Json; 7 using System.Text; 8 using System.IO; 9 namespace zbjjSms.test 10 { 11 /// <summary> 12 /// jsonSms_group 的摘要说明 13 /// </summary> 14 public class jsonSms_group : IHttpHandler 15 { 16 //string ="{"total":"28","rows":[{"itemid":"EST-1","productid":"FI-SW-01","listprice":"16.50","unitcost":"10.00","status":"P","attr1":"Large"},{"itemid":"EST-10","productid":"K9-DL-01","listprice":"18.50","unitcost":"12.00","status":"P","attr1":"Spotted Adult Female"},{"itemid":"EST-11","productid":"RP-SN-01","listprice":"18.50","unitcost":"12.00","status":"P","attr1":"Venomless"},{"itemid":"EST-12","productid":"RP-SN-01","listprice":"18.50","unitcost":"12.00","status":"P","attr1":"Rattleless"},{"itemid":"EST-13","productid":"RP-LI-02","listprice":"18.50","unitcost":"12.00","status":"P","attr1":"Green Adult"},{"itemid":"EST-14","productid":"FL-DSH-01","listprice":"58.50","unitcost":"12.00","status":"P","attr1":"Tailless"},{"itemid":"EST-15","productid":"FL-DSH-01","listprice":"23.50","unitcost":"12.00","status":"P","attr1":"With tail"},{"itemid":"EST-16","productid":"FL-DLH-02","listprice":"93.50","unitcost":"12.00","status":"P","attr1":"Adult Female"},{"itemid":"EST-17","productid":"FL-DLH-02","listprice":"93.50","unitcost":"12.00","status":"P","attr1":"Adult Male"},{"itemid":"EST-18","productid":"AV-CB-01","listprice":"193.50","unitcost":"92.00","status":"P","attr1":"Adult Male"}]}"; 17 static string constr = "Host=192.168.1.106;Port=1521;User ID=xch;Password=xch; SID=orcl;LicensePath=H:\\xchPrj\\zbjjsms\\zbjjSms\\DDTek.lic"; 18 string sql = "select * from SMS_GROUP"; 19 int rownum = 0; 20 //public DataSet dataSetdb() 21 //{ 22 // try 23 // { 24 // OracleHelper conDB = new OracleHelper(constr); 25 // DataSet testds = conDB.Query(sql); 26 27 28 // return testds; 29 // } 30 // catch (Exception ex) 31 // { 32 // //context.Response.Write("Hello World"); 33 // DataSet testds = new DataSet(); 34 // return testds; 35 // } 36 //} 37 38 public void ProcessRequest(HttpContext context) 39 { 40 context.Response.ContentType = "text/plain"; 41 //context.Response.Write("Hello World"); 42 43 try 44 { 45 OracleHelper conDB = new OracleHelper(constr); 46 DataSet testds = conDB.Query(sql); 47 //testds. testds.Tables[0] 48 string json = JsonConvert.SerializeObject(testds.Tables[0]); 49 // JsonConvert. 50 51 //StringBuilder sb = new StringBuilder(); 52 //sb.Append("{\"total\":\"10\",\"rows\""); //:\"10\" 53 //json = json.Replace("{\"Table\"", sb.ToString()); 54 55 context.Response.Write(json); 56 57 // return testds; 58 } 59 catch (Exception ex) 60 { 61 context.Response.Write(ex.ToString()); 62 // DataSet testds = new DataSet(); 63 // return testds; 64 } 65 66 } 67 68 public bool IsReusable 69 { 70 get 71 { 72 return false; 73 } 74 } 75 } 76 }
前台页面源码
View Code
1 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm3.aspx.cs" Inherits="zbjjSms.test.WebForm3" %> 2 3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 4 5 <html xmlns="http://www.w3.org/1999/xhtml"> 6 <head runat="server"> 7 <title>数据绑定</title> 8 <link rel="stylesheet" type="text/css" href="../easyui/themes/default/easyui.css"> 9 <link rel="stylesheet" type="text/css" href="../easyui/themes/icon.css"> 10 <script type="text/javascript" src="../easyui/jquery-1.7.2.min.js"></script> 11 <script type="text/javascript" src="../easyui/jquery.easyui.min.js"></script> 12 </head> 13 <body> 14 <form id="form1" runat="server"> 15 <div> 16 <table id="tt" class="easyui-datagrid" style="width:600px;height:250px" 17 url="jsonSms_group.ashx" 18 title="部门组织表" iconCls="icon-save" 19 rownumbers="true" pagination="true"> 20 <thead> 21 <tr> 22 <th field="BMBH" width="80">部门编号</th> 23 <th field="SSBMHB" width="80">所属部门编号</th> 24 <th field="BMMC" width="80" align="right">部门名称</th> 25 <%-- <th field="unitcost" width="80" align="right">Unit Cost</th> 26 <th field="attr1" width="150">Attribute</th> 27 <th field="status" width="60" align="center">Stauts</th> --%> 28 </tr> 29 </thead> 30 </table> 31 32 </div> 33 </form> 34 </body> 35 </html>
