Click here to Skip to main content
15,881,413 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am applying bcp command to get particular table record, it is working perfectly and also generating a bcp file. But i want the return value (ie how may rows are copied).

can anyone tell me how to get that value from command prompt?
Thanks in advance.
Posted

1 solution

System.Diagnostics.ProcessStartInfo procStartInfo =
                    new System.Diagnostics.ProcessStartInfo("cmd", "/c " + "bcp Oceanic.dbo." + dBname + " out C:\\ProgramData\\Oceanic\\" + filename + " -U username -P password -n");
                procStartInfo.RedirectStandardOutput = true;
                procStartInfo.UseShellExecute = false;
                procStartInfo.CreateNoWindow = true;
                System.Diagnostics.Process proc = new System.Diagnostics.Process();
                proc.StartInfo = procStartInfo;
                proc.Start();
                string result = proc.StandardOutput.ReadToEnd();


Check this out for more information related to BCP command
BCP[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900