hii all,
we have a requirement of uploading a excel file and once user click preview the entire data in the excel should visible in grid for user , and once clicked on submit then the data should store in database
for achieve this we are plane to use a staging table(dummy db) for storing uploaded excel data and showing in grid , once user click submit the data in staging table should move to main database table and need to delete the staging table data , why because if the staging table not cleared the next user data also store and entire data in the staging table will appear in grid
please help with this , guide me to achieve this.
thankyou,
Ramesh
Discussion posts and replies are publicly visible