DataColumn.AutoIncrementSeed Property

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataColumn.cs

Gets or sets the starting value for a column that has its AutoIncrement property set to true. The default is 0.

public:
 property long AutoIncrementSeed { long get(); void set(long value); };

public long AutoIncrementSeed { get; set; }

member this.AutoIncrementSeed : int64 with get, set

Public Property AutoIncrementSeed As Long

Property Value

Int64

The starting value for the AutoIncrement feature.

Examples

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);
}

Private Sub AddAutoIncrementColumn()
    Dim column As New DataColumn()
    column.DataType = System.Type.GetType("System.Int32")
    With column
        .AutoIncrement = True
        .AutoIncrementSeed = 1000
        .AutoIncrementStep = 10
    End With

    ' Add the column to a new DataTable.
    Dim table As DataTable
    table = New DataTable
    table.Columns.Add(column)
End Sub

See also

• AutoIncrement
• AutoIncrementStep
• Expression
• ItemArray
• Using DataSets in ADO.NET