SQL Plus DataView for a simple paging

Principle: On existing SQL, add Row_number () function, get line number, save query data to DataTable, then use View DataView to compare with line number, filter unwanted data.

String sqlstr = "Select Row_number () over  [ORDER by buit_id Desc] as row,* from businessinformationtable";            DataTable dt = Mysql.dataselect (sqlstr, "table"). Tables[0];            DataView dv = new DataView (DT);            Dv. RowFilter = "Row > Row <=";            Gridview1.datasource = DV;            Gridview1.databind ();

　　

SQL Plus DataView for a simple paging