using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using System.IO;
using System.Reflection;
using System.Data.OleDb;

 private void Bingdgv()
        {
            if (FilePath == "")
            {
                return;
            }
            try
            {
                OleDbConnection conn = new OleDbConnection(ExcelConnStr);
                string sql = "select * from [Sheet1$]";
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
                OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, conn);
                ds = new DataSet();
                myCommand.Fill(ds, "[Sheet1$]");
                conn.Close();

                dgvData.DataMember = "[Sheet1$]";
                dgvData.DataSource = ds;
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                throw ex;
            }
        }