Existing Connection Example --- DataGrid Connection Examples -- Paging Example -- New Methods/Properties -- Error Properties

"Sort By" example using sort_clsDataGrid.asp

Example using exisiting connection (CSS classes used for styles, paging used, autogeneratecols is false so we can add custom column headers). View source to see the style sheet. Inline styles can also be used.:

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 IDCharacter NameBook/ShowDate Entered
12Eric CartmanSouth Park08/10/2002
13Kyle BroflovskiSouth Park08/10/2002
14Stan MarshSouth Park08/10/2002
15Kenny McCormickSouth Park08/10/2002
16Scott TenormanSouth Park08/10/2002
17Elaine BenesSeinfeld08/10/2002
18Kenny BanyaSeinfeld08/10/2002
19Uncle LeoSeinfeld08/10/2002
20Soup NaziSeinfeld08/10/2002
21Priest MaxiSouth Park08/10/2002
« Previous 10     Next 10 »