DbDatabaseRunProcedure Method (String, String, IDataParameter, Int32, String)

Runs a stored procedure, returning an integer indicating the return value of the stored procedure. Also returns the value of the RowsAffected aspect of the stored procedure that is returned by the ExecuteNonQuery method.

Namespace: Cadcorp.DataAccess
Assembly: Cadcorp.GFB.DataAccess (in Cadcorp.GFB.DataAccess.dll) Version: 9.0.2618.0 (9.0.2618.0)

Syntax

ASP.NET

Copy

protected int RunProcedure(
	string connectionString,
	string storedProcName,
	IDataParameter[] parameters,
	out int rowsAffected,
	string provider
)

Protected Function RunProcedure ( 
	connectionString As String,
	storedProcName As String,
	parameters As IDataParameter(),
	<OutAttribute> ByRef rowsAffected As Integer,
	provider As String
) As Integer

Parameters

connectionString: Type: SystemString
String defining the database connection
storedProcName: Type: SystemString
Name of the stored procedure
parameters: Type: System.DataIDataParameter
Array of IDataParameter objects containing parameters to the stored procedure
rowsAffected: Type: SystemInt32
Number of rows affected by the stored procedure.
provider: Type: SystemString
[Missing <param name="provider"/> documentation for "M:Cadcorp.DataAccess.DbDatabase.RunProcedure(System.String,System.String,System.Data.IDataParameter[],System.Int32@,System.String)"]

Return Value

Type: Int32
Return value of the stored procedure

Reference

DbDatabase Class

RunProcedure Overload

Cadcorp.DataAccess Namespace