Updating A Column Value In A Table
"UPDATE SomeTableName SET SomeColumnName=" + Convert::ToString(NewValue) + " WHERE SomeColumnName=" + Convert::ToString(IdValueOfRecordToAlter)
Assumes MyNewValue is numeric, otherwise surround with ‘ and ‘
Update 2 Column Values
"UPDATE SomeTableName SET SomeColumnName1=" + Convert::ToString(NewValue) + ", SomeColumnName2=\'" + NewString + "\' WHERE SomeColumnName=" + Convert::ToString(IdValueOfRecordToAlter);
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.