what am i missing here -trying to insert data in existing row
cmdScnDesc = new SqlCommand("INSERT INTO PlacementRunResults(ScenarioDescr) VALUES (@_scenarioDescr) WHERE scenarioid LIKE @_scenarioid",dbConnection._conn);
Thank you in Advance
Class library usage, coding and language questions.
3 posts • Page 1 of 1
You need update statement. I think it should look like that, but you may want to google it to make sure the correct syntax.
Code: Select all
UPDATE TABLE PlacementRunResults SET ScenarioDescr = @_scenarioDescr WHERE scenarioid LIKE @_scenarioid