Skip to main content

Use DataTable with Table and Edit Grid controls

Make sure you already have a DataTable object in your app.

DataTables objects can be defined as input, output, or input/output arguments of a process. To use these DataTable objects, you need to reference the process where they are used as arguments.

note

DataTable only supports primitives in a column. Complex type arguments in a column do not function in DataTable.

Say you have a process named "Process_A", which has the DataTable objects as arguments:

Input argumentsin_dt1
Output argumentsout_dt1
Input/Output argumentsinout_dt

Table​

  1. Navigate to the General tab of your Table control.

  2. In the Data source field of the control, open the expression editor, and write the following expression:

    Processes.<process_name>.<datatable_output_argument>.ToListSource

    For example:

    Processes.Process_A.out_dt1.ToListSource

The table columns should reflect the columns of the DataTable object.

Edit Grid​

  1. Navigate to the General tab of your Edit Grid control.

  2. In the Data source field of the control, open the expression editor, and write the following expression:

    Processes.<process_name>.<datatable_output_argument>.ToListSource

    For example:

    Processes.Process_A.out_dt1.ToListSource

  3. To perform operations on the DataTable rows, such as adding, editing, or deleting:

  4. Make sure the Editable, Add rows, and Delete rows properties are set to true.

    ![docs image](https://dev-assets.cms.uipath.com/assets/images/apps/apps-docs-image-371833-f2f948a5.webp)

  5. Switch to the Events tab of the Edit Grid control, then configure the corresponding rules:

    1. To add rows, click Create rule for Row added, then use the Set Value rule:

      Item To Set 

      Processes.<process_name>.<datatable_output_parameter>

      For example: 

      Processes.Process_A.out_dt1
      Value

      Processes.<process_name>.<datatable_output_parameter>.AddRow(MainPage.EditGrid.NewItem)

      For example: 

      Processes.Process_A.out_dt1.AddRow(MainPage.EditGrid.NewItem)

    2. To delete rows, click Create rule for Row deleted, then use the Set Value rule:

      Item To Set 

      Processes.<process_name>.<datatable_output_parameter>

      For example: 

      Processes.Process_A.out_dt1
      Value 

      Processes.<process_name>.<datatable_output_parameter>.DeleteRowAt(MainPage.EditGrid.RowIndex)

      For example: 

      Processes.Process_A.out_dt1.DeleteRowAt(MainPage.EditGrid.RowIndex)

    3. To modify rows, click Create rule for Row modified, then use the Set Value rule:

      Item To Set 

      Processes.<process_name>.<datatable_output_parameter>

      For example: 

      Processes.Process_A.out_dt1
      Value 

      Processes.<process_name>.<datatable_output_parameter>.UpdateRowAt(MainPage.EditGrid.RowIndex, MainPage.EditGrid.SelectedItem)

      For example: 

      Processes.Process_A.out_dt1.UpdateRowAt(MainPage.EditGrid.RowIndex, MainPage.EditGrid.SelectedItem)