判断Access里是否存在表

来源:互联网 发布:eclipes中新建java文件 编辑:程序博客网 时间:2024/04/28 16:53
  OleDbConnection conn = DbHelper.CreateConnection() as OleDbConnection;            conn.Open();            DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });            conn.Close();            bool isExistsTable = false;            foreach (DataRow row in schemaTable.Rows)            {                if (row[2].ToString().Equals(tableName))                {                    isExistsTable = true;                    break;                }            }

原创粉丝点击