Sorry guys, but this is going to be extrememly elementary. I need to create a form where multiple records can be edited at once. Basically, I need to list available models and allow the user to enter the number of each model they would like to order and write this to the database.
Is the correct way to do this to:
1)fill a dataset with the model and order data
2)count the number of rows in the dataset
3)create a table which adds a row for each record in the dataset and adds a text box to hold the number to be ordered to the side of each row
4)loop through the dataset updating the info from the text boxes into the dataset
5)update from the dataset to the database
It seems that would work. However, the number of each model being ordered will be adjusted on a go forward basis - Today the user predicts what he plans to order in April, but in December he may realize he needs to adjust his April order amount. Hence, I would like the user to be able to edit the data directly in the dataset rather than in a text box thats hanging to the side. Is this possible?
Is the correct way to do this to:
1)fill a dataset with the model and order data
2)count the number of rows in the dataset
3)create a table which adds a row for each record in the dataset and adds a text box to hold the number to be ordered to the side of each row
4)loop through the dataset updating the info from the text boxes into the dataset
5)update from the dataset to the database
It seems that would work. However, the number of each model being ordered will be adjusted on a go forward basis - Today the user predicts what he plans to order in April, but in December he may realize he needs to adjust his April order amount. Hence, I would like the user to be able to edit the data directly in the dataset rather than in a text box thats hanging to the side. Is this possible?
