Link to home
Start Free TrialLog in
Avatar of Manju
ManjuFlag for India

asked on

Editable Datatable - Classic asp + Jquery

Experts - Kindly help me with the below problem.

I have a SQL table with many fields, which requires constant updation by end users.

I am looking something similar to this link: https://editor.datatables.net/examples/inline-editing/submitData.html

However i dont work on PHP. Kindly help modify / guide to achieve the above table with Classic asp and SQL as backend.

Regards,
Manju
Avatar of Big Monty
Big Monty
Flag of United States of America image

the majority of the work is done via javascript, you just need to make sure you have your asp code spit out the data is JSON format, which is easy to do with aspJSON. Simply include the files, and do the following server side:

sql = "select * from table"
QueryToJSON( conn, sql ).Flush

I recommend setting up your table first and getting it looking the way you want, then add the data fill part.
Avatar of Manju

ASKER

Sorry, I was away. Will check and get back to you little later today.
Avatar of Manju

ASKER

Ok, I've set up the SQL table with over 60 columns and almost 30 of them needed live update via online link.

how do i get the aspjson to read / write the columns dynamically?

do u have any sample site?
do you have the table set up displaying the data correctly?
Avatar of Manju

ASKER

yes @Big Monty. Table setup is complete & displays correct data.
ASKER CERTIFIED SOLUTION
Avatar of Big Monty
Big Monty
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial