Working with Data Tables - Designer - Foundation 24.1 - Foundation 24.1 - Ready - Hyland RPA - external

This topic provides code samples of how to work with data tables.

• Gets the item from the second row and fourth column of the data table

  myString = myDatatable.Rows(1)(3).ToString()

• Deletes the third column in the data table

  Columns.RemoveAt(2)

• Checks if the data table has a column named "Total" and returns true or false

  doesContain = myDatatable.Columns.Contains("Total") 

• Gets the index of the column named "Total"

  myIndex = myDatatable.Columns.IndexOf("Total")

• Gets an array of DataRows with all rows where the value of the "Last name" column is equal to "Mayer"

  drSelection = dt.Select("Lastname = 'Mayer'") 

• Gets an array of DataRows, sorted in ascending order by the Age column, containing all rows where the value of the LastName column is equal to "Mayer"

  drOrderedSelection = dt.Select("Lastname = 'Mayer'", "Age ASC")

• Combines all values of a given DataRow into a string. The values are separated by " | "

  myRowString = String.Join(" | ", row.ItemArray.Select(Function(p) p.ToString()))