• 在C#中压缩access MDB文件 (转载)


    需要在工程中引用COM组件: Microsoft Jet and Replication Objects Library ,示例请参考下面的函数:

    public static bool CompactJetDatabase(string fileName)
            {
                // I use this function as part of an AJAX page, so rather than throwing
                // exceptions if errors are encountered, I simply return false and allow the page
                // to handle the failure generically.
                try
                {
                    if (fileName.Equals(""))
                        return false;

                    string oldFileName = fileName;

                    // 创建一个生成后的临时文件
                    string newFileName = Path.Combine(Path.GetDirectoryName(oldFileName), Guid.NewGuid().ToString("N") + ".mdb");

                    // 创建压缩类
                    JetEngineClass engine = new JetEngineClass();
                                // 压缩MDB为新的文件
                    engine.CompactDatabase(
                     String.Format(AccessOleDbConnectionStringFormat, oldFileName),
                     String.Format(AccessOleDbConnectionStringFormat, newFileName));

                    // 删除旧文件
                    File.Delete(oldFileName);

                    // 改名为旧文件名.
                    File.Move(newFileName, oldFileName);

                    return true;
                }
                catch (Exception ex)
                {

                    return false;
                }
            }


    原文出处:
    http://www.codeproject.com/useritems/CompactAndRepair.asp

  • 相关阅读:
    JavaScript中的String对象
    JavaScript中String对象处理HTML标记中文本的方法
    JavaScript中的Array对象
    JavaScript对象基础知识
    开机后显示显示‘无信号’
    JavsScript的基本特点
    ASP.NET中默认的一级目录
    MVC每层的职责
    PHP sql注入漏洞修复(数字型)
    python self的含义
  • 原文地址:https://www.cnblogs.com/margiex/p/683542.html
Copyright © 2020-2023  润新知