[mira-magdy]

  OpenFileDialog of = new OpenFileDialog();
            of.Filter = "All files (*.*)|*.*|All files (*.*)|*.*";
            if (of.ShowDialog() == DialogResult.OK)
            {
                objstream = new StreamReader(of.FileName);

                OleDbConnection ExcelConection = null;
                OleDbDataAdapter ExcelCommand = null;



                try
                {
                    //OleStringBuilder =new OleDbConnectionStringBuilder(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';");
                    string conn = @"Provider=Microsoft.jet.OLEDB.4.0;" +
                    @"Data Source=" + of.FileName + ";" +
                    @"Extended Properties=" + Convert.ToChar(34).ToString() + ";" +
                    @"Excel 12.0;HDR=Yes;IMEX=1" + Convert.ToChar(34).ToString();

                    ExcelConection = new OleDbConnection(conn);

                    ExcelCommand = new OleDbDataAdapter("Select * From [Sheet1$]", ExcelConection);
                    ExcelCommand.TableMappings.Add("table", "testtable");
                    DataSet ds = new DataSet();
                    ExcelCommand.Fill(ds);
                    dataGridView1.DataSource = ds.Tables[0];
                    ExcelConection.Close();



                    //Grid.DataBind();
                    ExcelConection.Close();
                }
                catch (Exception etc)
                {
                    MessageBox.Show("error" + etc.Message);
                }
                
            }
        }
    }

i had a problem to show the excel in a datagrid when it reach to step to fill the data in the grid it jump to catch and didn't show the data in the table to the grid .

This post has been edited by mira-magdy: 28 August 2011 - 01:18 AM

[rgfirefly24]

what is the error you are getting?

[mira-magdy]

system.data.oledb.oledbexception 0x80004005

[JackOfAllTrades]

Did you try searching Google for your error?

[mira-magdy]

JackOfAllTrades, on 29 August 2011 - 05:08 AM, said:

Did you try searching Google for your error?

of course i tried many times and try several solutions but i get nothing

[fixo]

How about this:

       private void readToDgv()
        {
            StreamReader objstream;
OpenFileDialog of = new OpenFileDialog();
          of.Filter = "Excel files (*.xls*)|*.xls*|All files (*.*)|*.*";
of.FilterIndex=1;
          if (of.ShowDialog() == DialogResult.OK)
          {
              objstream = new StreamReader(of.FileName);

              OleDbConnection ExcelConection = null;
              OleDbDataAdapter ExcelCommand = null;

              try
              {
                  string conn = "Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source=" + of.FileName + ";" + "Extended Properties=\"Excel 12.0;HDR=YES\";";
                  ExcelConection = new OleDbConnection(conn);
                  ExcelCommand = new OleDbDataAdapter("Select * From [Sheet1$]", conn);
                  DataTable dt= new DataTable("testtable");
                  ExcelCommand.TableMappings.Add("Table", "testtable");//<-- table name is case-sensitive
                  DataSet ds = new DataSet();
                  ExcelCommand.Fill(ds,"testtable");
                  dataGridView1.DataSource = ds.Tables["testtable"];
                  ExcelConection.Close();

                  ExcelConection.Close();
              }
              catch (Exception etc)
              {
                  MessageBox.Show("error" + etc.Message + "\n" + etc.StackTrace);
              }
              
          }
      }