How to change the database schema by data adapter?

[barbara_dave]

Hi, all

Can I add one field in one existing table of the database with data
adapter at run time, and how?

Thanks!

 

[Ken Tucker [MVP]]

Hi,

You can use altertable. Wont work with dataadapter use an
sqlcommand and executenonquery.

http://msdn.microsoft.com/library/d...ry/en-us/dnsqlmag04/html/InsideALTERTABLE.asp

Ken
------------------------
Hi, all

Can I add one field in one existing table of the database with data
adapter at run time, and how?

Thanks!