CRUD Operations, UiPath app table control. SQL table or Data service entities

Help Apps
,
1

Hi,

UiPath app table control.
Is it possible to use SQL database table on a table control and be able to perform CRUD operations on the records displayed in the table? Or only data services entities can be used for CRUD operations? I searched the web and mostly to perform CRUD operation on table data; data service is used in solotions i have found.

If its possible to uses sql tables please provide reference on tutorial or examples.

Thanx.

2

@Lerato_Tsoela ,

SQL CRUD operation is possible using RPA UiPath Process. You can write all type of operation process and you can call process.

Thanks,
AK

3

Hi @Lerato_Tsoela

Try this

Hope this might help you :slight_smile:

4

Hi,

I think my question was not understood or maybe my phrasing was not clear. How do I implement a click on a record from a table control in UiPath app studio … And then edit it and save it in SQL table…the connection and run queries in studio I understand.

My problem is how do I implement a click on a record from a table control in UiPath app studio. I have seen this being done but on entities from data service not SQL table…so I want to know is this possible to be done with SQL tables.

5

@Lerato_Tsoela1 ,

Yes said above, Yes you can do with SQL but not a direct rules to implement it. so please follow below approach.

  1. Create an UiPath Process
    → Process will connect with SQL
    → In Process you can do Insert/Update/Select Query.
    → If you have a select query and list of data then run an activity to get list of data and store into Data table Our Argument.
    → If you have single return value then store into Out_{Argument Property}
    → If you have to pass any value from apps to SQL then create In_{Argument Property}
  2. UiPath Apps work with Process In and Out Argument where from Apps you can pass value to process and Out will return value to apps.
  3. Now suppose you have a list of records then get it into data table and then Place a table into page and map data source of page as Out_Datatable Argument
  4. On Table you can do rest of CRUD operation by selection of records

If you have more query lets have a call we can sort this out.

Thanks,
Arvind

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.