SQL command to update column given ID

Question

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");

Jignesh Trivedi · Answer

hi Jay Try After removing quote before and after parameter. command.CommandText = @UPDATE ConfigTB SET 1Percent=@value WHERE Id=@ID; command.Parameters.AddWithValue(@ID 1); command.Parameters.AddWithValue(@value 10); hope this will help you.

Santhosh Kumar Jayaraman · Answer

The above code which i gave also will update..Please try that and let us know. Its just the query(commandtext here) should be an update one and not insert one.

Poppa Wallace · Answer

command.CommandText = @UPDATE ConfigTB SET PercentValue ='10' WHERE Id = 1; Sorted thanks

Poppa Wallace · Answer

command.Parameters.AddWithValue(@ID 1); I need to update the row that is ID1 not insert a row with ID 1

Santhosh Kumar Jayaraman · Answer

Try the below lines. command.CommandText = @UPDATE ConfigTB SET 1Percent='@value' WHERE Id='@ID'; command .Parameters.AddWithValue( @ID  1); command .Parameters.AddWithValue( @value  10);