Click here to Skip to main content
11,496,146 members (599 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: C# ASP.NET
Hello i am writing a Asp.net application with backend mysql5.0
i have a .xlsx file which i have to upload and read the data into mysql table.

Any one have any simalar code.

i had tried code-

string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                                                       "Data Source=" + Path + ";" +
                                                       "Extended Properties=\"Excel 12.0 Xml;HDR=YES\"";
            using (OleDbConnection cn = new OleDbConnection(ConnectionString))
            {
                cn.Open();
DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dbSchema == null || dbSchema.Rows.Count < 1)
}

but i throughs an exception like Could not find installable ISAM..
Any suggestion !!
Posted 21-Oct-12 21:47pm
Edited 21-Oct-12 22:24pm
v2
please download the files from
"http://www.microsoft.com/en-us/download/details.aspx?id=13255" and install it.
  Permalink  
try this,
if (hdnImageValues.Value != "")
           {
               string filePath = @"D:\Images\" + hdnImageValues.Value;
               string fileName = hdnImageValues.Value;
 
               if (File.Exists(filePath))
               {
 
                   FileStream fs = File.Open(filePath, FileMode.Open);
 
                   byte[] fsbyte = null;
 
                   fsbyte = new byte[fs.Length];
 
                   fs.Read(fsbyte, 0, Convert.ToInt32(fs.Length, null));
 
                   fs.Close();
             Response.AddHeader("contentdisposition","attachment;filename=" + fileName);
 
                   Response.BinaryWrite(fsbyte);
 
                   Response.End();
 
               }
 
           }
  Permalink  
v2
check this

first one[^]

2nd one[^]

may be this
will help you
@Chetan V@
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 RyanDev 230
1 Sergey Alexandrovich Kryukov 114
2 Richard Deeming 100
3 OriginalGriff 89
4 Mostafa Asaduzzaman 59
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 8 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100