Stored Procedures or a .NET datasource can be used as the datasource for the Grid. Data editing, including display of the Editing Form requires a SQL command that specify editing against a database table.

Using a Stored Procedure

The name of the stored procedure must be set in the AxpDataGrid.SQL property. If the stored procedure takes parameters, these should be set via the AxpDataGrid.StoredProcCommand property.

Example

AxpDataGrid1.SQL="CustOrdersOrders"
AxpDataGrid1.StoredProcCommand.Parameters.Add("CustomerID", "ANTON")

Using .NET data sources

Any .NET datasource that can be evaluated to a DataView or DataTable can be used as a DataSource for the Grid.

Set the AxpDataGrid.DataSource property.

If the datasource is a DataSet, set the property AxpDataGrid.DataMember to a Table Name in the DataSet.

Remarks

See Also

AxpDataGrid Tutorial

---