Search Data in SQL DB

[Naresh_Upadhyay]

Hi

I have extract the data (e.g, ID, Vendor Name) from a webpage and stored into a data table. Now I want to check the ID in SQL DB table whether ID is stored in the DB or not.

I am not sure which activity should be used and how ID will be checked in DB. Can someone please help me?

[urvesh.mistry]

Hello @Naresh_Upadhyay,

Create one temporary variable to store the website table information.

You can use Execute Query by downloading UiPath.Database.Activities

In the Execute Query Activity type select query to get all the data from table.

Now compare both (Data stored in temporary variable and execute query variable) the table using for each row activity.

[Srini84 (Srinivas)]

@Naresh_Upadhyay

Once you stored the webpage data into datatable → DT1

Use ForEach Row activity to loop

Store your value as ID = row(“ID”).ToString

Use Execute Query activity to check the ID in sql table

Now you can use query like “SELECT * FROM TABLENAME WHERE ID = ID”

Create a output variable → DT2

Now use IF condition DT2.Rows.Count>0

Then It is present → Else Its not present

For more reference you can check Link

Hope this helps you

Thanks

[Naresh_Upadhyay]

Thanks for reply!! it worked.