Classic ASP + SQL - Dynamic Form for dynamic update

Experts - I have the below SQL table:

From Classic ASP Form, User will create the form fields (Textbox - text, datetime, textarea etc) - so as to create a dynamic form.

I am displaying the table content in Classic asp and the form is displaying perfectly as well.
Classic ASP Form
Here, LabelName is the Label field(1st Field) and FieldName is the 2nd Field, FieldID is the 3rd Field and Sort Order is 4th Field.

All I need is user to change the sort order as per their wish in the form and when they hit submit, it should save the sort order correctly in SQL. Dynamic form with dynamic query.

Kindly help me please
ManjuIT - Project ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vijaya KumarCommented:
ManjuIT - Project ManagerAuthor Commented:
its .net and am looking for classic asp.
Wayne BarronAuthor, Web DeveloperCommented:
I made up a demo.
Let me know if this is what you are after, as I do not fully understand the beginning of your question.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ManjuIT - Project ManagerAuthor Commented:
can you share update.asp also pls
Wayne BarronAuthor, Web DeveloperCommented:
Always wait until you get the code, before you award points.
But it is OK for now, here it the code for the project.
If you have any question, come in and ask in this same TA.
Read the notes inside of the files.

ACN.asp = Database connection
Sort.asp = Form
Update.asp = Processing that Form.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.