Setup navigation buttons.
Obj.dbNavigationItem = "none, top, prev, next, bottom, rowplus(r+), rowminus(r-), colplus(c+), colminus(c-), filter(search), resetfilter(showall), download, reload, add, update, delete, basic5(b5), break"
| Keyword | Description |
|---|---|
| none | No buttons. |
| top | Goto top page. |
| prev | Goto previous page. |
| next | Goto next page. |
| bottom | Goto last page. |
| rowplus | Increase display rows by Pagesize. Pagesize does not change. |
| rowminus | Decrease display rows by Pagesize. Pagesize does not change. |
| colplus | Increase display col by 1. |
| colminus | Decrease display col by 1. |
| filter | Search |
| resetfilter | Reset filter criteria. If this is not specified then not show, it means user cannot reset the filter - a security feature. |
| download | Regular download and Excel download button. |
| update | Allow update activities and show update button. |
| add | Allow add activities and show add button. |
| delete | Allow delete activities and show delete button. |
| b5 | (Def) Show top,bottom,prev,next,Reload buttons |
| break | Add a <BR> and show rest of buttons in next line. |
| Reload | Reload all data |
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim Q As New Tornado.Z()
Q.dbQP = "Unit=1| Skin=1| Mode=Grid| DSN=Nwind| SQL=Select * From Orders|" & _
"Th=Ti=Demo - Naivgation| GridDisplayflds=0,1,2,3,4| Navigationitem=basic5," & _
"break,add,update,delete,break,rowplus,rowminus,filter,resetfilter"
Q.ASPdbNET()
End Sub
</script>
To display the navigation bar both at the top and bottom, add the following line - Q.dbGridTemplate = "<center>[[GridNav]]<P>[[Grid]]<p>[[GridNav]]<P>[[GridStat]]</center>"
z Class | Tornado Namespace | dbPageSize | dbStatusBar