取得所有表

 /// <summary>
        /// 取得所有表
        /// </summary>
        private ArrayList GetTables_ADONET()
        {
            ArrayList TabelNameList = new ArrayList();
            //处理OleDbConnection
            string strConnectionString = @"Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=CTI_Mast;Data Source=192.168.18.230,1544/sql2008";
            OleDbConnection cn = new OleDbConnection(strConnectionString);
            cn.Open();
            //利用OleDbConnection的GetOleDbSchemaTable来获得数据库的结构
            DataTable dt = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            foreach (DataRow dr in dt.Rows)
            {
                TabelNameList.Add(Row[0]);
            }

        }