How to read and execute script file

[ad]

I create a script file (.sql) with DTS.
How can I read it into Asp.net and execute it?

 

[Cor Ligthert [MVP]]

Ad,

For both you have to use the
"ExecuteNonQuery" from a xxxcommand where xxx is the provider

I hope this helps,

Cor