Failed to convert parameter value from a String[] to a String

Hello guys, im trying to insert a data table to SQL table, but keep getting this error. I tried server profiler, but it doesn’t show anything. I can see that it reads the SQL table, but then stops.

String[] is array of string. It’s not the same datatype as String.

So somewhere you are trying to put an array into a string variable/column.

but is it possible to know where does the Insert database activity breaksdown? Can I get a log of some sort?

Is it possible to see which value is incorect when inserting data table?

So i figured it out. Tried to import data collumn by collumn from the data table, then found out which collumn was causing problems and fixed it.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.