Gets or sets the increment used by a column with its AutoIncrement property set to true.
[Visual Basic] Public Property AutoIncrementStep As Integer [C#] public int AutoIncrementStep {get; set;} [C++] public: __property int get_AutoIncrementStep(); public: __property void set_AutoIncrementStep(int); [JScript] public function get AutoIncrementStep() : int; public function set AutoIncrementStep(int);
The number by which the value of the column is automatically incremented. The default is 1.
Exception Type | Condition |
---|---|
ArgumentException | The value set is zero. |
The following example checks the AutoIncrementSupported property before setting the AutoIncrement, AutoIncrementSeed, and AutoIncrementStep properties.
[Visual Basic]
Private Sub AddAutoIncrementColumn() Dim myColumn As DataColumn = New DataColumn myColumn.DataType = System.Type.GetType("System.Int32") If myColumn.AutoIncrementSupported Then With MyColumn .AutoIncrement = True .AutoIncrementSeed = 1000 .AutoIncrementStep = 10 End With End If ' Add the column to a new DataTable Dim myTable As DataTable myTable = New DataTable myTable.Columns.Add(myColumn) End Sub
DataColumn Class | DataColumn Members | System.Data Namespace | AutoIncrement | AutoIncrementSeed | AutoIncrementSupported | Expression | ItemArray