• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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