I have a web form and the code-behind is VB.net. The database is SQL Server 2005.
The form is to enter patient data. It was set up with different sections (i.e. Patient Info, Physician info...)
The form contains @30 textboxes. The users need to enter the patient info, click a button and update the database. This works fine.
The users also need to lookup patient records, edit the data and update the database. This also works fine if the patient has one record.
So, the problem is for patients with multiple records.
The users enter a patient ID. I need to bring in all of the records for a patient (this is typically 5-10).
The first record that populates all of the textboxes on the form should be the most recent (DATE_ENTERED filed in the database).
The users want a button to move to the next record(s). They will eventually make a change on one of the records. They want to click a button and have the changes eventually update the database.
Currently, if the patient only had one record, it works by populating atll of the textboxes from a datareader. then when a button is clicked it updates the database with a sql command.
Any assistance handling a situation where the patient has multiple records is greatly appreciated.