SQL2005 stored procedure:

set ANSI_NULLS>
//page
protected void anpager_PageChanged (object sender, EventArgs e)
{
the bind ();

} string strWhere="1=1";
ETHaiNan. BLL. ET_Video BLL=new ETHaiNan. BLL. ET_Video ();
this. Anpager. RecordCount=int. Parse (BLL. GetRecordCount (strWhere). Tables [0]. Rows [0] [0]. ToString ());
this. Anpager. PageSize=10;
this. Anpager. AlwaysShow=true;
the DataSet ds=the BLL. GetList (anpager. StartRecordIndex, anpager EndRecordIndex, strWhere, 0).
this. RPT. The DataSource=ds;
ds. The Dispose ();

the data access layer:

///<Summary>
///get the data list page
///</summary>
public DataSet GetList(int startIndex, int endindex, string strWhere, int IsReCount)
{
SqlParameter[] parameters={
new SqlParameter("@startIndex", SqlDbType.Int),
new SqlParameter("@endindex", SqlDbType.Int),
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@OrderfldName", SqlDbType.VarChar, 255),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000)
};

the parameters [0] Value=http://www.script-home.com//article/startIndex; [1].
the parameters Value=http://www.script-home.com//article/endindex; [2].
the parameters Value="http://www.script-home.com//article/ET_Video"; [3].
the parameters Value="http://www.script-home.com//article/VideoID, Video_Name Video_TypeID, Video_OrderCode, Video_Type, Video_AddDate"; [4].
the parameters Value="http://www.script-home.com//article/VideoID"; [5].
the parameters Value=http://www.script-home.com//article/IsReCount; [6].
the parameters Value=http://www.script-home.com//article/1; [7].
the parameters Value=http://www.script-home.com//article/strWhere;
return DbHelperSQL. RunProcedure (" P_GetPagedReCord ", the parameters, "ds");

}


This concludes the body part