由于客戶對速度和性能上的要求越來越變態,而數據量一天天的龐大,因此本人產生了數據的查詢和分頁完全由客戶端回調來實現。想法看上去復雜，實現起來也不難。廢話不多說，看程序吧。

一、存儲過程

包頭：

create or replace package H_QUERYPACK is

  -- Author  : Evorul
  -- Created : 2007-3-29
  -- Purpose : 查詢機構表
 
  -- Public type declarations
  type MYCURSOR is REF CURSOR;
   PROCEDURE QUERYLOG (RET_CURSOR OUT MYCURSOR,ERRORCODE OUT INT,p_logID int,p_StartTime Date,p_EndTime Date,p_Operator varchar2 ,p_OrderField varchar2 ,
      p_Desc int,p_PageSize Int,p_PageIndex Int,p_RecordCount Out Int);

end H_QUERYPACK;
 

包體：

   create or replace package body H_QUERYPACK Is
  -- Author  : Evorul
  -- Created : 2007-3-29
  -- Purpose : 查詢
 
  -- 查詢公司,分頁用
   PROCEDURE QUERYLOG (RET_CURSOR OUT MYCURSOR,ERRORCODE OUT INT,p_logID int,p_StartTime Date,p_EndTime Date,p_Operator varchar2 ,p_OrderField varchar2 ,
      p_Desc int,p_PageSize Int,p_PageIndex Int,p_RecordCount Out Int)
      AS
     v_sql varchar2(3000);
    v_sqlcount varchar2(3000);
    v_orderfield varchar2(100);
    v_order VARCHAR2(5); --順序
    v_count int;
    v_heiRownum int;
    v_lowRownum int;
   BEGIN
        ERRORCODE:=0;

        v_sql:='select * from LOG Where 1=1 ';

        if(p_logID <> 0)then
            v_sql := v_sql || '  and id = ' || TO_CHAR(p_logID);
        end if;

         IF p_Operator Is Not Null Then then
                v_sql := v_sql || 'And operator LIKE ''%' || RTRIM(LTRIM(p_Operator))||'%''';       
          end if;

          v_sql := v_sql ||' and (TO_CHAR(time,''YYYYMMDD'') between ''' || to_char(p_StartTime, 'YYYYMMDD') ||''' and ''' || to_char(p_EndTime, 'YYYYMMDD') ||''')';

         
       ----取記錄總數
      v_sqlcount := 'select count(*) from (' || v_sql || ')';
      execute immediate v_sqlcount into v_count;
      p_RecordCount := v_count;

        --排序字段
        IF p_OrderField IS NOT NULL THEN
           v_orderfield:=p_OrderField;
           Else
           v_orderfield:='ID';
        END IF;
        --是否降序
        IF p_Desc <>0 THEN
          v_order:=' ASC';
          Else
          v_order:=' DESC';
        END IF;
       
        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
        ...{
            NameValueCollection configSettings = (NameValueCollection)System.Configuration.ConfigurationManager.GetSection("appSettings");
            return configSettings["connectionString"];
        }
    }

    /**//// <summary>
    /// 返回每一頁顯示的紀錄數
    /// </summary>
    public static int RowsPerPage
    ...{
        get
        ...{
            NameValueCollection configSettings = (NameValueCollection)System.Configuration.ConfigurationManager.GetSection("appSettings");
            return Convert.ToInt32(configSettings["rowsPerPage"]);
        }
    }

    /**//// <summary>
    /// 獲取特定日志集合
    /// </summary>
    /// <param name="typeID">日志類型</param>
    /// <param name="userID">操作人</param>
    /// <param name="strOrderField">排序字段</param>
    /// <param name="intASC">是否升序 0-降序,1-升</param>
    /// <param name="PageIndex">頁碼</param>
    /// <param name="rowCount">頁行數</param>
    /// <param name="recordSum">符合條件的總記錄數</param>
    /// <returns></returns>
    public static ArrayList QueryLog(string strOperator,DateTime dtStartTime,DateTime dtEndTime, string strOrderField,
       int intASC, int PageIndex, int rowCount, out int recordSum)
    ...{
        // 返回集合
        ArrayList myArrayList = new ArrayList();

        // 創建連接
        OracleConnection myConnection = new OracleConnection(DatabaseConnectionString);

        try
        ...{
            // 打開連接
            myConnection.Open();
        }
        catch (Exception ex)
        ...{
            throw (ex);
        }

        try
        ...{
            // 創建存儲過程
            OracleCommand myCommand = new OracleCommand("H_QUERYPACK.QUERYLOG", myConnection);
            myCommand.CommandType = CommandType.StoredProcedure;
            OracleDataReader dr;

            // ============================== 參數定義 ==============================

            // 返回值
            myCommand.Parameters.Add("RET_CURSOR", OracleType.Cursor);
            myCommand.Parameters["RET_CURSOR"].Direction = ParameterDirection.Output;
            OracleParameter ret = myCommand.Parameters.Add("ERRORCODE", OracleType.Int32);
            ret.Direction = ParameterDirection.Output;

            OracleParameter retCountSum = myCommand.Parameters.AddWithValue("p_RecordCount", OracleType.Int32);
            retCountSum.Direction = ParameterDirection.Output;

            // 編號
            myCommand.Parameters.AddWithValue("p_logID", OracleType.Int32).Value = 0;

            // 用戶編號
            myCommand.Parameters.AddWithValue("p_Operator", OracleType.VarChar).Value = strOperator;

            // 時間下限
            myCommand.Parameters.AddWithValue("p_StartTime", OracleType.DateTime).Value = dtStartTime;

            // 時間上限
            myCommand.Parameters.AddWithValue("p_EndTime", OracleType.DateTime).Value =dtEndTime;

            // 排序字段
            myCommand.Parameters.AddWithValue("p_OrderField", OracleType.VarChar).Value = strOrderField;

            // 怎么排序
            myCommand.Parameters.AddWithValue("p_Desc", OracleType.Int32).Value = intASC;

            // 每頁行數
            myCommand.Parameters.AddWithValue("p_PageSize", OracleType.Int32).Value = rowCount;

            //頁碼
            myCommand.Parameters.AddWithValue("p_PageIndex", OracleType.Int32).Value = PageIndex;

            // ============================ 參數定義完畢 ============================

            // 執行存儲過程
            dr = myCommand.ExecuteReader();

            // 執行未成功
            if (Convert.ToInt32(ret.Value) != 0)
                throw new Exception("執行存儲過程出錯!");

            // 總記錄數
            recordSum = Convert.ToInt32(retCountSum.Value);

            while (dr.Read())
            ...{
                // 創建新日志
                Log log = new Log();

                //操作業務類型
                if (dr["operationtype"] != DBNull.Value)
                ...{
                    log.OperationType = Convert.ToString(dr["operationtype"]);
                }
                // 時間
                if (dr["time"] != DBNull.Value)
                    log.Time = Convert.ToDateTime(dr["time"]);

                // 用戶
                if (dr["operator"] != DBNull.Value)
                ...{
                    log.Operator = Convert.ToString(dr["operator"]);
                }

                // 信息
                if (dr["info"] != DBNull.Value)
                    log.Info = Convert.ToString(dr["info"]);

                // 加入返回集合
                myArrayList.Add(log);
            }

            dr.Close();
            return myArrayList;
        }
        catch (Exception ex)
        ...{
            throw (ex);
        }
        finally
        ...{
            myConnection.Close();
        }
    }
}

DataLogic.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;

/**//// <summary>
/// 業務邏輯層  author: EvoRul   date:2007-03-29
/// </summary>
public class DataLogic
...{
    public DataLogic()
    ...{
    }

    public static int recordSum = 0;

  
    /**//// <summary>
    /// 查詢日志
    /// </summary>
    /// <param name="strOperator">操作人</param>
    /// <param name="dtStarTime">時間范圍下限</param>
    /// <param name="dtEndTime">時間上限</param>
    /// <param name="Pageid">頁碼</param>
    /// <returns></returns>
    public static IEnumerable GetLogData(string strOperator,DateTime dtStarTime,DateTime dtEndTime, string Pageid)
    ...{
        return Log.GetList(strOperator,dtStarTime,dtEndTime,"time",1, Convert.ToInt32(Pageid),DataAccess.RowsPerPage,out recordSum);
    }
}

Log.cs

using System;
using System.Data;
using System.Collections;

/**//// <summary>
/// 日志類
/// </summary>
public class Log
...{
    // ============================== 成員 ==============================

    protected string operationType;
    /**//// <summary>
    /// 時間
    /// </summary>
    protected DateTime time = new DateTime();

    /**//// <summary>
    /// 用戶
    /// </summary>
    protected string m_operator;

    /**//// <summary>
    /// 信息
    /// </summary>
    protected string info = "";

    // ============================== 屬性 ==============================

    public string OperationType
    ...{
        get ...{ return operationType; }
        set ...{ operationType = value; }
    }
    /**//// <summary>
    /// 時間
    /// </summary>
    public DateTime Time
    ...{
        get ...{ return time; }
        set ...{ time = value; }
    }

    /**//// <summary>
    /// 用戶
    /// </summary>
    public string Operator
    ...{
        get ...{ return m_operator; }
        set ...{ m_operator = value; }
    }

    /**//// <summary>
    /// 信息
    /// </summary>
    public string Info
    ...{
        get ...{ return info; }
        set ...{ info = value; }
    }

    // ============================== 方法 ==============================

    /**//// <summary>
    /// 創建空日志實例
    /// </summary>
    public Log()
    ...{
    }

    /**//// <summary>
    /// 新增日志
    /// </summary>
    public void Add()
    ...{
        try
        ...{
            // 暫不支持該方法
            throw new Exception("新增日志");
        }
        catch (Exception ex)
        ...{
            throw (ex);
        }
    }

    /**//// <summary>
    /// 修改日志（不支持）
    /// </summary>
    public void Modify()
    ...{
        // 暫不支持該方法
        throw new Exception("修改日志");
    }

    /**//// <summary>
    /// 刪除日志
    /// </summary>
    public void Del()
    ...{
        // 暫不支持該方法
        throw new Exception("修改日志");
    }

    /**//// <summary>
    /// 獲取特定的日志集
    /// </summary>
    /// <param name="strOperator">操作人</param>
    /// <param name="dtStartTime">開始時間</param>
    /// <param name="dtEndTime">結束時間</param>
    /// <param name="strOrderField">排序字段</param>
    /// <param name="intASC">0-降序,1-升序</param>
    /// <param name="PageIndex">頁碼</param>
    /// <param name="rowCount">頁行數</param>
    /// <param name="recordSum">總記錄數</param>
    /// <returns></returns>
    public static ArrayList GetList(string strOperator,DateTime dtStartTime,DateTime dtEndTime,string strOrderField,int intASC, int PageIndex, int rowCount, out int recordSum)
    ...{
        return DataAccess.QueryLog(strOperator,dtStartTime,dtEndTime,strOrderField, intASC, PageIndex, rowCount, out recordSum);
    }
}

前臺頁 Default.aspx

<%...@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

<html xmlns="<head runat="server">
    <title>客戶端回調</title>
    <style type="text/CSS">...
   
    body {...}{
    font-size: 12px;
    color: #525252;
    }
td {...}{
    font-size: 12px;
    color: #525252;
}
th {...}{
    font-size: 12px
}
a:link {...}{
    color: #000000; text-decoration: none
}
a:visited {...}{
    color: #525252; text-decoration: none
}
a:hover {...}{
    color: #0095A7; text-decoration: underline
}
td.alt_1 {...}{
 border-top: 1px solid #d6d6d6;
 border-right: 1px solid #d6d6d6;
 font-size:12px;
 color: #4f6b72;
}
td.alt_2 {...}{
 border-top: 1px solid #d6d6d6;
 border-right: 1px solid #d6d6d6;
}
td.alt_3 {...}{
 border-left: 1px solid #d6d6d6;
 border-bottom: 1px solid #d6d6d6;
}
td.alt_4 {...}{
 border-left: 1px solid #d6d6d6;
 border-right: 1px solid #d6d6d6;
}
    </style>
   
    <script type="text/javascript">...
     //author: EvoRul  date:2007-03-25
       var PageIndex=1;
   
       function QueryServer(objOperator,objStartTime,objEndTime,intIndex,boolReset)
        ...{
            context = gridspan;
            context.innerHTML = "<IMG SRC='../images/pie.gif' />數據加載中...";
            arg = "ServerMethodQuery|" + objOperator.value.replace(/$/g,"")+"$"+ objStartTime.value.replace(/$/g,"")+"$"+ objEndTime.value.replace(/$/g,"") +"$"+ intIndex.toString().replace(/$/g,"")+"$"+ boolReset.toString().replace(/$/g,"");
            <%= ClientScript.GetCallbackEventReference(this, "arg", "ReceiveServerData", "context")%>;
           
        }

        function ReceiveServerData(result, context)
        ...{
           context.innerHTML = (result.split('$'))[0];
           var t1=document.getElementById("RecordSum");
           var t2=document.getElementById("PageSum");
           var t3=document.getElementById("CurrentPage");
           var t5=document.getElementById("LinkUp");
           var t6=document.getElementById("Linkdown");
          
           var t7=document.getElementById("DownListIndex");
          
           t1.innerHTML = (result.split('$'))[1];
           t2.innerHTML = (result.split('$'))[2];
           t3.innerHTML = (result.split('$'))[3];
          
           PageIndex=eval((result.split('$'))[3]);
          
           if(PageIndex>1)
           ...{
             t5.innerHTML="<a href="#" onclick="QueryServer(txtOperator,TxtStartTime,TxtEndTime,"+(PageIndex-1).toString()+",'false')">上一頁</a>";
           }
           else
             t5.innerHTML = "上一頁";
           
           if(PageIndex< eval((result.split('$'))[2]))
            ...{
             t6.innerHTML="<a href="#" onclick="QueryServer(txtOperator,TxtStartTime,TxtEndTime,"+(PageIndex+1).toString()+",'false')">下一頁</a>";
            }
           else
             t6.innerHTML="下一頁";   
            
          
           if(result.split('$').length>4)
           ...{
              var t4=document.getElementById("SpanIndex");
              t4.innerHTML = (result.split('$'))[4];
           }
          
           t7.value=PageIndex;
        }
       
        function functionPageload()
        ...{
          if(document.readyState!="complete") return;
            context = gridspan;
             arg = "ServerMethodQuery|" +"$"+"1753-1-1"+ "$"+"9999-12-31"+ "$"+ "1"+"$"+ "true";
            <%= ClientScript.GetCallbackEventReference(this, "arg", "ReceiveServerData", "context")%>;
            //頁面加載完后執行的代碼
        }

        //頁面加載狀態改變時執行的方法
        document.onreadystatechange=functionPageload;
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
      <table style="width:100%; background-color:#ffffff; margin: 0px;" cellpadding="0" cellspacing="0" border="0" id="table1">
          <tr>
             <td style="width:102%; height: 445px;" align="center" valign="top">
               <br />
               <table cellpadding="0" cellspacing="0" border="0" width="95%">
                    <tr>
                        <td><img src="../images/round-1.gif" width="13" height="30" alt="" /></td>
                        <td style="width:100%;background-color:#efefef;" class="alt_1">
                            日志查詢</td>
                    </tr>
                    <tr>
                        <td class="alt_4" valign="top" colspan="2" align="center">
                            <table cellpadding="0" cellspacing="0" border="0" width="95%">
                                <tr>
                                    <td style="width:120px; height:30px;" align="right">
                                        操作人員：</td>
                                    <td align="left" style="width: 143px">
                                        &nbsp;<asp:TextBox ID="txtOperator" runat="server" CssClass="border" ReadOnly="False"
                                            Width="90px"></asp:TextBox></td>
                                    <td style="width:71px; height:30px;" align="right">
                                        操作時間：</td>
                                    <td align="left">
                                        &nbsp;<asp:TextBox ID="TxtStartTime" runat="server" CssClass="border"
                                            ReadOnly="False" Width="90px"></asp:TextBox>-<asp:TextBox
                                                ID="TxtEndTime" runat="server" CssClass="border"
                                                ReadOnly="False" Width="90px"></asp:TextBox></td>
                                </tr>
                                <tr>
                                     <td colspan="4" style="background-image:url(../images/point.gif); height:12px;"></td>
                                </tr>
                                <tr>
                                    <td colspan="4" style="height:30px; text-align: center;">
                                        <asp:Button ID="Submit" runat="server" CssClass="btn2" Text=" 確定 " Height="20px" Width="50px" /></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" align="center">
                            <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                <tr>
                                    <td style="width:100%;" class="alt_3">　</td>
                                    <td></td>
                                 </tr>                                           
                            </table>
                        </td>
                    </tr>
                </table>
                <span id="gridspan">
                 <asp:GridView ID="Logs" runat="server" AutoGenerateColumns="False"
                     GridLines="Horizontal" PageSize="15"
                     Width="95%" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4">
                     <RowStyle ForeColor="#333333" Height="24px" BackColor="White" />
                     <SelectedRowStyle BorderColor="Red" BackColor="#339966" Font-Bold="True" ForeColor="White" />
                     <HeaderStyle BackColor="#336666" ForeColor="White" Height="30px" Font-Bold="True" />
                     <AlternatingRowStyle BorderWidth="1px" />
                     <Columns>
                         <asp:TemplateField HeaderText="用戶">
                             <ItemTemplate>
                                 <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="" Text='<%# Eval("UserInfo.Name") %>'></asp:HyperLink>
                             </ItemTemplate>
                         </asp:TemplateField>
                         <asp:TemplateField HeaderText="類型">
                             <ItemTemplate>
                                 <asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="" Text='<%# Eval("Type.Name") %>'></asp:HyperLink>
                             </ItemTemplate>
                         </asp:TemplateField>
                         <asp:TemplateField HeaderText="時間">
                             <ItemTemplate>
                                 <asp:HyperLink ID="HyperLink4" runat="server" NavigateUrl="" Text='<%# Eval("Time") %>'></asp:HyperLink>
                             </ItemTemplate>
                         </asp:TemplateField>
                         <asp:TemplateField HeaderText="備注">
                             <ItemTemplate>
                                 <asp:HyperLink ID="HyperLink5" runat="server" NavigateUrl="" Text='<%# Eval("Info") %>'></asp:HyperLink>
                             </ItemTemplate>
                         </asp:TemplateField>
                     </Columns>
                     <FooterStyle BackColor="White" ForeColor="#333333" />
                     <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
                 </asp:GridView>
                 </span>
                 <table border="0" cellpadding="0" cellspacing="0" bordercolorlight="#000000" bordercolordark="#ffffff">
                     <tr>
                         <td align="center" nowrap style="height: 25px; width: 601px;">
                             共有<asp:Label ID="RecordSum" runat="server" />條<asp:Label ID="PageSum" runat="server" />頁結果
                             &nbsp;&nbsp;&nbsp;&nbsp;當前顯示為第<asp:Label ID="CurrentPage" runat="server" />頁&nbsp;&nbsp;&nbsp;15條/頁&nbsp;&nbsp;
                             <asp:Label ID="LinkUp" runat="server" >上一頁</asp:Label>
                             <asp:Label ID="Linkdown" runat="server" >下一頁</asp:Label>
                             跳轉至第<span id="SpanIndex"><asp:DropDownList ID="DownListIndex" runat="server" Width="50px">
            </asp:DropDownList></span>頁
                         </td>
                     </tr>
                 </table>
                
                 <asp:ObjectDataSource ID="DataSourceLog" runat="server" TypeName="DataLogic" SelectMethod="GetLogData">
                     <SelectParameters>
                         <asp:ControlParameter ControlID="txtOperator" DefaultValue=" " Name="strOperator" PropertyName="Text"
                             Type="string" />
                         <asp:ControlParameter ControlID="TxtStartTime" DefaultValue="1753-1-1" Name="dtStarTime"
                             PropertyName="Text" Type="DateTime" />
                         <asp:ControlParameter ControlID="TxtEndTime" DefaultValue="9999-12-31" Name="dtEndTime"
                             PropertyName="Text" Type="DateTime" />
                          <asp:ControlParameter Name="Pageid" ControlID="DownListIndex" DefaultValue="1" PropertyName="SelectedValue" Type="String" />
                     </SelectParameters>
                 </asp:ObjectDataSource>

               </td>
            </tr>
        </table>
   
    </div>
    </form>
</body>
</html>

Default.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.IO;
using System.Text;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Globalization;

public partial class _Default : System.Web.UI.Page,ICallbackEventHandler
...{
    protected void Page_Load(object sender, EventArgs e)
    ...{
        this.Submit.Attributes.Add("onclick", "QueryServer(txtOperator,TxtStartTime,TxtEndTime,1,"true");return false;");
        this.DownListIndex.Attributes.Add("onchange", "QueryServer(txtOperator,TxtStartTime,TxtEndTime,this.value,"false");return false;");
    }

    回調分頁#region  回調分頁
    private string serverReturn;

    public string GetCallbackResult()
    ...{

        string[] parts = serverReturn.Split('|');
        //根據傳遞的方法名進行調用，并傳遞相應的參數，目前只支持一個參數
        return (string)GetType().GetMethod(parts[0]).Invoke(this, new object[] ...{ parts[1] });
    }

    public void RaiseCallbackEvent(string eventArgument)
    ...{
        serverReturn = eventArgument;
    }

    /**//// <summary>
    /// 根據從客戶端傳來的值，對GridView的內容進行更新，并將更新后的GridView的html返回
    /// </summary>
    /// <param name="arg"></param>
    /// <returns></returns>

    public string ServerMethodQuery(string arg)
    ...{
        Logs.DataSourceID = "DataSourceLog";

        string[] arrayArg = arg.Split('$');
        this.txtOperator.Text = arrayArg[0];
        this.TxtStartTime.Text= arrayArg[1];
        this.TxtEndTime.Text = arrayArg[2];

        intialPageSelect();
        this.DownListIndex.SelectedValue = arrayArg[3];
        Logs.DataBind();

        //傳入客戶端字符串,并用"$"分割
        StringBuilder strHtml = new StringBuilder();
        strHtml.Append(RenderControl(Logs));
        strHtml.Append("$");
        strHtml.Append(DataLogic.recordSum.ToString());
        strHtml.Append("$");
        strHtml.Append(Convert.ToString(DataLogic.recordSum / DataAccess.RowsPerPage + 1));
        strHtml.Append("$");
        strHtml.Append(arrayArg[3]);
        if (arrayArg[4] == "true")
        ...{
            strHtml.Append("$");

            intialPageSelect();
            strHtml.Append(RenderControl(DownListIndex));
        }

        return strHtml.ToString();
    }

    private string RenderControl(Control control)
    ...{
        StringWriter writer1 = new StringWriter(CultureInfo.InvariantCulture);
        HtmlTextWriter writer2 = new HtmlTextWriter(writer1);

        control.RenderControl(writer2);
        writer2.Flush();
        writer2.Close();

        return writer1.ToString();
    }

    /**//// <summary>
    /// 初始化頁下拉單
    /// </summary>
    private void intialPageSelect()
    ...{
        DownListIndex.Items.Clear();
        for (int i = 0; i < (DataLogic.recordSum / DataAccess.RowsPerPage + 1); i++)
        ...{
            this.DownListIndex.Items.Add(Convert.ToString(i + 1));
        }

    }
    #endregion
}
 如有錯誤，歡迎指正!