5
Answers

SQL command to update column given ID

Photo of Poppa Wallace

Poppa Wallace

13y
2.1k
1
How do I update a column giving the ID 1 

command.CommandText = @"UPDATE ConfigTB SET 1Percent='@value' WHERE Id='@ID'";
command.Parameters["@ID"].Value = 1;
command.Parameters.Add("@value", SqlDbType.Int).Value = Convert.ToInt32("10");

Answers (5)