• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • 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.

Kamal Khaleefa
Kamal Khaleefa
1 Solution
Surendra NathTechnology LeadCommented:
where is the file stored on users pc or sql db
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 ?
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 .....
Manoj PatilSr. Software EngineerCommented:
This May Help you to read excel file without uploading to server

To view excel file in GridView Check this
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
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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