[Visual Basic 6.0]
'Example of how to use a property set to open an SDE workspace. 

Dim pPropset As IPropertySet 
Set pPropset = New PropertySet 
With pPropset 
.SetProperty "Server", m_SDEServerName 
.SetProperty "Instance", m_SDEServerInst 
.SetProperty "user", m_SDEServerUserName 
.SetProperty "password", m_SDEServerPass 
.SetProperty "Database", m_SDEDatabaseName
.SetProperty "version" , m_SDEVersionName 
End With 

Dim pFactSDE As IWorkspaceFactory 
Set pFactSDE = New SdeWorkspaceFactory 

Dim pWorkSpaceSDE As IWorkspace 
Set pWorkSpaceSDE = pFactSDE.Open(pPropset, Me.hWnd) 

'Example of how to use a property set to open a Personal Geodatabase workspace. 

Dim pPropset As IPropertySet 
Set pPropset = New PropertySet 

pPropset.SetProperty "DATABASE", "d:\\data\\Access Data\\First.mdb" 

Dim pFactAccess As IWorkspaceFactory 
Set pFactAccess = New AccessWorkspaceFactory 

Dim pWorkSpaceAccess As IWorkspace 
Set pWorkSpaceAccess = pFactAccess.Open(pPropset, Me.hWnd) 

[C#]
//Personal Geodatabase e.g., database = "C:\\myData\\mypGDB.mdb"
public IWorkspace open_pGDB_Workspace(string database)
{
ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS.esriSystem.PropertySetClass();
propertySet.SetProperty("DATABASE", database);
IWorkspaceFactory workspaceFactory = new ESRI.ArcGIS.DataSourcesGDB.AccessWorkspaceFactoryClass();
return workspaceFactory.Open(propertySet, 0);
}
// File Geodatabase e.g., database = "C:\\myData\\myfGDB.gdb"
public IWorkspace open_fGDB_Workspace(string database)
{
ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS.esriSystem.PropertySetClass();
propertySet.SetProperty("DATABASE", database);
IWorkspaceFactory workspaceFactory = new ESRI.ArcGIS.DataSourcesGDB.FileGDBWorkspaceFactoryClass();
return workspaceFactory.Open(propertySet, 0);
}
//SDE Geodatabase e.g., server = "Kona"
// database = "sde" or "" if Oracle
// instance = "5151"
// user = "vtest"
// password = "go"
// version = "SDE.DEFAULT"
public IWorkspace open_ArcSDE_Workspace(string server, string instance, string user,
string password, string database, string version)
{
ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS.esriSystem.PropertySetClass();
propertySet.SetProperty("SERVER", server);
propertySet.SetProperty("INSTANCE", instance);
propertySet.SetProperty("DATABASE", database);
propertySet.SetProperty("USER", user);
propertySet.SetProperty("PASSWORD", password);
propertySet.SetProperty("VERSION", version);

IWorkspaceFactory workspaceFactory = new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();
return workspaceFactory.Open(propertySet, 0); 
}

[Visual Basic .NET, C++]
No example is available for Visual Basic .NET or C++. To view a Visual Basic 6.0 or C# example, click the Language Filter button in the upper-left corner of the page.