Asp Sortable Table

Click a header to sort a column.
LastName FirstName BirthDate Salary
Davolio Nancy 08/12/194880,000.00
Fuller Andrew 19/02/1952120,000.00
Leverling Janet 30/08/196375,000.00
Peacock Margaret 19/09/193785,000.00
Buchanan Steven 04/03/195590,000.00
Suyama Michael 02/07/1963700,000.00
King Robert 29/05/196078,000.00
Callahan Laura 09/01/195883,000.00
Dodsworth Anne 27/01/196665,000.00

*Price: $5.95 - Immediate download


Implementation

1. Select a desirable date format:
'dateFormat = "mm/dd/yyyy"
dateFormat = "dd/mm/yyyy"

2. Replace a physical path of the database in the connection string:
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\Inetpub\wwwroot\db\Northwind.mdb"

3. Create a SQL statement:
SQL = "Select LastName, FirstName, BirthDate, Salary From Employees"

4. Call a "WriteSortableTable" procedure with 2 parameters: SQL statement and unique table ID.
call WriteSortableTable(SQL,"id_01")