FlexCelReport.AddSqlParameter Method
Adds an SQL parameter to use from the template on the DIRECT SQL commands. Note that the parameter must have a name even if you are using positional parameters ("?") because on the template you should always write named parameters.
Syntax
Namespace: FlexCel.Report
public void AddSqlParameter(String parameterName, IDbDataParameter parameter)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
parameterName | String | The name of the parameter without special symbols, as it is written on the DIRECT SQL string. This might be different from the real parameter name. For example, on SQL Server, parameterName might be "MyParameter" while parameter.ParameterName would be "@MyParameter" |
|
parameter | IDbDataParameter | The parameter to add. |