Data Grid Class Example » Using Existing Database Connection

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

"Sort By" example using sort_clsDataGrid.asp

Example using exisiting connection (no styles applied -- just defined by [table] and [td] elements in style sheet -- view source to see the style sheet):

Code Used for following DataGrid:
---------------------------------
Set objDataGrid = New clsDataGrid
Set objDataGrid.Connection = objConn
objDataGrid.Command = strQuery
objDataGrid.Bind()
Set objDataGrid = Nothing

testID	testCharacter	testFromWhat	testDate
1	John Galt	Atlas Shrugged	08/10/2002
2	Hank Reardon	Atlas Shrugged	08/10/2002
3	Eddie Willers	Atlas Shrugged	08/10/2002
4	Dagny Taggart	Atlas Shrugged	08/10/2002
5	Ragnar Danneskjold	Atlas Shrugged	08/10/2002
6	Francisco D'Anconia	Atlas Shrugged	08/10/2002
7	Midas Mulligan	Atlas Shrugged	08/10/2002
8	Jerry Seinfeld	Seinfeld	08/10/2002
9	George Costanza	Seinfeld	08/10/2002
10	Cosmo Kramer	Seinfeld	08/10/2002
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
22	J. Peterman	Seinfeld	08/10/2002
23	Newman	Seinfeld	08/10/2002