《c#使用sqldmo操作数据库》由会员分享，可在线阅读，更多相关《c#使用sqldmo操作数据库（13页珍藏版）》请在金锄头文库上搜索。
1、SQL-DMO的全称是SQL Distributed Management Objects。它是一个集合，包含一组有双重接口的COM。通过SQL-DMO我们可以控制操作SQL Server 的数据库引擎和复制管理。由于SQL-DMO是一组COM，所以任何可以使用COM的开发工具都可以使用它，包括VB、Delphi、VC、BCB、ASP等等几乎包括所有的Windows平台下的开发工具。用他操作管理数据库很爽。using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.
2、IO;using SQLDMO;using System.Collections;namespace ConsoleApplication1 / / SQLDMO辅助类 / / / 使用前添加 Microsoft SQLDMO Object Library COM 引用。 / public class SqlDmoHelper #region DatabaseInfo / / 数据库信息 / public struct DatabaseInfo public string Name; public string Owner; public string PrimaryFilePath; pub
3、lic string CreateDate; public int Size; public float SpaceAvailable; public string PrimaryName; public string PrimaryFilename; public int PrimarySize; public int PrimaryMaxSize; public string LogName; public string LogFilename; public int LogSize; public int LogMaxSize; public override string ToStri
4、ng() string s = Name:0rn + Owner:1rn + PrimaryFilePath:2rn + CreateDate:3rn + Size:4MBrn + SpaceAvailable:5MBrn + PrimaryName:6rn + PrimaryFilename:7rn + PrimarySize:8MBrn + PrimaryMaxSize:9MBrn + LogName:10rn + LogFilename:11rn + LogSize:12MBrn + LogMaxSize:13MB; return string.Format(s, Name, Owner
5、, PrimaryFilePath, CreateDate, Size, SpaceAvailable, PrimaryName, PrimaryFilename, PrimarySize, PrimaryMaxSize, LogName, LogFilename, LogSize, LogMaxSize); #endregion保钓军团 private SQLServer2 sqlServer; private string server; private string login; private string password; public SqlDmoHelper(string se
6、rver, string login, string password) this.server = server; this.login = login; this.password = password; sqlServer = new SQLServer2Class(); sqlServer.Connect(server, login, password); public void Close() sqlServer.Close(); #region Property / / 获取主要版本号 / public string Version get return string.Format
7、(0.1, sqlServer.VersionMajor, sqlServer.VersionMinor); / / 获取详细版本信息 / public string VersionString get return sqlServer.VersionString; / / 获取服务器时间 / public string ServerTime get return sqlServer.ServerTime; / / 获取系统服务名称 / public string ServiceName get return sqlServer.ServiceName; / / 获取或设置系统服务是否自动启动
8、 / public bool AutostartServer get return sqlServer.Registry.AutostartServer; set sqlServer.Registry.AutostartServer = value; / / 获取字符集设置 / public string CharacterSet get return sqlServer.Registry.CharacterSet; / / 获取服务器物理内存大小(MB) / public int PhysicalMemory get return sqlServer.Registry.PhysicalMemory; / / 获取服务器处理器(CPU)数量 / public int NumberOfProcessors get return sqlServer.Registry.NumberOfProcessors; #endregion #region Public Method / / 获取网络内所有可用的服务器 / /
