ArcObjects Library Reference (GeoDatabase)  

IRow Interface

Provides access to members that return information about the row, the table the row belongs to and storing and deleting the row.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Description

An instance of the Row object represents a persistent row in a Table. A row object is normally obtained from a cursor on a table (for example, ICursor::NextRow) or fetched directly using its Object ID (for example, ITable::GetRow).

Once retrieved, clients may query the row object for additional interfaces and invoke methods on the row object. The CLSID property of a Table determines the type of row object returned by the Table.

A new persistent row object is created using the ITable::CreateRow method.  The act of creating a row assigns it identity.

A row has a set of fields. The set of fields for a row is the same as the set of fields for its table. In particular, the numeric index of a field in a table's fields collection is the same as the numeric index of the field in the row's fields collection. This means that application programs can and should cache field numeric indexes using the FindField method on table, rather than invoking the FindField method for each row returned by a Cursor.

Members

Description
Method Delete Deletes the row.
Read-only property Fields The fields Collection for this row buffer.
Read-only property HasOID Indicates if the row has an OID.
Read-only property OID The OID for the row.
Method Store Stores the row.
Read-only property Table The Table for the row.
Read/write property Value The value of the field with the specified index.

Inherited Interfaces

Interfaces Description
IRowBuffer Provides access to members used for getting and modifying a rows values and for getting the fields in the row.

CoClasses that implement IRow

CoClasses and Classes Description
AnnotationFeature (esriCarto) An Esri annotation feature.
AttributedRelationship Esri Attributed Relationship object.
ComplexEdgeFeature Esri Complex edge geometric network feature object.
ComplexJunctionFeature Esri Complex junction geometric network feature.
CoverageAnnotationFeature Esri Coverage Annotation Feature.
DimensionFeature (esriCarto) Esri Dimension Feature class.
Feature Esri Feature.
GeocodedFeature (esriLocation) A feature created by a locator.
NALocationFeature (esriNetworkAnalyst) A network location which can be used like a feature or a row.
NALocationObject (esriNetworkAnalyst) A network location which can be used like a row.
NALocationRangesFeature (esriNetworkAnalyst) A container of NALocationRanges which can be used like a feature or a row.
NALocationRangesObject (esriNetworkAnalyst) A container of NALocationRanges which can be used like a row.
Object Esri Object object.
RelQueryRow A row defined by a join of the datasets in a RelQueryTable.
Row Esri Row object.
SchematicDiagram (esriSchematic) A schematic diagram object.
SchematicInMemoryFeatureLink (esriSchematic) Schematic in memory feature link object.
SchematicInMemoryFeatureNode (esriSchematic) Schematic in memory feature node object.
SchematicInMemoryFeatureNodeOnLink (esriSchematic) Schematic in memory feature node on link object.
SchematicInMemoryFeatureSubLink (esriSchematic) Schematic in memory feature sublink object.
SchematicLink (esriSchematic) A schematic link object.
SchematicNode (esriSchematic) A schematic node object.
SchematicNodeOnLink (esriSchematic) A schematic node-on-link object.
SchematicSubLink (esriSchematic) A schematic sublink object.
SimpleEdgeFeature Esri Geometric network simple edge feature object.
SimpleJunctionFeature Esri Geometric network simple junction feature object.
TemporalFeature (esriTrackingAnalyst) Controls properties of the Temporal Feature object.
TopologyErrorFeature Esri Topology Error Feature object.

Remarks

The IRow interface inherits from the IRowBuffer interface and includes properties and methods to get and set the row's values, detect whether the row has an Object ID (and retrieve it, if it does has one), get the row's table, delete the row, and persist any changes made to the row.

The OID property returns the unique object identifier for the Row that distinguishes it from other rows in the table. If the HasOID property returns false, then this row was returned from a table lacking a geodatabase-managed Object ID field.  This generally occurs when the table is not registered with the geodatabase; see the IClassSchemaEdit::RegisterAsObjectClass method for more information.

The Store method is called by an application once it has modified the values of a Row. Calling the Store method triggers the following actions.

  1. The IRowEvents::OnChanged method is called for the Row being stored (the OnNew method is called if this is a newly created row being stored for the first time). A custom row object can implement the RowEvents::OnChanged method and take some special action when it is called—for example, update a special column in the row.
  2. The IRelatedObjectEvents::RelatedObjectChanged method is called for related objects in related object class if the table for this row is an object class that participates in relationship classes with notification.

Once Store is called on a Row object, all subsequent queries against the table within the same edit session using the geodatabase API will reflect the modified state of the row object.

The Delete method is called by an application to delete a row object from the database. Calling the Delete method triggers the following actions.

  1. The IRowEvents::OnDelete method is called for the Row being deleted. A custom row object can implement the IRowEvents::OnDelete method and take some special action when it is called.
  2. All relationships in which the row object participates are automatically deleted.

Once Delete is called on a Row object, all subsequent queries against the Table within the same edit session using the geodatabase API will reflect the deleted state of the row object.

The changes made to a row object using the Store and Delete methods will be committed to persistent store if the containing edit session is saved and no conflicts are detected. If the changes were made outside of an edit session, then the application program is responsible for directly managing underlying database transactions using the ITransactions interface on the Workspace.

[C#]

This example shows the creation of a row, then an update, followed by it being deleted.

    //e.g., nameOfField = "FruitName";
    public void IRow__(ITable table, string nameOfField)
    {
        int fieldIndex = table.FindField(nameOfField);
        //insert row
        IRow row = table.CreateRow();
        //initalize all of the default field values for the new row.
        IRowSubtypes rowSubTypes = (IRowSubtypes)row;
        rowSubTypes.InitDefaultValues();
        row.set_Value(fieldIndex, "Banana");
        row.Store();
        //update row
        row.set_Value(fieldIndex, "Ripe Banana");
        row.Store();
        //delete row
        row.Delete();
    }

See Also

ITable Interface | IRowBuffer Interface

.NET Snippets

Write Blob Field Contents To File | Write Blob File Contents To Table Row Field

.NET Samples

Export any network analysis class to a text file (Code Files: NAClassToTextfileCmd) | Closest facility solver (Code Files: frmClosestFacilitySolver) | ArcGIS Network Analyst extension Engine application (Code Files: frmMain) | Service area solver (Code Files: frmServiceAreaSolver) | Customizing schematic feature removal events (Code Files: FeatureRemovalMgmt) | Location-allocation solver (Code Files: frmLocationAllocationSolver) | Tabbed feature inspector (Code Files: TabbedInspector) | Selection restriction evaluator (Code Files: SelectionRestrictionEvaluator) | Vehicle routing problem solver (Code Files: frmVRPSolver) | Origin-destination cost matrix solver (Code Files: frmODCostMatrixSolver) | Bind a geodatabase table to a .NET control (Code Files: FieldPropertyDescriptor TableWrapper) | Subset network evaluators (Code Files: FilterSubsetEvaluator ScaleSubsetEvaluator) | Create a custom raster function (Code Files: WatermarkFunction) | Reducing schematic nodes and computing a cumulative attribute via a schematic rule (Code Files: NodeReductionRule) | Tabbed feature inspector (Code Files: ObjectInspector)

.NET Related Topics

Updating features | Creating class extensions | Editing with the geodatabase API | Finding differences between versions | GeoData services | Geodatabase | How to create a raster unique value renderer | How to create graph series with different color types | Joining data | Location | Obtaining changes made in the current edit session | Querying geodatabase tables | Sorting tables