running bcp queryout through C# program

[aceswildab1]

I'm trying to open a command prompt through the program and then run bcp. Here is the code.

System.Diagnostics .Process proc = new System.Diagnostics.Process ();
proc.StartInfo.FileName = "bcp";
proc.StartInfo.Arguments = @"select * from dbname" queryout C:\filename.csv -S servername\instance -U sa -P password –N;
proc.Start ();

On the queryout I get an error "; expected"

Any thoughts?

[sknake]

I'm assuming you mean a compile time error and not a runtime error? That would be because you are not terminating or escaping your string properly. Try this:

System.Diagnostics.Process proc = new System.Diagnostics.Process();
      proc.StartInfo.FileName = "bcp";
      proc.StartInfo.Arguments = @"select * from dbname"" queryout C:\filename.csv -S servername\instance -U sa -P password –N";
      proc.Start();

[aceswildab1]

This code worked :

proc.StartInfo.FileName = "bcp";
proc.StartInfo.Arguments = @"""select * from ims3.dbo.cinfo"" queryout ""C:\filename"" -S server\instance -U sa -P password -N";

I needed to double quote the sub strings.

[sknake]

I'm glad to see you found a solution.

Please mark this thread as solved if your question has been answered