Select Database Records From DB using RPA

• Download UiPath.Database.Activities package(s)using managae package
• Then Create an activity using Database
• Connect your database using Connect Activity of Database Activity
• Provied all creadentials for connecting the DB
• Store this connection in a particular variable so that we can this to perform DB operations
• Now use ExecuteQuery activity from Databse Activity.This will need a connection variable then we defined while creating connections, the SELECT query that we are going to perform
• Now store this data into some DataTable variable say userDataTable
• To check whether we got the data use MessageBox and write userDataTable.Rows.Count.ToString()