Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 573
  • Last Modified:

Read Excel sheet from SQL Data base and display it in Gridview

Hi EE,
i have a web application and i need to allow users to upload an Excel sheet and display the content in a gridview.

most of the solutions talks about reading the path of the file but this is not visible in our case since it is a web application hosted on production server.

moreover i cant upload them and save them temporary in a file and read them again for security reasons.

Thanks
0
Kamal Khaleefa
Asked:
Kamal Khaleefa
1 Solution
 
Surendra NathTechnology LeadCommented:
where is the file stored on users pc or sql db
0
 
Mark WillsTopic AdvisorCommented:
Ummmm... If a web app, and user is uploading, and display in a gridview, then what does that have to do with SQL Server ?

It is going to be difficult if you don't know the location (path) of the file...

Maybe you can explain in a little more detail ?
0
 
Kamal KhaleefaInformation Security SpecialistAuthor Commented:
yes im not able to save in a file because security issues

they need me to upload it and display it in gridview(the content)

we can save it in our SQL DB if needed or if there is a way while uploading to read the posted file and display it .....
thanks
0
 
Manoj PatilSr. Software EngineerCommented:
This May Help you to read excel file without uploading to server
stackoverflow.com/questions/12420310/read-an-excel-file-uploaded-using-fileupload-control-without-saving-it-on-the-se

To view excel file in GridView Check this
stackoverflow.com/questions/17808141/how-to-load-gridview-from-a-excel-file-in-asp-net-by-c
0
 
Kamal KhaleefaInformation Security SpecialistAuthor Commented:
i was not able to read it while uploading since we cant install 3rd party controls
i save the uploaded files into a shared network drive folder and read from there
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now