Experts,
Newbie question.
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.
Thank you.
2. Assign all patients records into Dataset.
3. Assign the records in text box by reading data from dataset.
4. When user click on update, assign all text box value into dataset and update the database with data adapter.
5. Maintained the last access record ID to display the records in text box after update.
Let me know for any question.