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.


Avatar of undefined
Last Comment
Big Monty

8/22/2022 - Mon
Big Monty

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.

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

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?
Your help has saved me hundreds of hours of internet surfing.
Big Monty

do you have the table set up displaying the data correctly?

yes @Big Monty. Table setup is complete & displays correct data.
Big Monty

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question