error in reading data from excel

harisbscs2003 · March 3rd, 2009, 06:46 AM

Exception: Failure creating File

Code:

private void button1_Click(object sender, EventArgs e)
        {
            DataTable test = getDataFromXLS("c:\temp.xls");
            if (test != null)
                dataGridView1.DataSource = test;
        }
        private DataTable getDataFromXLS(string strFilePath)
        {
            try
            {
                string strConnectionString = "";  //Data Source=HARIS\SQLEXPRESS;Initial Catalog=MFSAS;User ID=akram
                strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFilePath + "; Jet OLEDB:Engine Type=5;" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConnectionString);
conn.Open();
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * FROM [Sheet1$]";    //first sheet of c:/temp                OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
                DataTable dt = new DataTable();
                da.Fill(dt);
                conn.Close();
                da = null;
                return dt;
            }

            catch (Exception ex)
            {
                return null;
            }
            finally { }
        }

joefawcett · March 3rd, 2009, 06:52 AM

Your post's title says you have an error creating file, but is it one reading the file?
I suggest two things. Firstly let the error message show instead of trapping and discarding it. Secondly change the part where you specifiy the path so that \ is not an escape character:

Code:

DataTable test = getDataFromXLS(@"c:\temp.xls");

If that fails then post the exact error message, might be that your asp.net account does not have permissions on that file for example.

harisbscs2003 · March 3rd, 2009, 07:11 AM

Framework: 2.0
Lang: C#

Which control shd i use if i want end user Locate the stated file i.e "C:\temp" from its exact location.

joefawcett · March 3rd, 2009, 07:14 AM

I don't think there's a built-in one to browse the web server's file system from a remote client. You could write your own but it's a strange request. More normal would be offer a choice of files from a drop down list or similar.

harisbscs2003 · March 3rd, 2009, 07:33 AM

can I use <OpenFileDialog> control to give the path of the file from which end user fetch data into grid.

joefawcett · March 3rd, 2009, 09:46 AM

Seems to be some misunderstanding, probably on my part. If this is a Win Forms app then yes you can, for some reason I thought you were talking about a web app in which case you can't.