CreateInsertCursor Method

In This Topic

Creates an InsertCursor instance in memory. This method must be called on the MCT. Use QueuedTask.Run.

Syntax

Visual Basic (Declaration)
C#

Public Function CreateInsertCursor() As InsertCursor

public InsertCursor CreateInsertCursor()

Return Value

A InsertCursor used to quickly insert rows.

Exceptions

Exception	Description
ArcGIS.Core.Data.Exceptions.GeodatabaseException	A geodatabase-related exception has occurred.

Remarks

When used in an ArcGIS Pro add-in, insert cursors should be used within an edit operation callback. For stand-alone CoreHost applications, calls to this method (and use of the insert cursor) should be enclosed within a call to Geodatabase.ApplyEdits.

Example

Using an Insert Cursor

{
  // Insert Cursors are intended for use in CoreHost applications, not Pro Add-ins
  await QueuedTask.Run(() =>
  {
    using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path\\to\\sde\\file"))))
    using (Table citiesTable = geodatabase.OpenDataset<Table>("name\\of\\cities_table"))
    {
      geodatabase.ApplyEdits(() =>
      {
        using (InsertCursor insertCursor = citiesTable.CreateInsertCursor())
        using (RowBuffer rowBuffer = citiesTable.CreateRowBuffer())
        {
          rowBuffer["State"] = "Colorado";

          rowBuffer["Name"] = "Fort Collins";
          rowBuffer["Population"] = 167830;
          insertCursor.Insert(rowBuffer);

          rowBuffer["Name"] = "Denver";
          rowBuffer["Population"] = 727211;
          insertCursor.Insert(rowBuffer);

          // Insert more rows here
          // A more realistic example would be reading source data from a file

          insertCursor.Flush();
        }
      });
    }
  });
}

Requirements

Target Platforms: Windows 11 Home, Pro, Enterprise (64 bit)

ArcGIS Pro version: 3.0 or higher.

Reference

Table Class
Table Members

Send feedback