Dynamically Update Records
Posted on 2006-11-02
I am trying to build an addon to an existing ASP Web system with a SQL DB on the backend, so while I can customize my own code I cannot alter the existing code. Here is my problem. The system has a set of rosters for each class an instructor teaches. We want to add the ability to allow the instructors to submit final grades. So I copied the code for the rosters and modified it to not only list the students, but also a select box with the option to choose a grade for each one.
That was the easy part. The part I am struggling with is how to write the code for the page that will input the grades into their records. Thankfully it is only editing an existing record in a table that holds all of the grades for every student. But I am not sure how to essentially write code to update records when I don't know how many records and which ones until the first page is displayed.
I know I need to do some kind of Loop, but I am completely unsure of how to proceed. I hope this makes sense. Please ask any questions and I will do my best to answer them. Thanks!!