DEV Community

Wild Cat
Wild Cat

Posted on • Edited on

Convert DataTable to Array, List and Dictionary in UiPath

Convert a specific column of a DataTable to an Array 

'When no search condition is specified
dt.AsEnumerable.Select(Function(x) x("ColumnName").ToString).ToArray

'When a search condition is specified (e.g., excluding empty fields
dt.AsEnumerable.Where(Function(x) x("ColumnName").ToString <> "").Select(Function(x) x("ColumnName").ToString).ToArray
Enter fullscreen mode Exit fullscreen mode

Convert a specific column of a DataTable to a List 

'When no search condition is specified
dt.AsEnumerable.Select(Function(x) x("ColumnName").ToString).ToList

'When a search condition is specified (e.g., excluding empty fields
dt.AsEnumerable.Where(Function(x) x("ColumnName").ToString <> "").Select(Function(x) x("ColumnName").ToString).ToList
Enter fullscreen mode Exit fullscreen mode

Convert specific columns of a DataTable to a Dictionary 

'When no search condition is specified
dt.AsEnumerable.ToDictionary(Function(x) x("KeyColumn").ToString, Function(x) x("ValueColumn").ToString)

'When a search condition is specified (e.g., excluding empty fields
dt.AsEnumerable.Where(Function(x) x("KeyColumn").ToString <> "" AndAlso x("ValueColumn").ToString <> "").ToDictionary(Function(x) x("KeyColumn").ToString, Function(x) x("ValueColumn").ToString)
Enter fullscreen mode Exit fullscreen mode

Convert column names and values of a DataRow to a Dictionary 

'Convert from a DataRow
dr.Table.Columns.Cast(Of DataColumn).ToDictionary(Function(x) x.ColumnName, Function(x) dr(x.ColumnName).ToString)

'Convert from the first row of a DataTable
dt.Columns.Cast(Of DataColumn).ToDictionary(Function(x) x.ColumnName, Function(x) dt.Rows(0)(x.ColumnName).ToString)
Enter fullscreen mode Exit fullscreen mode

Convert values of a DataRow to an Array 

'Convert from a DataRow
dr.ItemArray.Select(Function(x) x.ToString).ToArray

'Convert from the first row of a DataTable
dt.Rows(0).ItemArray.Select(Function(x) x.ToString).ToArray
Enter fullscreen mode Exit fullscreen mode

Convert values of a DataRow to a List 

'Convert from a DataRow
dr.ItemArray.Select(Function(x) x.ToString).ToList

'Convert from the first row of a DataTable
dt.Rows(0).ItemArray.Select(Function(x) x.ToString).ToList
Enter fullscreen mode Exit fullscreen mode

Convert column names of a DataTable to an Array 

dt.Columns.Cast(Of DataColumn).Select(Function(x) x.ColumnName).ToArray
Enter fullscreen mode Exit fullscreen mode

Convert column names of a DataTable to a List 

dt.Columns.Cast(Of DataColumn).Select(Function(x) x.ColumnName).ToList
Enter fullscreen mode Exit fullscreen mode

Top comments (0)