AxpDataGrid

AxpDataGrid.EditNewPKStatement Property

Control if primary keys are autoincremented or require a separate SQL statement (eg for Oracle Sequences)

[Visual Basic]
Public Property EditNewPKStatement As String
[C#]
public string EditNewPKStatement {get; set;}

Property Value

Comma separated list of specifications, one entry for each primary key (if table has combined key).

Remarks

If the primary key column is an auto incremented field (an Identity column in Sql Server), set EditNewPKStatement="autoincrement".
Optionally set the FormFieldsHide property to hide the primary key column from the Form.

For Oracle using sequences, specify an SQL.
E.g. AxpDataGrid1.EditNewPKStatement = "SELECT SEQ_TEST.NextVal FROM DUAL"

See Also

AxpDataGrid Class | Axezz.WebControls Namespace