ASP.NET结合存储过程写的通用搜索分页程序

ASP.NET结合存储过程写的通用搜索分页程序 
  
［作者：不详    转贴自：不详    点击数：567    字体:【大 中 小】    更新时间：2006-2-24 21:54:04］ 

存储过程改自bigeagle的论坛分页程序。请大家批判！：）
select.aspx 
--------------------------------------------------------------------------------

<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

    protected void Page_Load(Object sender, EventArgs e)
         {
             int intPageNo,intPageSize,intPageCount;
             intPageSize = 25;
             if (Request["CurrentPage"]==null) 
                 {
                     intPageNo = 1;
                 }
             else
                 {
                     intPageNo = Int32.Parse(Request["CurrentPage"]);
                 }
             
             
             SqlConnection mySqlConnection = new SqlConnection("server=(local);Database=test;user id=sa;password=");
             SqlCommand mySqlCommand = new SqlCommand("up_GetTopicList", mySqlConnection);
             mySqlCommand.CommandType = CommandType.StoredProcedure;