How to refresh a sql adapter when changes are done at the database.

[shailaja]

Hi,

I am new to vb.net.
I have created a web application in which I have dragged
and dropped the Customers table on the aspx design page.
Hence I have an adapter for the Customers table which has
the code for the Select Command, Insert Command with all
the columns that existed at the time of creation of the
adapter.
Now, I have deleted some columns on the Customers table.

Hence when I try to compile the web application, there
are errors since the Select command in the adapter has
the columns that were deleted.

My query is whether we can do a refresh on the adapter to
select only the columns that exist or do we have to
manually update the select command in the properties of
the adapter.

Thanks in advance.
Shailaja