How to show data from ms excel 2007 in datagridview in c# visual studio 2008

See more:

C#

how to show data from ms excel 2007 in datagridview in c# visual studio 2008

What I have tried:

System.Data.OleDb.OleDbConnection MyConnection;
System.Data.DataSet DtSet;
System.Data.OleDb.OleDbDataAdapter MyCommand;
MyConnection = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.ACE.OLEDB.12.0;Data Source='c:\Book1.xlsx';Extended Properties=Excel 12.0 Xml;");
MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Book1]", MyConnection);

MyCommand.TableMappings.Add("Table", "Net-informations.com");
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet);
dataGridView1.DataSource = DtSet.Tables[0];
MyConnection.Close();