AxpDataGrid

AxpDataGrid.StoredProcCommand Property

If a stored procedure name is set in the SQL property, the stored procedure parameters can be set through this object afterwards.

[Visual Basic]
Public Property StoredProcCommand As OleDbCommand
[C#]
public System.Data.OleDb.OleDbCommand StoredProcCommand {get; set;}

Remarks

Example (MS SQL):
Replace spname with the name of the stored procedure, @paramname with the name of the actual parameter and paramvalue with an actual value. See also the Sample application for a Stored Procedure example.

AxpDataGrid1.SQL = "spname"
AxpDataGrid1.StoredProcCommand.Parameters.Add("@paramname", "paramvalue")

See Also

AxpDataGrid Class | Axezz.WebControls Namespace