Avatar of jvoconnell
jvoconnell
 asked on

updating database from multiple textboxes

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.
ASP.NET.NET ProgrammingVisual Basic.NET

Avatar of undefined
Last Comment
jvoconnell

8/22/2022 - Mon
SOLUTION
srikanthreddyn143

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
gdupadhyay

1. Uset Dataset
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.
jvoconnell

ASKER
Hello, thanks for the quick responses. Based on the  reply by srikanthreddyn143:, I think I can do something using a gridview. Maybe populate the gridview with patient id and date. THen have uses select desired date and then direct them to the patient entry page. I origianlly wasn't thinking along those lines.  I was originally thinking  about displaying the patient entry page with the most recent record then trying to have some type of navigation button to the other records.


gdupadhyay:, after displaying the first record in the dataset, what would your suggestion be for moving to the next record?

Currently the data is populated on page_load. WHere would you declare the dataset so it would be recognized in the button_click event? WOuld you do something on the page itself or in a sub?

THanks for the assistance. I'm coming from a VBA environment.
ASKER CERTIFIED SOLUTION
gdupadhyay

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jvoconnell

ASKER
Thank you both for your responses. I think I will be using the session variable but I am going to be able to take something away from both of you so  I want to assign some points to  srikanthreddyn143 as well. Thanks again I appreciate it.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck