1.通过指定连接属性参数打开数据库
/// <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); }
2.通过连接字符串打开数据库
/// <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); }
3.通过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); }
没有整理与归纳的知识,一文不值!高度概括与梳理的知识,才是自己真正的知识与技能。 永远不要让自己的*、好奇、充满创造力的想法被现实的框架所束缚,让创造力*成长吧! 多花时间,关心他(她)人,正如别人所关心你的。理想的腾飞与实现,没有别人的支持与帮助,是万万不能的。
本文转自wenglabs博客园博客,原文链接:http://www.cnblogs.com/arxive/p/6885266.html,如需转载请自行联系原作者