Repeater page for asp.net List Data Source

Asp tutorial. net list data source repeater page
*/

/// <Summary>
/// Obtain the corresponding data based on the current page number and number of entries per page.
/// </Summary>
/// <Param name = "pagenum"> Number of entries per page </param>
/// <Param name = "currentpage"> current page number </param>
/// <Returns> </returns>
Public static list <message> getpagesdata (int pagenum, int currentpage)
{
List <message> list = new list <message> ();
Stringbuilder sb = new stringbuilder ();
Sb. append ("select top" + pagenum + "* from zjagzm. message where ");
Sb. append ("id not in (select top" + pagenum * currentpage + "id from zjarzm. message) order by uptime desc ");
Datatable dt = dbhelpersql. getdataset (sb. tostring (), null );
Foreach (datarow row in dt. rows)
{
Message MS = new message ();
Ms. id = convert. toint32 (row ["id"]);
Ms. name = row ["name"]. tostring ();
Ms. title = row ["title"]. tostring ();
Ms. uptime = convert. todatetime (row ["uptime"]);
Ms. contents = row ["contents"]. tostring ();
List. add (MS );
}
Return list;

}