Import Excel Data to DataGridView using C# and VB.Net

Its Done With Other Code , Could You Help me for that Once Some of the records Are COmming to GridVIew Not All

//Here Is My Code //

 private void btnimport_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialogimportexcel = new OpenFileDialog();
            if (openFileDialogimportexcel.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                this.txtexcelfilename.Text = openFileDialogimportexcel.FileName;


                try
                {

                    System.Data.OleDb.OleDbConnection MyCnn;

                    System.Data.DataSet DSet;

                    System.Data.OleDb.OleDbDataAdapter MyCmd;

                    MyCnn = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtexcelfilename.Text + " ;Extended Properties=Excel 8.0;");

                    MyCmd = new System.Data.OleDb.OleDbDataAdapter
                    ("select * from [Sheet1$]", MyCnn);

                    MyCmd.TableMappings.Add("Table", "TestTable");

                    DSet = new System.Data.DataSet();

                    MyCmd.Fill(DSet);

                    dataGridView1.DataSource = DSet.Tables[0];

                    MyCnn.Close();

                }

                catch (Exception ex)
                {

                    MessageBox.Show(ex.ToString());

                }
            }
        }