AutoIncrementStep Property

DataColumn.AutoIncrementStep Property


Gets or sets the increment used by a column with its AutoIncrement property set to true.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public long AutoIncrementStep { get; set; }

Property Value

Type: System.Int64

The number by which the value of the column is automatically incremented. The default is 1.

Exception Condition

The value set is zero.

The following example sets the AutoIncrement, AutoIncrementSeed, and AutoIncrementStep properties.

private void AddAutoIncrementColumn()
    DataColumn column = new DataColumn();
    column.DataType = System.Type.GetType("System.Int32");
    column.AutoIncrement = true;
    column.AutoIncrementSeed = 1000;
    column.AutoIncrementStep = 10;

    // Add the column to a new DataTable.
    DataTable table = new DataTable("table");

.NET Framework
Available since 1.1
Return to top
© 2015 Microsoft