Click here to Skip to main content
12,696,403 members (30,465 online)
Rate this:
 
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 21:47pm
Updated 21-Oct-12 22:24pm
v2
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  
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  

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



Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 8 Nov 2012
Copyright © CodeProject, 1999-2017
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