Convert a DataColumn to an array of strings

Help
, ,
1

I have a datatable DataTableResults, returned by a SQL query with only one column of strings.
I would like to convert it to an array of Strings.
This selects only the column, and returns a DataColumn

ProjectsDataTable.Columns(0)

However, if I write this:

ProjectsDataTable.Columns(0).ToArray

I get an error (“ToArray is not a member of…”)
How do I convert a DataColumn to an array?

2

You can try using Split.

image
image828×299 10.6 KB

2 Likes
3

@Kon_T_Amusse
Lets assume you hold the Data in a variable of Datatype Datatable.

Following Statement uesd within an assign Activity Let you Return a String Array of the values from a particular column.

YourDataTableVar.AsEnumerable.Select(function (row) row("YourColumnnameOrIndex).ToString).ToArray

3 Likes