客户端回调实现gridView无刷新分页第三页

客户端回调实现gridView无刷新分页

日期：2007年10月12日 作者： 查看:[ 大字体 中字体 小字体]

• 
  
  
  border="0" marginwidth="0" marginheight="0" src="http://www.hackhome.com/gg/web/ff_468.html" frameborder="no" width="468" scrolling="no" height="0">
  
  
• <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-0692289505803928&dt=1206921579015&lmt=1199876374&format=300x250_as&output=html&correlator=1206921579015&channel=6926205886&url=http%3A%2F%2Fwww.hackhome.com%2FInfoView%2FArticle_151990_3.html&color_bg=FFFFFF&color_text=000000&color_link=000060&color_url=008000&color_border=FFFFFF&ad_type=text_image&ref=http%3A%2F%2Fwww.hackhome.com%2FInfoView%2FArticle_151990_2.html&frm=0&cc=100&ga_vid=360051387.1206921579&ga_sid=1206921579&ga_hid=2079331661&flash=9.0.47.0&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=480&u_his=2&u_java=true" frameborder="0" width="300" scrolling="no" height="250" allowtransparency="allowtransparency">        v_sql:=v_sql 'ORDER BY ' v_orderfield v_order;
        ----执行分页查询
        v_heiRownum := p_PageIndex * p_PageSize;
        v_lowRownum := v_heiRownum - p_PageSize + 1;

   

        v_sql := 'SELECT * FROM (
                        SELECT A.*, rownum rn FROM (' v_sql ') A WHERE rownum <= ' to_char(v_heiRownum) ') B WHERE rn >= ' to_char(v_lowRownum) ;

  
        OPEN RET_CURSOR FOR v_sql;

         EXCEPTION
          WHEN NO_DATA_FOUND THEN
                    ERRORCODE:=9999;
          WHEN OTHERS THEN
                    ERRORCODE:=9999;
     END QUERYLOG;
    
     END H_QUERYPACK;
   二、程序

  DataAccess.cs

   

  using System;
  
  using System.Data;
  using System.Data.OracleClient;
  using System.Collections;
  using System.Collections.Specialized;

  /** <summary>
  ///数据层  author: EvoRul   date:2007-03-29
  /// </summary>
  public class DataAccess
  ...{

      /** <summary>
      /// 返回数据库连接字符串
      /// </summary>
      public static String DatabaseConnectionString
      ...{
          get
  

•