asp.net学习_分页的设计(16)

  58:                      Json.Append(",");
  59:                      Json.Append("\"state1\":\"" + Info.state1 + "\"");
  60:                      Json.Append(",");
  61:                      Json.Append("\"hit\":\"" + Info.hit + "\"");
  62:                      Json.Append(",");
  63:                      Json.Append("\"rank\":\"" + Info.rank + "\"");
  64:                      Json.Append("}");
  65:                      if(Info != masterInfo.Last())
  66:                      {
  67:                          Json.Append(",");
  68:                      }
  69:                  }
  70:              Json.Append("]}");
  71:              return Json.ToString();
  72:          }
存储过程:一直就用的上网找的,一个非常完美的存储过程:(感觉优化的很好,我做了多次封装,用起来非常方便):
   1:  USE [czcraft]
   2:  GO
   3:  /****** 对象:  StoredProcedure [dbo].[pagination]    脚本日期: 04/26/2012 21:04:21 ******/
   4:  SET ANSI_NULLS ON
   5:  GO
   6:  SET QUOTED_IDENTIFIER ON
   7:  GO
   8:  CREATE PROCEDURE [dbo].[pagination]
   9:       @tblName varchar(255), -- 表名