获取Access中的所有用户表(例子)

最新推荐文章于 2022-11-16 22:34:24 发布

T87406621

最新推荐文章于 2022-11-16 22:34:24 发布

阅读量207

点赞数

原文链接：http://www.cnblogs.com/Deckard/archive/2009/06/23/1508939.html

版权

//检索ACCESS库里的所有属于用户的表
        public DataView GetTable()
        {
            string sAccessConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\DataSourece\Ticket.mdb;" + "Persist Security Info=True";//连接字符串
            OleDbConnection conn = new OleDbConnection(sAccessConnection);//OLEDB连接
            conn.Open();
            DataTable tblSch = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            DataView view = tblSch.DefaultView;
            view.RowFilter = "table_type='table' or table_type='view'";
            return view;
        }

转载于:https://www.cnblogs.com/Deckard/archive/2009/06/23/1508939.html