一个简单的oracle分页存储过程的实现和调用[3]

----------------------------------------------------------------------------------------------------------------------------------------------------------------

    private sub datagrid1_pageindexchanged(byval source as object, byval e as system.web.ui.webcontrols.datagridpagechangedeventargs) handles datagrid1.pageindexchanged
        dim psql as string = "select rownum rn,t.* from cd_ssxl t"

        me.datagrid1.currentpageindex = e.newpageindex
        gridbind(e.newpageindex, psql, 20)
    end sub

-----------------------------------------------------------------------------------------------------------------------------------------------------------------