Saturday, February 25, 2012

Alter a table all in C#

Is there a way to add a column to an existing table and do it all in C#

If my query string is as follows how do I execute the query?
ALTER TABLE interests ADD COLUMN Swim VARCHAR(1) NOT NULL DEFAULT('n')

Thanks
MoonWaYou could useExecuteNonQuery on a SqlCommand object.|||Thanks I got it working.

MoonWa

No comments:

Post a Comment