Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 20:47pm
Edited 21-Oct-12 21:24pm
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

check this
 
first one[^]
 
2nd one[^]
 
may be this
will help you
@Chetan V@
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

please download the files from
"http://www.microsoft.com/en-us/download/details.aspx?id=13255" and install it.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 370
1 Sergey Alexandrovich Kryukov 195
2 Prakriti Goyal 177
3 jlopez788 134
4 _Amy 110
0 OriginalGriff 6,762
1 Sergey Alexandrovich Kryukov 5,539
2 Maciej Los 3,479
3 Peter Leow 3,323
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 8 Nov 2012
Copyright © CodeProject, 1999-2014
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