You can use this line of code:
YourTableAdapter.Update(YourDataSet.YourTable)
Note that when you debug, it grabs a new copy of the original database from the project folder. It will only change the database which is copied to the debug folder. To see if the change was made, debug the program, make the change, close the program, and then navigate to the debug folder. Then run the exe, and your change should be there.
Hopefully this solves your problem!