Solved

Can we pass datatable as input to a C# DLL as a parameter ?

  • 14 January 2023
  • 5 replies
  • 344 views
A
Badge +1

Hi Team,

 

I wanted to pass DataTable as input parameter to C# DLL. I am unable to find Datatable parameter in the parameter type. Is it possible to pass Datatable as an input?

 

Is there a workaround to pass a datatable as parameter?

 

DLL Parameter

 

icon

Best answer by rbkadiyam 14 January 2023, 19:29

View original

5 replies

rbkadiyam
Rank
Userlevel 5
Badge +14

@anandc  check this article if it can help - https://www.c-sharpcorner.com/UploadFile/87b416/passing-datatable-to-storeprocedure-as-parameter-in-C-Sharp/

Ramesh B Kadiyam
A
Badge +1

@anandc  check this article if it can help - https://www.c-sharpcorner.com/UploadFile/87b416/passing-datatable-to-storeprocedure-as-parameter-in-C-Sharp/

Thanks for sharing. This article mentions passing a list and then converting the list to Datatable. Can we directly pass datatable variable?

Marc 1985
Userlevel 2
Badge +5

Hi @anandc ,

when i remember correct this is not possible just List and Dictionary.

Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
M
Badge +2

Hi, 

It is supporting this data type only.
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-run-dll.html

 

D
Badge

 There is one possible way. In Run Function you need to pass Datatable as String[,] as Input Parameter.



DLL Function arguments must be as below. and should return the multidimensional array.

 

you first need to convert this 2d array into datatable and after that perform required operation on that datatable and again convert it back to array.

it works.
reach out to me if you need help.

Reply


Terms & ConditionsCookie settings