获得库中所有表名

小东东^_^
private void button4_Click(object sender, System.EventArgs e)
  {
////   get access database all tables
//   string strtemp="";
//   string strcon="Provider=Microsoft.JET.OLEDB.4.0;data source=uni.mdb";
//   OleDbConnection conn=new OleDbConnection(strcon);
//   conn.Open();
//   DataTable ts= conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
//    new object[] {null, null, null, "TABLE"});
//   conn.Close();
// 
//   foreach(DataRow dr in ts.Rows)
//   {
//    strtemp= strtemp + dr[2] + "\n" ;
//   }          
//   MessageBox.Show(strtemp);
//   
//   strtemp="";
//   foreach(DataRow dr in ts.Rows)
//   {
//    for(int i=0;i<ts.Columns.Count;i++)
//    {
//     strtemp= strtemp + ts.Columns[i].ColumnName + "=" + dr[i] + "\n" ;
//    }
//    strtemp=strtemp+"\n";
//   }          
//   MessageBox.Show(strtemp);

//   get access sql all tables
   string strtemp="";
   string strcon = "Provider=SQLOLEDB;server=racine;uid=sa;pwd=sa;database=HB";
   OleDbConnection conn=new OleDbConnection(strcon);
   conn.Open();
   DataTable ts= conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
    new object[] {null, null, null, "TABLE"});
   conn.Close();
 
   foreach(DataRow dr in ts.Rows)
   {
    strtemp= strtemp + dr[2] + "        " ;
   }          
   MessageBox.Show(strtemp);
   
   strtemp="";
   foreach(DataRow dr in ts.Rows)
   {
    for(int i=0;i<ts.Columns.Count;i++)
    {
     strtemp= strtemp + ts.Columns[i].ColumnName + "=" + dr[i] + "\n" ;
    }
    strtemp=strtemp+"\n";
   }          
   MessageBox.Show(strtemp);
  }