In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
Solved
updating database from multiple textboxes
Posted on 2011-03-04
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
Active 3 days ago
I dont know much about web controls like repeater etc but here is just an idea.
Have a gridview which shows all the patient info (5-10 rows of patient info)
user needs to select one of the row to see the data populated in all your textboxes.
User can edit the data in text boxes and once update button is clicked, patient id can pulled from active row of the grid and other details from text boxes.
Have a gridview which shows all the patient info (5-10 rows of patient info)
user needs to select one of the row to see the data populated in all your textboxes.
User can edit the data in text boxes and once update button is clicked, patient id can pulled from active row of the grid and other details from text boxes.
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.
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.
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.
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.
I answered based on your current design.
But GridView is the best option to display multiple records in one page or one records have multiple fields in one page. Its depened how
you need to design the page according to user requirement.
You can add dataset in a session variable. You can access anywhere in application and reset session variable when you don't need.
Or you can declared a public class with public Property.
Initiate the class object and add the values. You can use List of class object to stored multiple records.
Read the object variable to update the records in DB.
But GridView is the best option to display multiple records in one page or one records have multiple fields in one page. Its depened how
you need to design the page according to user requirement.
You can add dataset in a session variable. You can access anywhere in application and reset session variable when you don't need.
Or you can declared a public class with public Property.
Initiate the class object and add the values. You can use List of class object to stored multiple records.
Read the object variable to update the records in DB.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Introduction
This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks.
Background
I had to provide a way for user…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses
Course of the Month6 days, 7 hours left to enroll
704 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.