J Jack Dec 30, 2005 #1 In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff, and execute it to create my schema for MS-SQL2000? Jack
In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff, and execute it to create my schema for MS-SQL2000? Jack
W W.G. Ryan - MVP Dec 30, 2005 #2 jack: Are you asking if you can write DDL Statements and Execute them against Sql Server? If yes, than the answer is yes. Just set the commandtext property of you SqlCommand object to the DDL Statement and use ExecuteNonQuery afterward.
jack: Are you asking if you can write DDL Statements and Execute them against Sql Server? If yes, than the answer is yes. Just set the commandtext property of you SqlCommand object to the DDL Statement and use ExecuteNonQuery afterward.
S Sahil Malik [MVP C#] Dec 31, 2005 #3 Yes you can. - Sahil Malik [MVP] ADO.NET 2.0 book - http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx __________________________________________________________
Yes you can. - Sahil Malik [MVP] ADO.NET 2.0 book - http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx __________________________________________________________
J Jack Jan 2, 2006 #4 Thanks very much Sahil Malik said: Yes you can. - Sahil Malik [MVP] ADO.NET 2.0 book - http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx __________________________________________________________ Click to expand...
Thanks very much Sahil Malik said: Yes you can. - Sahil Malik [MVP] ADO.NET 2.0 book - http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx __________________________________________________________ Click to expand...