Execute query Result?


#1

My scenario is:
i have excel file with list of values in a columnA i need to check those values database
how to check if the data is already present in database


#2

Hi,

There are an number of ways in which you can accomplish this. I have listed down a few below -

  1. Read the table from the database and store it in a datatable using the execute query activity, say, Database_tbl. Also read the excel and save it in another datatable, say, Excel_tbl. You can then write a LINQ query and use the outer join operation to check if the number of rows match.
    https://stackoverflow.com/questions/21244305/left-outer-join-two-data-tables

  2. The second way is to use the for each row loop on the Excel_tbl and use the below code in it -
    bool contains = Database_tbl.AsEnumerable().Any(row => VarColumnValue == row.Field(“ColumnA”));

  3. Another way is to use Database_tbl.select(“ColumnA = ‘VarColumnValue’”) and check if it returns any rows

Hope this helps

Regards,
Amrita


#3

Do u have any example for this


#4

overload resolution failed because no accessible ‘Select’ can be called with these arguments uipath
Am getting the above error on writing the below query
dt_WIs.Select(“Type=‘WI5’ AND Status=‘Open’”)

Can anyone help me with this?


#5

The information is insufficient.

In which activity are you Are using this query?

Is dt_WIs a datatable type?

Can you share the screenshot?