We have a master/detail form, specifically is for an inventory system.
The application is for ASP and we are using developer express aspxtragrid.
We are using AJAX so we dont have postbacks, we want to add a row using a custom control, the control has a product search textbox (using AJAX), some other text input fields and then a save button.
We are having problems with the grid, we save the data in DB and then refetch the datasource, the problem is that sometimes we have up to 1,000 rows on the detail grid, so we dont want to be refetching the grid datasource on each update.
What is recommended here? Can we save all the data as a variable an then send one transaction to database?? Or can we make the insert on database and in the front end so we dont have to refetch all the collection???
Regards and we aprpreciate your help