How to write this sql command?

[Maria]

Hello,I'm trying to write a sql command like this:

Code: Select all

select * from employee where name Like '% @name %'

That @name is a parameter.
But I don't know How to write this in stimule soft report.
please help me to write that statement.

Thank you.

[Edward]

Hi Maria,

Please write the following expression in the SQL Editor window:

select * from employee where name Like @name

And define a parameter:

@name

The parameter value must be as follows:

@name = "%myparametervalue%"

Thank you.

[Maria]

Hello Edward,
I did the following:
I’m write the expression such as expression you wrote and then I’m define a parameter named: % @name %
Then I do the following in my code:
report.DataSources["Employee"].Parameters["% name %"].ParameterValue = "%" + txtName.Text.ToString() + "%";

but I get the following Error.

Incorrect syntax near '%'.
Must declare the scalar variable "@name".
Statement(s) could not be prepared.

In Line:
Line 22: report.DataSources["Employee"].Parameters["% @name %"].ParameterValue = "%" + txtName.Text.ToString() + "%";
Line 23: StiWebViewer1.Report = report;


Please help me to fix the error.

Thank you.

[Edward]

Hi Maria,

Excuse me for my typing error and not clear explanation of the required steps.

Everything you did is correct.

Just change the name of the parameter. Right-click in the '% @name %' parameter (it is an incorrect name for the parameter) and change its name as follows:

@name

Then your query must work.

Thank you.

[Maria]

Hi Edward,
The program Worked.

Thank you very much:biggrin:

[Edward]

Hi Maria,

You are very welcome Have a nice day!

Thank you.