help on altering tables on vb.net

[public]

So you tried it and got an error about some missing clauses? Show us that code. You are probably close, and there may be an easy way to get around the clauses.

i did not try it as i do not know how to do it.
The UPDATE statement allows you to update a single record or multiple records in a table.
the syntax is

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value;