Invoke Code - Creating Datatable

[bbarik1994 (Binamra Barik)]

Trying to create datatable through code (i’m kind of new to this so any help would be great)

Error i’m getting:
No compiled code to run
error BC30289: Statement cannot appear within a method body. End of method asssumed. At line 1
error BC30429: ‘End Sub’ must be preceded by a matching ‘Sub’. At line 19

[hermawan (Rudy Hermawan)]

@bbarik1994

Is there any specific reason why you are not using the Build Data Table activity ?

[bbarik1994 (Binamra Barik)]

no specific reason , just exploring code capabilities

[Pankaj.Patil (Robot Master)]

Hello @bbarik1994,

You can use Invoke Code activity and paste following code in it,
Dim dt As DataTable
dt = New DataTable()
Console.WriteLine(“Datatable created”)
dt.Columns.Add(“Name”, GetType(System.String))
dt.Columns.Add(“Contry”, GetType(System.String))
Console.WriteLine(“Columns created”)

You can add rows to columns like,
dt.rows.add(“TCS”, “India”)
dt.rows.add(“UiPath”, “Romania”)

Cheers,
Pankaj

[hermawan (Rudy Hermawan)]

InvodeCode.xaml (6.1 KB)

Invode Code great example:

InvokeCode Example

Hi, The official training materials might not be up to date yet as this activity has only just been added to the Community edition. I can give a small example right here though. Just as with “Invoke Workflow”, you can specify arguments that will be accessible inside: [arguments] But instead of a workflow filename you enter Visual Basic code you want to execute, directly into an editor window. Suppose I want my code activity to randomly shuffle its string argument. I could program this as foll…

[bbarik1994 (Binamra Barik)]

thanks @hermawan

[bbarik1994 (Binamra Barik)]

thanks @Pankaj.Patil