DbDatabaseRunQuery Method (DbConnection, String, IDataParameter, Int32, String)

Runs a query, 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 void RunQuery(
	DbConnection connection,
	string query,
	IDataParameter[] parameters,
	out int rowsAffected,
	string provider
)

Protected Sub RunQuery ( 
	connection As DbConnection,
	query As String,
	parameters As IDataParameter(),
	<OutAttribute> ByRef rowsAffected As Integer,
	provider As String
)

Parameters

connection: Type: System.Data.CommonDbConnection
The database connection object for this command, if the connection is closed it will be opened
query: Type: SystemString
They query command text.
parameters: Type: System.DataIDataParameter
Array of IDataParameter objects containing parameters to the query
rowsAffected: Type: SystemInt32
Number of rows affected by the query.
provider: Type: SystemString
The database provider string

Reference

DbDatabase Class

RunQuery Overload

Cadcorp.DataAccess Namespace