Insert value into database error


How to solve this error.

@swapnali1

The arguments you specified in the query should exactly match the Parameters you pass both in name and datatype.
For the query,
Update PurchaseOrderLineItems Set Status = @paramStatus where ID=@paramID

hi @Madhavi Thank you for solution it’s worked.Will you tell me how to dump this data into database. In my database table wrong values are inserted. I want to enter diffrent values.
Following is my query

“INSERT Into dbo.FlipkartData
([Names],[Numbers],[Ratings])
VALUES
(’@Names’, ‘@Numbers’, ‘@Ratings’)”

My table is like below

But I want insert scraped data into database scraped data is in excel file.sample1.xlsx (9.1 KB)

following is my code structure
flipkartDataToMySql.xaml (17.9 KB)
will you please help me

@swapnali1 remove ‘’ from your parameters.
"Insert into FlipkartData ([Names],[Numbers],[Ratings]) VALUES (@Names, @Numbers, @Ratings)”

@Madhavi ok. I will try

@Madhavi
After removing " I got following error

Can you please add your table schema and a screenshot displaying the parameters you are passing?

schema