Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
299 Points
79 Posts
Apr 25, 2012 11:18 AM|LINK
Hi,
using (DbConnection connection = new SqlConnection("Your connection string")) { connection.Open(); using (DbCommand command = new SqlCommand("alter table [Product] add [ProductId] int default 0 NOT NULL")) { command.Connection = connection; command.ExecuteNonQuery(); } }
rakeshreddym
Member
299 Points
79 Posts
Re: Dynamic Table Using C#
Apr 25, 2012 11:18 AM|LINK
Hi,
using (DbConnection connection = new SqlConnection("Your connection string")) { connection.Open(); using (DbCommand command = new SqlCommand("alter table [Product] add [ProductId] int default 0 NOT NULL")) { command.Connection = connection; command.ExecuteNonQuery(); } }