Converter coluna de tabela de dados em matriz

[devrpa746]

Olá comunidade, estou com um problema na seguinte expressão:
tabela. AsEnumerable().Select(Function (a) a.Field(Of String)(“FORNECEDOR”).toString).toArray()

O que me retorna é apenas: “System.String”, não me retorna a matriz de dados.

[vishal.kp (vishal)]

Hi @devrpa746 ,

Refer to the following thread by @rohith.prabhu, it explains how to convert the column to an array:

How to Convert a Row or Column items of a DataTable into Array or List

There are some cases where we need to convert items present in a row or column of a DataTable into an Array. 1. To convert Row items into Array or List : There are several method (such as LinQ Query, .Select method, filter activity or read row activity) available to filter and select the required row from a DataTable. Once the required row is selected (store in SelectedRow) : Use Assign acitvity MyDataArray | DataType: Array(of String) To Convert to Array : MyDataArray = SelectedRow.Sele…

Regards,

[Anil_G (Anil Gorthi)]

@devrpa746

Please try this

dt.AsEnumerable.Select(function(x) x("ColumnName").ToString).ToArray

I guess it is returning a string array for you as well to print use like this

String.Join(",",dt.AsEnumerable.Select(function(x) x("ColumnName").ToString))

cheers