hii guys,i just struck in the middle of the process, my query is initially i scraped data from the eCommerce website and stored it in a datatable which contains 3 columns and used for each loop,in body section i used assign activity to store each row value to three variables say product,url,price. i tried to add each row value to the database it worked but only the variables are added to it not the values
2 Likes
i assigned each row value to the variables product,url,price.and i placed those three variables in the values place i execute non query.
1 Like
In your database, What is the data type for product, price and url ? Is it string or not ?
And also product and price variables are Generic variables and change it to string and then try.
@lakshman hii i get the data from my datatable to database but it retrieved some rows and for some rows only variables names pasted
1 Like
Please follow below steps.
-
put that Connect activity outside of the loop and make it as first step.
-
Then read data from Excel file and use For Each Row activity to iterate that data.
ForEach row in DataTable - use Execute Non Query and pass insert query like this:
βINSERT into product(product,url,price) Values(β β+row(βproductβ).Tostring+β ', β β+row(βurlβ).Tostring+β ', β β+row(βpriceβ).Tostring+β ')β