Click here to Skip to main content
12,955,891 members (65,403 online)
Rate this:
Please Sign up or sign in to vote.
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 16-Jan-13 1:01am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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;
                string result = proc.StandardOutput.ReadToEnd();

Check this out for more information related to BCP command

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,719
CHill60 3,550
Maciej Los 3,153
ppolymorphe 2,060
Jochen Arndt 1,975

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100