How to initialize a DataTable with Values as an argument?

Help Studio
, ,
1

How can I initialize a DataTable with default-values for testing/debug as an in_argument in a workflow?
It must be something similar to:
New DataTable from { {“row1col1”, “r1c2”}, { “r2c1”, “r2c2” } }
How exactly should be the syntax please?

// please understand the question and don’t recommend activities as “Build DataTable” (as in other topics), cause when the workflow is invoked, the in_datatable is already initialized. The need is just for quick testing and debug the xaml alone (independent of the rest of project)

2

out of the box, there is no DataTable init statement, which populates also the values, as the data table needs a defined column structure

However, have a look at this JSON trick

grafik
grafik596×127 12 KB

1 Like
3

Try this
New DataTable From {{"Column1", "Column2"}, {"row1col1", "r1c2"}, {"r2c1", "r2c2"}}

Regards,
Arivu

4

error BC36718: Cannot initialize the type ‘DataTable’ with a collection initializer because it is not a collection type :frowning:

5

we got this error as it is not supported, due to also mentioned:

6

thx, it looks interesting and could be a solution

  1. JArray is not declared. What have I import for it?
  2. please write the syntax as a text, instead of picture, so we can copy it to test it :slight_smile:
7

Hi @Chris.ro ,
NO LUCK

There is no single line code to create a datatable with default values.

You have to use build datatable/invoke code/ using multiple assign activity to achive.
or you can go with @ppr suggestion

Regards,
Arivu

8

thx arivu, I like also the ppr’ suggestion.
What do I need to use his “JArray”?

btw: the syntax could be also on more lines. Do you know how init on more lines?

9

An interface showing a list of imported namespaces, with 'Newtonsoft.Json' and 'Newtonsoft.Json.Linq' highlighted. (Captioned by AI)
An interface showing a list of imported namespaces, with 'Newtonsoft.Json' and 'Newtonsoft.Json.Linq' highlighted. (Captioned by AI)317×411 43.2 KB

JArray.Parse("[{""col1"":""val1""},{""col1"":""val2""},{""col1"":""val2""}]").ToObject(Of DataTable)
2 Likes
Forum Engagement Daily Reports
10

when lines are rows, then it is already done:
grafik
as we already can proof

When structure is about more columns, similiar we can use the JSON Trick:
grafik

JArray.Parse("[{""col1"":""valA1"",""col2"":""valB1""},{""col1"":""valA2"",""col2"":""valB2""}]").ToObject(Of DataTable)
3 Likes
11

solved!
many thanks @ppr

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.