Have you tried writing the parameters in the style of OleDb rather that the SQL Server style? i.e: "UPDATE Player SET (Goals=?) WHERE (PlayerName=?)" The parameters are recognized by the order in which you add them in your cmd.Parameters.Add... statemets, rather than their names.
Other that that, another posible cause of the problem is a wrong type of data in the AddWithValue, for instance, if the Goals column is of a numeric type but the FilePath.NewTotalGoals is a string (or vice-versa) you would get an error.
No comments:
Post a Comment