DataTables for a staff directory?

adammphillips

I'm fairly new to DataTables (have used it a couple of times, but for static data), and have a question. I have a MSSQL database with staff directory data in it (first name, last name, title, department, etc.). First, I want to create a table using DataTables for this (DataTables looking at MSSQL, not static data). Second, I want to be able to (1) combine columns (first and last name together), and (2) be able to sort by last name. Looking through the documentation, I'm not sure how to handle doing these things. Has anyone done anything similar?

allan

Sounds like a perfect use for DataTables. Can you create an HTML table which is generated from your MSSQL db? If so, simply apply DataTables to that table - done :-)

Allan