Hi, I have a requirement in which i have to update multiple records at the same time. I am at the moment updating each record at a time by allowing the user to click the edit button and then change the data value in the textbox in the edit template of a data column.
What i need to know as to what way the said requirement could be met.
Perhaps keep the grid in edit mode on page load which will expose the edit textboxes and then a button which will update all the records together. This is just an idea and i dont know whether it will work or not.
I need some good suggestions here.
I have another idea where i can alllow the user to edit in excel ie. put up an interface of excel to allow editing of the data shown in the sheet cells and then update the data tables on clicking of a button with values in the excel sheet cells. Is there a way to do the same?