The SQL Select statement to use as a datasource for the Form Edit mode.

Property Value

The SQL Select statement to use as a datasource for the Form Edit mode.

Remarks

Default is the same as FormSql (or just the normal SQL) but can be set here if the other SQL statements does not contain updateable queries or if the select statement is not suitable.
Note that AxpDataGrid removes the WHERE clause spefied in the SQL when editing and replaces it with a query containg the primary keys for the table.

It is strongly recommended to set the EditSQL to a simple "SELECT * FROM tablename"

All database updates are based on primary keys.
You will need to set some properties to enable data editing. Please see the Sample application for full details.


Example taken from Sample3:

ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\axpdb\NWind.mdb" 
SQL="Select * From Products"
DeleteSQL="Delete From Products"
DisplayNavBar="both"
EditOptions="ALL"
EditPrimaryKeys="ProductId"
EditFieldsReadOnly="1"
EditNewPKStatement="autoincrement"

See Also

AxpDataGrid Class | Axezz.WebControls Namespace

---