In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
and execute it to create my schema for MS-SQL2000?

Jack

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" <jack@no_spam.com> wrote in message
news:%23%(E-Mail Removed)...
> In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
> and execute it to create my schema for MS-SQL2000?
>
> Jack
>

Yes you can.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
__________________________________________________________


"Jack" <jack@no_spam.com> wrote in message
news:%23%(E-Mail Removed)...
> In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
> and execute it to create my schema for MS-SQL2000?
>
> Jack
>

Thanks very much

"Sahil Malik [MVP C#]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Yes you can.
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
> __________________________________________________________
>
>
> "Jack" <jack@no_spam.com> wrote in message
> news:%23%(E-Mail Removed)...
>> In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
>> and execute it to create my schema for MS-SQL2000?
>>
>> Jack
>>
>
>