获取Excel中表的集合信息(framework2.0、1.1、1.0)

private void gettablelist(string dty){
   OleDbConnection oleConn = new OleDbConnection();
   oleConn.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;data source="+dty+";Extended Properties=Excel 8.0;";
   oleConn.Open();
   DataTable dtOle = oleConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
    new object[] { null, null, null, "TABLE" }); 
   this.dg.DataSource=dtOle;
   this.dg.DataBind();
   dtOle = null;
   oleConn.Close();  

}

http://msdn2.microsoft.com/zh-cn/library/system.data.oledb.oledbconnection.getoledbschematable(VS.80).aspx