asp.net – JQGrid不显示数据

asp.Net 前端之家
前端之家收集整理的这篇文章主要介绍了asp.net – JQGrid不显示数据，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
我为JQgrid和ASP.net创建了客户端和服务器端.显示网格但没有数据.我看不出结果.网格显示但没有数据.

服务器端
编码

  1. using System;
  2.     using System.Collections.Generic;
  3.     using System.Collections.ObjectModel;
  4.     using System.Data;
  5.     using System.Data.sqlClient;
  6.     using System.Web;
  7.     using System.Web.Script.Serialization;
  8.  
  9.     namespace sample
  10.     {
  11.         public struct JQGridResults
  12.         {
  13.             public int page;
  14.             public int total;
  15.             public int records;
  16.             public JQGridRow[] rows;
  17.  
  18.         }
  19.         public struct JQGridRow
  20.         {
  21.             public int id;
  22.             public string[] cell;
  23.         }
  24.  
  25.         [Serializable]
  26.         public class User
  27.         {
  28.             public int UserID
  29.             { get; set; }
  30.  
  31.             public string UserName
  32.             { get; set; }
  33.  
  34.             public string FirstName
  35.             { get; set; }
  36.  
  37.             public string MiddleName
  38.             { get; set; }
  39.  
  40.             public string LastName
  41.             { get; set; }
  42.  
  43.             public string EmailID
  44.             { get; set; }
  45.             /// <summary>
  46.             /// Summary description for jqgridhandler
  47.             /// </summary>
  48.             public class jqGridHandler : IHttpHandler
  49.             {
  50.  
  51.                 public void ProcessRequest(HttpContext context)
  52.                 {
  53.                     HttpRequest request = context.Request;
  54.                     HttpResponse response = context.Response;
  55.  
  56.                     string _search = request["_search"];
  57.                     string numberOfRows = request["rows"];
  58.                     string pageIndex = request["page"];
  59.                     string sortColumnName = request["sidx"];
  60.                     string sortOrderBy = request["sord"];
  61.  
  62.  
  63.                     int totalRecords;
  64.                     Collection<User> users = GetUsers(numberOfRows,pageIndex,sortColumnName,sortOrderBy,out totalRecords);
  65.                     string output = BuildJQGridResults(users,Convert.ToInt32(numberOfRows),Convert.ToInt32(pageIndex),Convert.ToInt32(totalRecords));
  66.                     response.Write(output);
  67.                 }
  68.  
  69.                 private string BuildJQGridResults(Collection<User> users,int numberOfRows,int pageIndex,int totalRecords)
  70.                 {
  71.  
  72.                     JQGridResults result = new JQGridResults();
  73.                     List<JQGridRow> rows = new List<JQGridRow>();
  74.                     foreach (User user in users)
  75.                     {
  76.                         JQGridRow row = new JQGridRow();
  77.                         row.id = user.UserID;
  78.                         row.cell = new string[6];
  79.                         row.cell[0] = user.UserID.ToString();
  80.                         row.cell[1] = user.UserName;
  81.                         row.cell[2] = user.FirstName;
  82.                         row.cell[3] = user.MiddleName;
  83.                         row.cell[4] = user.LastName;
  84.                         row.cell[5] = user.EmailID;
  85.                         rows.Add(row);
  86.                     }
  87.                     result.rows = rows.ToArray();
  88.                     result.page = pageIndex;
  89.                     result.total = totalRecords / numberOfRows;
  90.                     result.records = totalRecords;
  91.                     return new JavaScriptSerializer().Serialize(result);
  92.                 }
  93.  
  94.                 private Collection<User> GetUsers(string numberOfRows,string pageIndex,string sortColumnName,string sortOrderBy,out int totalRecords)
  95.                 {
  96.                     Collection<User> users = new Collection<User>();
  97.                     string connectionString = "";
  98.  
  99.                     using (sqlConnection connection = new sqlConnection(connectionString))
  100.                     {
  101.                         using (sqlCommand command = new sqlCommand())
  102.                         {
  103.                             command.Connection = connection;
  104.                             command.CommandText = "select * from tblusers" ; 
  105.                             command.CommandType = CommandType.Text; // StoredProcedure;
  106.  
  107.                             sqlParameter paramPageIndex = new sqlParameter("@PageIndex",sqlDbType.Int);
  108.                             paramPageIndex.Value = Convert.ToInt32(pageIndex);
  109.                             command.Parameters.Add(paramPageIndex);
  110.  
  111.                             sqlParameter paramColumnName = new sqlParameter("@SortColumnName",sqlDbType.VarChar,50);
  112.                             paramColumnName.Value = sortColumnName;
  113.                             command.Parameters.Add(paramColumnName);
  114.  
  115.                             sqlParameter paramSortorderBy = new sqlParameter("@SortOrderBy",4);
  116.                             paramSortorderBy.Value = sortOrderBy;
  117.                             command.Parameters.Add(paramSortorderBy);
  118.  
  119.                             sqlParameter paramNumberOfRows = new sqlParameter("@NumberOfRows",sqlDbType.Int);
  120.                             paramNumberOfRows.Value = Convert.ToInt32(numberOfRows);
  121.                             command.Parameters.Add(paramNumberOfRows);
  122.  
  123.                             sqlParameter paramTotalRecords = new sqlParameter("@TotalRecords",sqlDbType.Int);
  124.                             totalRecords = 0;
  125.                             paramTotalRecords.Value = totalRecords;
  126.                             paramTotalRecords.Direction = ParameterDirection.Output;
  127.                             command.Parameters.Add(paramTotalRecords);
  128.  
  129.  
  130.                             connection.Open();
  131.  
  132.                             using (sqlDataReader dataReader = command.ExecuteReader())
  133.                             {
  134.                                 User user;
  135.                                 while (dataReader.Read())
  136.                                 {
  137.                                     user = new User();
  138.                                     user.UserID = (int)dataReader["UserID"];
  139.                                     user.UserName = Convert.ToString(dataReader["UserName"]);
  140.                                     user.FirstName = Convert.ToString(dataReader["FirstName"]);
  141.                                     user.MiddleName = Convert.ToString(dataReader["MiddleName"]);
  142.                                     user.LastName = Convert.ToString(dataReader["LastName"]);
  143.                                     user.EmailID = Convert.ToString(dataReader["EmailID"]);
  144.                                     users.Add(user);
  145.                                 }
  146.                             }
  147.                             totalRecords = (int)paramTotalRecords.Value;
  148.                         }
  149.  
  150.                         return users;
  151.                     }
  152.  
  153.                 }
  154.                 public bool IsReusable
  155.                 {
  156.                     // To enable pooling,return true here.
  157.                     // This keeps the handler in memory.
  158.                     get { return false; }
  159.                 }
  160.             }
  161.         }
  162.     }

客户端

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="sample.aspx.cs" Inherits="sample.WebForm1" %>
  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. <!-- The jQuery UI theme that will be used by the grid -->
  9.     <link rel="stylesheet" type="text/css" media="screen" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.11/themes/redmond/jquery-ui.css" />
  10.     <!-- The jQuery UI theme extension jqGrid needs -->
  11.     <link rel="stylesheet" type="text/css" media="screen" href="themes/ui.jqgrid.css" />
  12.     <!-- jQuery runtime minified -->
  13.     <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.5.2.min.js" type="text/javascript"></script>
  14.     <!-- The localization file we need,English in this case -->
  15.     <script src="js/trirand/i18n/grid.locale-en.js"type="text/javascript"></script>
  16.     <!-- The jqGrid client-side javascript -->
  17.     <script src="js/trirand/jquery.jqGrid.min.js" type="text/javascript"></script>
  18.  
  19.     <script type="text/javascript">
  20.         $(function () {
  21.             $("#UsersGrid").jqGrid({
  22.                 url: 'jqGridHandler.ashx',datatype: 'json',height: 250,colNames: ['UserID','UserName','FirstName','MiddleName','LastName','EmailID'],colModel: [
  23.                         { name: 'UserID',index: 'UserID',width: 100,sortable: true },{ name: 'UserName',{ name: 'FirstName',{ name: 'MiddleName',{ name: 'LastName',{ name: 'EmailID',width: 150,sortable: true }
  24.                     ],rowNum: 10,rowList: [10,20,30],pager: '#UsersGridPager',sortname: 'UserID',viewrecords: true,sortorder: 'asc',caption: 'JSON Example'
  25.             });
  26.  
  27.             $("#UsersGrid").jqGrid('navGrid','#UsersGridPager',{ edit: false,add: false,del: false });
  28.         });
  29.  
  30.     </script>
  31. </head>
  32. <body>
  33.     <%--<form id="HtmlForm" runat="server">--%>
  34.     <table id="UsersGrid" cellpadding="0" cellspacing="0"></table>
  35.         <div id="UsersGridPager"></div>
  36.  
  37.    <%-- </form>--%>
  38. </body>
  39. </html>

这有什么问题？数据不显示.
谢谢

更新

  1. $(document).ready(function () {
  2.         $.ajax({
  3.             type: 'POST',contentType: "application/json; charset=utf-8",url: "jqGridHandler.ashx",success: function (result) {
  4.                 var JQResult = JSON.parse(result);
  5.  
  6.                 colD = JQResult.colData;
  7.                 colN = JQResult.colNames;
  8.                 var colM = JQResult.colModel;
  9.  
  10.                 alert(result.colModel);
  11.                 jQuery("#UsersGrid").jqGrid(
  12.                                     {
  13.                                         jsonReader: { repeatitems: false,cell: "",id: "0" },mtype: 'POST',data: colD,ColNames: colN,ColModel: ColM,height: "auto",gridview: true,Pager: '#UsersGrid',rowNum: 5,rowList: [5,10,50],loadComplete: function (data) {
  14.                                             alert('loaded completely');
  15.                                         },loadError: function () {
  16.                                             alert('error');
  17.                                         }
  18.                                     });
  19.             },error: function (x,e) {
  20.                 alert(x.readyState + ' ' + x.status + e.msg);
  21.             }
  22.         });
  23.  
  24.     });

为动态更新了vesion

  1. using System;
  2. using System.Collections.Generic;
  3. using System.Collections.ObjectModel;
  4. using System.Data;
  5. using System.Data.sqlClient;
  6. using System.Web;
  7. using System.Web.Script.Serialization;
  8.  
  9. namespace jqGridInWebForm {
  10.     /// <summary>
  11.     /// Summary description for jqGridHandler
  12.     /// </summary>
  13.     public struct JQGridResults {
  14.         public int page;
  15.         public int total;
  16.         public int records;
  17.         public JQGridRow[] rows;
  18.     }
  19.     public struct JQGridRow {
  20.         public int id;
  21.         public string[] cell;
  22.     }
  23.     public enum GridType
  24.     {
  25.         GRID_TYPE_TEXT,GRID_TYPE_DATE,GRID_TYPE_INT,GRID_TYPE_DOUBLE
  26.     }
  27.  
  28.     [Serializable]
  29.     public class User {
  30.         public int UserID { get; set; }
  31.         public string UserName { get; set; }
  32.         public string FirstName { get; set; }
  33.         public string MiddleName { get; set; }
  34.         public string LastName { get; set; }
  35.         public string EmailID { get; set; }
  36.         public string Phone { get; set; }
  37.  
  38.     }
  39.  
  40.     public class clsGridData
  41.     {
  42.         public List<string> _Columns = new List<string>();
  43.         public List<string[]> _Cells = new List<string[]>();
  44.  
  45.         public void InitFields(string P_sql,string P_TYPE)
  46.         { 
  47.             int _count;
  48.             string connectionString = "";//P_sql
  49.             using (sqlConnection connection = new sqlConnection(connectionString))
  50.             {
  51.                 using (sqlCommand command = new sqlCommand())
  52.                 {
  53.                     command.Connection = connection;
  54.                     command.CommandText = "select * from tblusers";
  55.                     command.CommandType = CommandType.Text; // StoredProcedure;
  56.                     connection.Open();
  57.  
  58.                     using (sqlDataReader dataReader = command.ExecuteReader())
  59.                     {
  60.                         string MyField;
  61.                         for (_count = 0; _count < dataReader.FieldCount; _count++)
  62.                         {
  63.                             MyField = dataReader.GetName(_count);
  64.                             _Columns.Add(MyField);
  65.                         }
  66.  
  67.                         while (dataReader.Read())
  68.                         {
  69.                             string[] MyCell = new string[dataReader.FieldCount];
  70.                             for (_count = 0; _count < dataReader.FieldCount; _count++)
  71.                             {
  72.                                 MyCell[_count] = Convert.ToString(dataReader[_count]);                                
  73.                             }
  74.                             _Cells.Add(MyCell);
  75.                         }
  76.                     }
  77.  
  78.                 }
  79.  
  80.  
  81.             }
  82.  
  83.         }
  84.     }
  85.  
  86.  
  87.  
  88.     /// <summary>
  89.         /// Summary description for jqgridhandler
  90.         /// </summary>
  91.         public class jqGridHandler: IHttpHandler 
  92.         {
  93.  
  94.  
  95.  
  96.             public void ProcessRequest(HttpContext context) {
  97.                 HttpRequest request = context.Request;
  98.                 HttpResponse response = context.Response;
  99.  
  100.  
  101.                 string _search = request["_search"];
  102.                 string numberOfRows = request["rows"];
  103.                 string pageIndex = request["page"];
  104.                 string sortColumnName = request["sidx"];
  105.                 string sortOrderBy = request["sord"];
  106.  
  107.                 //int totalRecords;
  108.                 //List<User> users = GetUsers(numberOfRows,out totalRecords);
  109.                 clsGridData i_grid_data = new clsGridData();
  110.                 i_grid_data.InitFields("","");
  111.                 string output = BuildJQGridResults(i_grid_data,Convert.ToInt32(pageIndex));
  112.                 //string output = BuildJQGridResults(users,Convert.ToInt32(totalRecords));
  113.                 response.Write (output);
  114.             }
  115.  
  116.             private string BuildJQGridResults(clsGridData P_GRID_DATA,int pageIndex)
  117.             {
  118.  
  119.                 JQGridResults result = new JQGridResults();
  120.                 List<JQGridRow> rows = new List<JQGridRow>();
  121.                 int _count;
  122.  
  123.                 foreach (String[] Cells in P_GRID_DATA._Cells)
  124.                 {
  125.                     JQGridRow row = new JQGridRow();
  126.                     row.cell = new string[Cells.GetUpperBound(0)];
  127.                     //row.id = user.UserID;
  128.                     for (_count = 0;_count< Cells.GetUpperBound(0); _count++)
  129.                     {                        
  130.                         row.cell[_count] = Cells[_count].ToString();
  131.                     }
  132.                     rows.Add(row);
  133.                 }
  134.  
  135.                 result.rows = rows.ToArray();
  136.                 result.page = pageIndex;
  137.                 result.total = (P_GRID_DATA._Cells.Count + numberOfRows - 1) / numberOfRows;
  138.                 result.records = P_GRID_DATA._Cells.Count;
  139.                 return new JavaScriptSerializer().Serialize(result);
  140.             }
  141.             //private string BuildJQGridResults(List<User> users,int totalRecords) {
  142.  
  143.             //    JQGridResults result = new JQGridResults ();
  144.             //    List<JQGridRow> rows = new List<JQGridRow> ();
  145.             //    foreach (User user in users) 
  146.             //    {
  147.             //        JQGridRow row = new JQGridRow ();
  148.             //        row.id = user.UserID;
  149.             //        row.cell = new string[6];
  150.  
  151.             //        row.cell[0] = user.UserID.ToString ();
  152.             //        row.cell[1] = user.UserName;
  153.             //        row.cell[2] = user.FirstName;
  154.             //        row.cell[3] = user.MiddleName;
  155.             //        row.cell[4] = user.LastName;
  156.             //        row.cell[5] = user.EmailID;
  157.             //        row.cell[6] = user.Phone ;
  158.  
  159.  
  160.  
  161.             //        rows.Add (row);
  162.             //    }
  163.             //    result.rows = rows.ToArray ();
  164.             //    result.page = pageIndex;
  165.             //    result.total = (totalRecords + numberOfRows - 1) / numberOfRows;
  166.             //    result.records = totalRecords;
  167.             //    return new JavaScriptSerializer ().Serialize (result);
  168.             //}
  169.  
  170.  
  171.  
  172.  
  173.             private List<User> GetDummyUsers(string numberOfRows,out int totalRecords) 
  174.             {
  175.                 var data = new List<User> 
  176.                 {
  177.                     new User(){EmailID = "test@microsoft.com",FirstName = "John",LastName = "Araya",UserID = 1,UserName = "Efrem"}
  178.                 };
  179.                 totalRecords = data.Count;
  180.                 return data;
  181.             }
  182.  
  183.  
  184.         private List<User> GetUsers(string numberOfRows,out int totalRecords) 
  185.         {
  186.                 List<User> users = new List<User> ();
  187.  
  188.                 string connectionString = "";
  189.  
  190.                 using (sqlConnection connection = new sqlConnection (connectionString)) 
  191.                 {
  192.                     using (sqlCommand command = new sqlCommand ()) 
  193.                     {
  194.                         command.Connection = connection;
  195.                         command.CommandText = "select * from tblusers";
  196.                         command.CommandType = CommandType.Text; // StoredProcedure;
  197.  
  198.                         //sqlParameter paramPageIndex = new sqlParameter ("@PageIndex",sqlDbType.Int);
  199.                         //paramPageIndex.Value = Convert.ToInt32 (pageIndex);
  200.                         //command.Parameters.Add (paramPageIndex);
  201.  
  202.                         //sqlParameter paramColumnName = new sqlParameter ("@SortColumnName",50);
  203.                         //paramColumnName.Value = sortColumnName;
  204.                         //command.Parameters.Add (paramColumnName);
  205.  
  206.                         //sqlParameter paramSortorderBy = new sqlParameter ("@SortOrderBy",4);
  207.                         //paramSortorderBy.Value = sortOrderBy;
  208.                         //command.Parameters.Add (paramSortorderBy);
  209.  
  210.                         //sqlParameter paramNumberOfRows = new sqlParameter ("@NumberOfRows",sqlDbType.Int);
  211.                         //paramNumberOfRows.Value = Convert.ToInt32 (numberOfRows);
  212.                         //command.Parameters.Add (paramNumberOfRows);
  213.  
  214.                         //sqlParameter paramTotalRecords = new sqlParameter ("@TotalRecords",sqlDbType.Int);
  215.                         //totalRecords = 0;
  216.                         //paramTotalRecords.Value = totalRecords;
  217.                         //paramTotalRecords.Direction = ParameterDirection.Output;
  218.                         //command.Parameters.Add (paramTotalRecords);
  219.  
  220.  
  221.                         connection.Open ();
  222.  
  223.                         using (sqlDataReader dataReader = command.ExecuteReader ()) 
  224.                         {
  225.                             User user;
  226.                             while (dataReader.Read ()) 
  227.                             {
  228.                                 user = new User ();
  229.                                 user.UserID = (int)dataReader["UserID"];
  230.                                 user.UserName = Convert.ToString (dataReader["UserName"]);
  231.                                 user.FirstName = Convert.ToString (dataReader["FirstName"]);
  232.                                 user.MiddleName = Convert.ToString (dataReader["MiddleName"]);
  233.                                 user.LastName = Convert.ToString (dataReader["LastName"]);
  234.                                 user.EmailID = Convert.ToString (dataReader["EmailID"]);
  235.                                 users.Add (user);
  236.                             }
  237.                         }
  238.                         //totalRecords = (int)paramTotalRecords.Value;
  239.                     }
  240.                     totalRecords = 0;
  241.                     return users;
  242.                 }
  243.  
  244.             }
  245.             public bool IsReusable {
  246.                 // To enable pooling,return true here.
  247.                 // This keeps the handler in memory.
  248.                 get { return false; }
  249.             }
  250.     }
  251.  
  252.  
  253. }

解决方法

我修改了源代码,现在记录显示非常顺利,但唯一的问题是搜索不起作用,请你看看吗？我的代码如下：

aspx页面：

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="JQGrid.aspx.cs" Inherits="JQGrid" %>
  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 id="Head1" runat="server">
  7.     <title></title>
  8.     <%--<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.8/themes/ui-darkness/jquery-ui.css" type="text/css" media="all" />--%>
  9.  
  10.     <link rel="stylesheet" type="text/css" media="screen" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/themes/redmond/jquery-ui.css" />
  11.     <link href="jqScripts/css/ui.jqgrid.css" rel="stylesheet" type="text/css" />
  12.     <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js" type="text/javascript"></script>
  13.     <script src="jqScripts/js/i18n/grid.locale-en.js" type="text/javascript"></script>
  14.     <script src="jqScripts/js/jquery.jqGrid.min.js" type="text/javascript"></script>
  15.  
  16.     <script type="text/javascript">
  17.         $(function () {
  18.             $("#UsersGrid").jqGrid({
  19.                 url: 'jqGridHandler.ashx',colNames: ['CustomerID','CompanyName','ContactName','ContactTitle','Address','City','PostalCode','Country'],colModel: [
  20.                         { name: 'CustomerID',index: 'CustomerID',width: 75,{ name: 'CompanyName',{ name: 'ContactName',{ name: 'ContactTitle',{ name: 'Address',{ name: 'City',{ name: 'PostalCode',{ name: 'Country',sortname: 'CustomerID',caption: 'My Data'
  21.             });
  22.  
  23.             $("#UsersGrid").jqGrid('navGrid',del: false });
  24.         });
  25.  
  26.     </script>
  27.  
  28. </head>
  29. <body>
  30.     <form id="HtmlForm" runat="server">
  31.     <table id="UsersGrid" cellpadding="0" cellspacing="0">
  32.         <div id="UsersGridPager">
  33.         </div>
  34.     </table>
  35.     </form>
  36. </body>
  37. </html>

和ashx：

  1. <%@ WebHandler Language="C#" Class="jqGridHandler" %>
  2.  
  3. using System;
  4. using System.Collections.Generic;
  5.  
  6. using System.Collections.ObjectModel;
  7.  
  8. using System.Data;
  9.  
  10. using System.Data.sqlClient;
  11.  
  12. using System.Web;
  13.  
  14. using System.Web.Script.Serialization;
  15.  
  16. public class jqGridHandler : IHttpHandler
  17. {
  18.  
  19.     public void ProcessRequest(HttpContext context)
  20.     {
  21.         HttpRequest request = context.Request;
  22.         HttpResponse response = context.Response;
  23.  
  24.         string _search = request["_search"];
  25.         string numberOfRows = request["rows"];
  26.         //string numberOfRows = "10";
  27.         string pageIndex= request["page"];
  28.         string sortColumnName= request["sidx"];
  29.         string sortOrderBy = request["sord"];
  30.  
  31.  
  32.         int totalRecords;
  33.         //public DataTable GetDataTable(string sidx,string sord,int page,int pageSize)
  34.         Collection<User> users = GetUsers(numberOfRows,out totalRecords,_search);
  35.         string output = BuildJQGridResults(users,Convert.ToInt32(totalRecords));
  36.         response.Write(output);
  37.     }
  38.  
  39.     private string BuildJQGridResults(Collection<User> users,int totalRecords)
  40.     {
  41.  
  42.         JQGridResults result = new JQGridResults();
  43.         List<JQGridRow> rows = new List<JQGridRow>();
  44.         foreach (User user in users)
  45.         {
  46.             JQGridRow row = new JQGridRow();
  47.             row.id = user.CustomerID;
  48.             row.cell = new string[8];
  49.             row.cell[0] = user.CustomerID;
  50.             row.cell[1] = user.CompanyName;
  51.             row.cell[2] = user.ContactName;
  52.             row.cell[3] = user.ContactTitle;
  53.             row.cell[4] = user.Address;
  54.             row.cell[5] = user.City;
  55.             row.cell[6] = user.PostalCode;
  56.             row.cell[7] = user.Country;
  57.  
  58.             rows.Add(row);
  59.         }
  60.         result.rows = rows.ToArray();
  61.         result.page = pageIndex;
  62.         result.total = totalRecords / numberOfRows;
  63.         result.records = totalRecords;
  64.         return new JavaScriptSerializer().Serialize(result);
  65.     }
  66.  
  67.     private Collection<User> GetUsers(string numberOfRows,out int totalRecords,string _search)
  68.     {
  69.         Collection<User> users = new Collection<User>();
  70.         string connectionString = "Data Source=ritetechno\\sqlexpress;Initial Catalog=Northwind;Integrated Security=True";
  71.         //<add name="constr" connectionString="Data Source=Abdul-THINK;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.sqlClient"/>
  72.  
  73.         using (sqlConnection connection = new sqlConnection(connectionString))
  74.         {
  75.             using (sqlCommand command = new sqlCommand())
  76.             {
  77.                 int numRows=Convert.ToInt32(numberOfRows)*(Convert.ToInt32(pageIndex));
  78.                 int excluderows=Convert.ToInt32(numberOfRows)*((Convert.ToInt32(pageIndex)-1));
  79.                 command.Connection = connection;
  80.                 command.CommandText = "SELECT TOP " + numRows + " CustomerID,CompanyName,ContactName,ContactTitle,Address,City,PostalCode,Country FROM Customers WHERE CustomerID NOT IN (SELECT TOP " + excluderows +" CustomerID FROM Customers)";
  81.                 command.CommandType = CommandType.Text;
  82.                 connection.Open();
  83.  
  84.                 using (sqlDataReader dataReader = command.ExecuteReader())
  85.                 {
  86.                     User user;
  87.                     while (dataReader.Read())
  88.                     {
  89.                         user = new User();
  90.                         user.CustomerID = Convert.ToString(dataReader["CustomerID"]);
  91.                         user.CompanyName = Convert.ToString(dataReader["CompanyName"]);
  92.                         user.ContactName = Convert.ToString(dataReader["ContactName"]);
  93.                         user.ContactTitle = Convert.ToString(dataReader["ContactTitle"]);
  94.                         user.Address = Convert.ToString(dataReader["Address"]);
  95.                         user.City = Convert.ToString(dataReader["City"]);
  96.                         user.PostalCode = Convert.ToString(dataReader["PostalCode"]);
  97.                         user.Country = Convert.ToString(dataReader["Country"]);
  98.                         users.Add(user);                        
  99.                     } 
  100.                 }
  101.                 string cmdTotRec = "SELECT COUNT(*) FROM Customers";
  102.                 sqlCommand chkTotRec = new sqlCommand(cmdTotRec,connection);
  103.                 totalRecords = Convert.ToInt32(chkTotRec.ExecuteScalar().ToString());
  104.                 connection.Close();
  105.             }
  106.  
  107.             return users;
  108.         }
  109.  
  110.     }
  111.     public bool IsReusable
  112.     {
  113.         // To enable pooling,return true here.
  114.         // This keeps the handler in memory.
  115.         get { return false; }
  116.     }
  117.  
  118.     public struct JQGridResults
  119.     {
  120.         public int page;
  121.         public int total;
  122.         public int records;
  123.         public JQGridRow[] rows;
  124.  
  125.     }
  126.     public struct JQGridRow
  127.     {
  128.         public string id;
  129.         public string[] cell;
  130.     }
  131.  
  132.     [Serializable]
  133.     public class User
  134.     {
  135.         public string CustomerID { get; set; }
  136.         public string CompanyName { get; set; }
  137.         public string ContactName { get; set; }
  138.         public string ContactTitle { get; set; }
  139.         public string Address { get; set; }
  140.         public string City { get; set; }
  141.         public string PostalCode { get; set; }
  142.         public string Country { get; set; }
  143.     }
  144. }

猜你在找的asp.Net相关文章

.NetCore+WebUploader实现大文件分片上传
项目要求通过网站上传大文件，比如视频文件，通过摸索实现了文件分片来上传，然后后台进行...
CentOS7下让Asp.Net Core的网站自动运行
安装新版本的Nginx（vim /etc/yum.repos.d/nginx.repo） [nginx-stable] name=nginx stabl...
使用SignalR ASP.NET Core来简单实现一个后台实时推送数据给Echarts展示图表的功能
什么是 SignalR&#160;ASP.NET Core ASP.NET Core SignalR 是一种开放源代码库，可简化...
.NETCore项目在Windows下构建Docker镜像并本地导出分发到CentOS系统下
在Windows下使用Docker，我们选择Docker Desktop这个软件，非常方便。 ## Docker Desktop介...
C#编写运行在Linux环境下的采用Mediainfo来获取多媒体文件信息的代码
项目开始设计的是运行在windows下，所以一开始采用的是windows服务模式来获取多媒体文件信...
Blazor Server App Cannot find the fallback endpoint specified by route values
github官方issues中提到的解决方案，CreateBuilder时指定项目绝对路径可以解决。 1 // 指定...
ASP.NET CORE使用WebUploader对大文件分片上传，并通过ASP.NET CORE SignalR实时反馈后台处理进度给前端展示
本次，我们来实现一个单个大文件上传，并且把后台对上传文件的处理进度通过ASP.NET CORE S...
解决WPF+Avalonia在openKylin系统下默认字体问题
一、openKylin简介 openKylin（开放麒麟） 社区是在开源、自愿、平等和协作的基础上，由基...
WTM的项目中EFCore如何适配人大金仓数据库
一、WTM是什么 WalkingTec.Mvvm框架（简称WTM）最早开发与2013年，基于Asp.net MVC3 和 最...
实现ASP.Net Core3.1运行在DockeDesktop下并用Nginx实现负载均衡
一、首先去https://docs.docker.com/get-docker/下载Windows版本的Docker Desktop并安装（...
PHPJavaJava SEPythonC#C&C++RubyVBasp.NetGoPerlnettyDjangoDelphiJsp.NET CoreSpringFlaskSpringbootSpringMVCLuaLaravelMybatisAspGroovyThinkPHPYiiswoole
文件时间pythonm相等性PHP Warning时间问题问题解决pcntl_signal采样点wav模块动态文本调用频率限制对外暴露多个访问请求更新数据表模型结构type()方法比较速度手写体sobel算子保存模型Image类nn.Conv2dpytorch1.0kaggleDCGAN交并比range()用法打印模型反卷积卷积