Interface IRecordSet

Namespace
ESRI.ArcGIS.Geodatabase
Assembly
ESRI.Server.Geodatabase.dll

Provides access to the rows or features in a recordset.

[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
[Guid("4510A65B-ACD1-4046-B8B0-10F9D0DA673F")]
public interface IRecordSet

Remarks

The IRecordset interface exposes methods and properties to perform geodatabase recordset operations.  A recordset is a data structure that consists of a group of database records, and can either come from a base table or as the result of a query to the table.

 

 

Properties

Cursor[bool]

A cursor over the rows or features in the recordset.

ICursor Cursor[bool Recycling] { get; }

Parameters

Recycling bool

Property Value

ICursor

Remarks

When using a recordset class, the  Cursor property is used to return a cursor over the rows or feature in the RecordSet.

Fields

The fields of the recordset.

IFields Fields { get; }

Property Value

IFields

Remarks

<P>Each table in a database has an ordered collection of fields, there is always at least one field in a table. The ordered collection behaves like a list, so it is possible to access individual fields by a numbered position (or index) in the list.</P> <P>A <STRONG>Fields </STRONG>collection can also exist independently of a table, for example when creating an index on a table you will need to define which fields take part in the index. There are many interfaces which either require or return a <STRONG>Fields </STRONG>collection; these include <STRONG>IClass </STRONG>(therefore also <STRONG>IObjectClass </STRONG>and <STRONG>IFeatureClass</STRONG>), <STRONG>ICursor</STRONG>, <STRONG>IIndex</STRONG>, <STRONG>IFeatureClassDraw</STRONG>, <STRONG>IRowBuffer</STRONG>, <STRONG>ISimpleDataConverter</STRONG>, <STRONG>ITableSort </STRONG>and <STRONG>IValidate</STRONG>.</P>

IsFeatureCollection

Indicates if the recordset is a feature collection.

bool IsFeatureCollection { get; }

Property Value

bool

Remarks

When using a recordset class, the IsFeatureCollection property is used to return true and is read only if the RecordSet is a feature collection.

Table

The source table or feature class for the recordset.

ITable Table { get; }

Property Value

ITable

Remarks

<P>A <STRONG>Table </STRONG>object has one or more columns, referred to as fields, and contains an unordered collection of rows. Each row has for each field exactly one value in the data type of the field.</P> <P>A <STRONG>Table </STRONG>is a <STRONG>Dataset </STRONG>and properties such as the name of the table, the persistable name object for the table, and the workspace containing the table, may be obtained via the <STRONG>IDataset </STRONG>interface. In relational terms, a <STRONG>Table </STRONG>object represents an RDBMS table or view. In objected-oriented terms, a Table object represents an ObjectClass or a RelationshipClass in a geodatabase. A <STRONG>Table </STRONG>object hands out <STRONG>Row </STRONG>objects which themselves support application callable methods depending on the type of data stored in the table.</P> <P>The <STRONG>Name </STRONG>property of a <STRONG>Table</STRONG>, accessible via the <STRONG>IDataset </STRONG>interface, returns its fully qualified name. The level of qualification may vary depending on the host DBMS. For example, a table named ‘pipes’, owned by a user named ‘gas’ may be called ‘pipes’ in and Access or File Geodatabase, ‘gas.pipes’ on Oracle and ‘mydb.gas.pipes’ on SQLServer. The <STRONG>ParseTableNamemethod </STRONG>on the <STRONG>ISqlSyntax </STRONG>interface supported by the table’s workspace can be used to split the fully qualified name into its components.</P>