Can't find UiPath.Database.Activities

Help Activities
,
1

Please assist, I can’t find this in all packages: UiPath.Database.Activities

3

Hi @stanstilo

Please change the compatibility mode to ‘Windows legacy’ and check.

database
database1601×1020 134 KB

Hope this will help you. Thank you.

1 Like
5

I changed the mode to windows cause I was working on large amount of files but couldn’t find UiPath.Database.Activities so if I change it back to Windows Legacy, how do I make it work with large amount of files without throwing out of memory exception

6

What kind of files you are working in large amount?

7

Yes, from database upto 3,000,000 records

8

Please have a try at this.

Rows limited to 16,777,216.

Thank you.

9

Thanks, so here am I converting the datatable to dataset?

10

yes they are making use of ADO.Net

11

So after adding those datatables as datasets, how do I read them back as datatable to perform some manipulation

12

Let’s say merge the datatable or add rows or sum a column etc

13

DataSet To DataTable

DataTable customerTable = dataSet.Tables[“YourTable”];

Thank you

1 Like
14

Hi Jobin, please I am somehow confused implementing that to my workflow, do you have sample workflow you’ve worked on with the snippet, please share. It will help me get through this and mark as solution

15

Are you there?

17

Provide you an update in the evening IST. Jumping into an another work :slight_smile:

1 Like
18

Ok, thanks

19

Hi Jobin, hope you haven’t forgotten the workflow

20

Here is the sample snippets from website.

Add Data To Dataset.xaml (16.2 KB)
Add Datatable[s] To Dataset.xaml (12.2 KB)

Thank you.