I'm getting: An SqlCeParameter with ParameterName '1' is not contained by this SqlCeParameterCollection
...but my SQL insert statement IS working - it inserts the correct data from my collection (from a file). My params start at 0. Column names are correct, otherwise the insert wouldn't work. I can't figure out what's going on.
foreach (string dataLine in userData)
{
var dataItem = dataLine.Split(delimiterChar);
var FileToDB = "insert into Table1 (Column1, Column2, Column3, Column4, Column5, Column6, Column7) values (@0, @1, @2, @3, @4, @5, @6)";
Sir Codalot
Member
7 Points
10 Posts
An SqlCeParameter with ParameterName '1' is not contained by this SqlCeParameterCollection
May 02, 2012 10:37 PM|LINK
I'm getting: An SqlCeParameter with ParameterName '1' is not contained by this SqlCeParameterCollection
...but my SQL insert statement IS working - it inserts the correct data from my collection (from a file). My params start at 0. Column names are correct, otherwise the insert wouldn't work. I can't figure out what's going on.
foreach (string dataLine in userData)
{
var dataItem = dataLine.Split(delimiterChar);
var FileToDB = "insert into Table1 (Column1, Column2, Column3, Column4, Column5, Column6, Column7) values (@0, @1, @2, @3, @4, @5, @6)";
db.Execute(FileToDB, dataItem);
}
Please help! Thanks!