Existing Connection Example --- DataGrid Connection Examples -- Paging Example -- New Methods/Properties -- Error Properties
"Sort By" example using sort_clsDataGrid.asp
Code Used for following DataGrid:
---------------------------------
Set objDataGrid = New clsDataGrid
Set objDataGrid.Connection = objConn
objDataGrid.Command = strQuery
objDataGrid.PageResults = True
objDataGrid.PageSize = 10
objDataGrid.CurrentRecord = intBegRec
Call objDataGrid.SetTableOptions("100%", 2, 2, 0)
objDataGrid.GridClassName = "clsgrid"
objDataGrid.HeaderClassName = "clsheader"
objDataGrid.ItemClassName = "clsitem"
objDataGrid.AltItemClassName = "clsitemalt"
objDataGrid.FooterClassName = "clsfooter"
objDataGrid.PagingLinkClass = "clslink"
Call objDataGrid.BoundColumn("testID", "Character ID")
Call objDataGrid.BoundColumn("testCharacter", "Character Name")
Call objDataGrid.BoundColumn("testFromWhat", "Book/Show")
Call objDataGrid.BoundColumn("testDate", "Date Entered")
objDataGrid.Bind()
Set objDataGrid = Nothing
Character ID | Character Name | Book/Show | Date Entered |
12 | Eric Cartman | South Park | 08/10/2002 |
13 | Kyle Broflovski | South Park | 08/10/2002 |
14 | Stan Marsh | South Park | 08/10/2002 |
15 | Kenny McCormick | South Park | 08/10/2002 |
16 | Scott Tenorman | South Park | 08/10/2002 |
17 | Elaine Benes | Seinfeld | 08/10/2002 |
18 | Kenny Banya | Seinfeld | 08/10/2002 |
19 | Uncle Leo | Seinfeld | 08/10/2002 |
20 | Soup Nazi | Seinfeld | 08/10/2002 |
21 | Priest Maxi | South Park | 08/10/2002 |
« Previous 10 Next 10 » |