Dotnet-Project Framework documentation.

GenericDataHelper.ExecuteScalar Method (CommandType, String, IDataParameter[])

Execute a Command (that returns a 1x1 resultset) against the database using the provided parameters.

public static object ExecuteScalar(
   CommandType commandType,
   string commandText,
   params IDataParameter[] commandParameters
);

Parameters

commandType: The CommandType (stored procedure, text, etc.)
commandText: The stored procedure name or T-SQL command
commandParameters: An array of Parameters used to execute the command

Return Value

An object containing the value in the 1x1 resultset generated by the command

Example

int orderCount = (int)ExecuteScalar(CommandType.StoredProcedure, "GetOrderCount", new SqlParameter("@prodid", 24));

See Also

GenericDataHelper Class | DotnetProject.Data Namespace | GenericDataHelper.ExecuteScalar Overload List