ArcGIS Engine 打开SDE数据库的几种方式

最新推荐文章于 2021-09-02 16:23:32 发布

a1050122092

最新推荐文章于 2021-09-02 16:23:32 发布

阅读量498

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/King2019Blog/p/11288153.html

版权

本文介绍了三种连接SDE数据库的方法：通过属性参数、连接字符串及sde文件进行数据库连接。详细展示了如何使用IWorkspaceFactory接口实现数据库的打开操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

通过指定连接属性参数打开数据库

 /// <param name="server">数据库服务器名</param>  
 /// <param name="instance">SDE的端口，默认安装时"port:5151"</param>  
 /// <param name="user">SDE的用户名</param>  
 /// <param name="password">密码</param>  
 /// <param name="database">数据库的名字</param>  
 /// <param name="version">SDE的版本</param>  
 /// <returns></returns>  
 public IWorkspace OpenSdeWorkspaceByPropertySet(string server, string instance, string user, string password, string database, string version)  
 {  
     IPropertySet Propset = new PropertySetClass();  
     Propset.SetProperty("SERVER", server);  
     Propset.SetProperty("INSTANCE", instance);  
     Propset.SetProperty("USER", user);  
     Propset.SetProperty("PASSWORD", password);  
     Propset.SetProperty("DATABASE", password);  
     Propset.SetProperty("VERSION", version);  

    IWorkspaceFactory workspaceFactory = new SdeWorkspaceFactoryClass();  
    return workspaceFactory.Open(Propset, 0);  
}

通过连接字符串打开数据库

/// <param name="connectionString">连接字符串</param>  
/// For example, "SERVER=Kona;DATABASE=sde;INSTANCE=5151;USER=Editor;PASSWORD=Editor;VERSION=sde.DEFAULT"  
/// <returns></returns>  
public IWorkspace OpenSdeWorkspaceByConnectionString(string connectionString)  
{  
    IWorkspaceFactory2 workspaceFactory = new SdeWorkspaceFactoryClass();  
    return workspaceFactory.OpenFromString(connectionString, 0);  
}

通过sde文件打开数据库

/// <param name="connectionFile">sde文件</param>  
/// For example, "C:\\Data.sde"  
/// <returns></returns>  
public IWorkspace OpenSdeWorkspaceFromFile(string connectionFile)  
{  
    IWorkspaceFactory workspaceFactory = new SdeWorkspaceFactoryClass();  
    return workspaceFactory.OpenFromFile(connectionFile, 0);  
}

转载于:https://www.cnblogs.com/King2019Blog/p/11288153.html