DataColumn.AutoIncrementStep Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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
ArgumentException

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");
    table.Columns.Add(column);
}

.NET Framework
Available since 1.1
Return to top
Show: