Run Sql Query in band's events

[IskandarAir]

Dear Stimulsoft team,

I would like to run a sql statement in the event of StiText. When Text is being set to StiText in DataBand, i would like to grab the cell of that particular row AND by that value to run SQL STATEMENT. LIKE THIS:

JAMES (Sql Query -> SELECT USER_CODE FROM USERS WHERE USER NAME = 'JAMES' )
BILL (Sql Query -> SELECT USER_CODE FROM USERS WHERE USER NAME = 'BILL' )
SUSY (Sql Query -> SELECT USER_CODE FROM USERS WHERE USER NAME = 'SUSY' )

Also set to back to StiText the result of Sql Query.

HOW CAN I DO THAT?

Regards,
Iskandar A

[Lech Kulikowski]

Hello,

You can use a parameter in the query:
SELECT USER_CODE FROM USERS WHERE USER NAME = @Param1

set param in the BeforePrint event and use Connect() method for data source.

Thank you.

[IskandarAir]

Hello,

Can you please provide a row sample in .mrt file . Or more detailedly explain with code samples
It is difficult to understand the approach from above


Regards,
Iskandar A.

[IskandarAir]

what is Param1 and should it be defined or it is already defined? will your approach will work for each row's cell ?

Regards,
Iskandar A

[Lech Kulikowski]

Hello,

Please check the sample report in the attachment.

Thank you.

[IskandarAir]

Thanks it worked


Regards,
Iskandar A

[Lech Kulikowski]

You are welcome.