Hi all,

Have a stupid question about datasources and I'm pretty sure the answer is clear...but want to double check. I am currently reading an Excel sheet into a GridView and want users to be able to update the fields, then insert the modified data into an Oracle database.

Uploading the Excel file is not a problem...but when I click edit, make a change, then click update, the value is still the same. I believe this has to do with the fact that the connection to the Excel sheet is disconnected. Is it possible to edit the information in session state memory and from session state insert it into the database? Or do I need to hit the Excel sheet everytime an update is processed, update that Excel file, read the sheet into the Gridview again, and allow the user to insert at that point?

It's basically allowing the user to massively update the database via an Excel sheet that they created locally since multiple departments all use different Excel sheets for the same data. I would just rather not have to keep going back to the Excel file, if at all possible.

Thanks in advance!