upload and display excel file

Hello guys,

i have a file upload control which is used to upload excel files. i want to display the content of excel file in grid view. i dont want to save the file on disk and then read the content form the disk to display in gridview. i want some mechanism to keep the excel file in the memory and display its contents in gridview with out saving it on disk.
psdeepu545Asked:
Who is Participating?
 
Dhanasekaran SengodanCommented:
try this code,

OleDbConnection DBConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/App_Data/PacerResults.xls") + ";" + "Extended Properties=\"Excel 8.0;HDR=Yes\"");
     DBConnection.Open();
   
     string SQLString = "SELECT * FROM [PacerResults$]";
    OleDbCommand DBCommand = new OleDbCommand(SQLString, DBConnection);
    Data.IDataReader DBReader = DBCommand.ExecuteReader();
   
    gv.DataSource = DBReader;
     gv.DataBind();
   
     DBReader.Close();
       
    DBConnection.Close();
0
 
Rajkumar GsSoftware EngineerCommented:
Hope this link will help
http://www.ezzylearning.com/tutorial.aspx?tid=1553779

After upload excel file, to display excel data in gridview, modify the connecting string with the upload folder/file name.

Have a try
Raj
0
 
psdeepu545Author Commented:
Its the only way to do it
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.

All Courses

From novice to tech pro — start learning today.