Run SQL Server script from C# code

[Sushant Duggal]

Hi friends, I want to run sql server 2000 script (abc.sql) file from my C# application. Can you guide me?? Regards,

Sushant Duggal.

[Blue_Boy]

read it as textfile than paste content of it in SqlDataAdapter or SqlCommand or in SqlDataSource

---

I Love SQL

[Pete OHanlon]

I would suggest that you look at using Process.Start to run osql.exe.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.

[Colin Angus Mackay]

Sushant Duggal wrote:

Can you guide me??

You can run just about any SQL through a SqlCommand. Just read the file in to a string and dump the string into the SqlCommand. NOTE: GO is not SQL. It is a preprocessor command to Query Analyzer to tell it to split the file into batches. If your file has GOs in it, you need to split it up and send them as separate SqlCommands.

---

Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[Sushant Duggal]

Hi Pete, Thanks for your post. Can you tell me after starting the osql process, what I need to do. Regards,

Sushant Duggal.

[Sushant Duggal]

Thanks for the reply friends. Regards,

Sushant Duggal.