System.Data Namespace DataColumn Class
Sets or retrieves the increment used by a column with its AutoIncrement property set to true.
| Script |
DataColumn.AutoIncrementStep = intValue |
| intValue |
The number by which the value of the column is automatically incremented. |
The property is read/write with a default value of 1.
The following example sets the AutoIncrement, AutoIncrementSeed, and AutoIncrementStep properties.
private void AddAutoIncrementColumn ( ) {
DataColumn myColumn = new DataColumn ( );
myColumn.DataType = System.Type.GetType ( "System.Int32" );
myColumn.AutoIncrement = true;
myColumn.AutoIncrementSeed = 1000;
myColumn.AutoIncrementStep = 10;
// add the column to a new DataTable.
DataTable myTable = new DataTable ( "MyTable" );
myTable.Columns.Add ( myColumn );
}
Private Sub AddAutoIncrementColumn ( )
Dim myColumn As DataColumn = New DataColumn
myColumn.DataType = System.Type.GetType ( "System.Int32" )
With MyColumn
.AutoIncrement = True
.AutoIncrementSeed = 1000
.AutoIncrementStep = 10
End With
' add the column to a new DataTable.
Dim myTable As New DataTable ( "MyTable" )
myTable.Columns.Add ( myColumn )
End Sub |
| |
C# |
VB |
DataColumn Members AutoIncrement AutoIncrementSeed Expression ItemArray
