Since, I don't know the column data types, which you are passing to Sql Server. Here in this case, you obviously have something in
varchar
column that can't be converted to numeric type. This error message explains it clearly.
The solution is not so tough. You need to check for the following:
Solution:
1. Look at the data.
2. Find the non-numeric values in the varchar column.
3. Change/Remove those values.
You could have searched your error message in Google and fixed it.
--Amit