Configuring tableadapters after doing "minor changes" to the database table

microsoft.public.dotnet.framework

6 Aug 2006 5:18 PM

eblanco

Hi all,
It seems that when you change a table and make some minors changes to
it, the tableadapter does not update when you re-configure it.

What do I call "minor changes"?
Setting a column as an identity column without changing the datatype.
Changing the length of a varchar column.

When you add, delete or change the datatype of a column in the database
table, the tableadapter configures itselft ok.

As fas as I know one way to recreate the columns is to delete the
affected columns in the datatable and regenerate the tableadapter, ¿is
there a better way?

Enrique Blanco
MCSD.NET MCDBA
www.eblanco.com