How to pass datatable input in SQL Query

ecaballes · February 23, 2021, 5:52am

Hi, Please Help me with this,

monsieurrahul · February 23, 2021, 5:54am

Have you tried passing the RowIndex instead of DT(row)?

ecaballes · February 23, 2021, 6:23am

I think this still don’t work for me

vignesh.ks · February 23, 2021, 6:28am

After .ToString give + and close the double quotes. Thanks.

ecaballes · February 23, 2021, 6:33am

Hi vignesh,

Still error

vignesh.ks · February 23, 2021, 6:41am

Can you share the error screen shot. Thanks.

ecaballes · February 23, 2021, 6:51am

Can i share you my .xaml

vignesh.ks · February 23, 2021, 7:06am

Please find the attached xaml file for your reference.

Feel free to reach us at any time if you have doubt. Thanks.

Happy Automation.

ecaballes · February 23, 2021, 7:10am

wow nice great,

how did you clear the error ?,

Thank you.

vignesh.ks · February 23, 2021, 7:37am

@ecaballes You gave two ‘single quotes’ for some values, I cleared one on each quotes and the error gone. Thanks.

Topic		Replies	Views
How to Pass variable to sql execute query? Help datatable , database , uiautomation , variable	36	35835	October 10, 2018
Insert a varibale coming from an excel in a query Studio question	11	369	January 8, 2024
I want to know how to pass excel output into the SQL queries for find matched values Task Mining question , task_mining	8	1869	October 12, 2021
How to use uipath Datatable like sql table and run query Studio studio , question , extension	4	1264	July 12, 2023
How to pass a datatable variable to execute query activity to use sql queries Help activities	6	3593	September 5, 2019