Open a table from a file geodatabase

jeromegarnon1 — Mon, 30 Mar 2020 15:32:56 GMT

Hello,

I (Jerome, first post on this forum I believe) am currently building an ArcObjects SDK tool with visual studio for ArcGIS desktop 10.5.1, and I am struggling with a simple (at least it sounds simple) task: open a table from a geodatabase to have access to the data it contains... I get the geodatabase from a reference featureclass (flLocation).

I've tried:

'##################################

Public Function GetTable(ByVal sTableName As String) As ITable

Dim pWorkspaceFactory As IWorkspaceFactory = New ESRI.ArcGIS.DataSourcesGDB.FileGDBWorkspaceFactory
Dim pDataset As IDataset = CType(flLocation, IDataset)
Dim pWksp As IWorkspace = pDataset.Workspace
Dim sGdbPath As String = pWksp.PathName
Dim pWorkSpace As IWorkspace = pWorkspaceFactory.OpenFromFile(sGdbPath, 0)

Dim pEnumDataset As IEnumDataset = pWorkSpace.Datasets(esriDatasetType.esriDTTable)

pEnumDataset.Reset()

Dim pTable As ITable
pTable = pEnumDataset.Next

Dim pFTable As ITable
Do While Not pTable Is Nothing
   If TypeOf pTable Is ITable Then
      If pTable.Name = sTableName Then
         pFTable = TryCast(pTable, ITable)
         Exit Do
      End If
   End If
   pTable = pEnumDataset.Next
Loop

Return pFTable

End Function

'##################################

I keep having an error at "If pTable.Name = sTableName" with the traditional message "Exception thrown: 'System.NullReferenceException' in Microsoft.VisualBasic.dll, Additional information: Object reference not set to an instance of an object." but I cannot make it work adding a "new" statement or "Not (IsDBNull(pTable))" for example...

Any help would be much appreciated,

Thank you

Jerome

Re: Open a table from a file geodatabase

jeromegarnon1 — Tue, 31 Mar 2020 13:44:44 GMT

It seems to be a question of pTable being a COM object rather than a table but I cannot find the way to tackle this anywhere...

Re: Open a table from a file geodatabase

jeromegarnon1 — Tue, 31 Mar 2020 15:15:49 GMT

I found out! "OpenTable" works better with IFeatureWorkspace...

topic Open a table from a file geodatabase in ArcObjects SDK Questions

Open a table from a file geodatabase

Re: Open a table from a file geodatabase

Re: Open a table from a file geodatabase