读取 Excel 到Dataset中

string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source + ";Extended Properties=Excel 8.0";
            string query = "Select * From [Sheet1$]";

            OleDbConnection conn = new OleDbConnection(ConnStr);
            OleDbDataAdapter ad = new OleDbDataAdapter(query,conn);
            DataSet ds = new DataSet();
            ad.Fill(ds,"Book1");
            DataGrid1.DataSource = ds.Tables["Book1"].DefaultView;
            DataGrid1.DataBind();
            ad.Dispose();
            conn.Close();
            conn=null;