Databases
StackOverflow2013
Postsdbo
POExecute multiple command lines with the same process using C#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExecute multiple command lines with the same process using C#
    primarykey
    data
    text
    <p>Hi according to my last question <a href="https://stackoverflow.com/questions/2846700/how-i-can-verify-my-pl-sql-syntax">here</a> I try to write a sql editor or some thing like this,in this way I try to connect to CMD from C# and execute my command. Now my problem is I connect to SQLPLUS after that I cant get SQLPLUS command,and the other resource I review don't satisfy me. Please help me how after I connected to sqlplus , I can a live my process to run my sql command? right now I use this code:</p> <pre><code>//Create process System.Diagnostics.Process pProcess = new System.Diagnostics.Process(); //strCommand is path and file name of command to run pProcess.StartInfo.FileName = strCommand; //strCommandParameters are parameters to pass to program pProcess.StartInfo.Arguments = strCommandParameters; pProcess.StartInfo.UseShellExecute = false; //Set output of program to be written to process output stream pProcess.StartInfo.RedirectStandardOutput = true; //Optional pProcess.StartInfo.WorkingDirectory = strWorkingDirectory; //Start the process pProcess.Start(); //Get program output string strOutput = pProcess.StandardOutput.ReadToEnd(); //Wait for process to finish pProcess.WaitForExit(); </code></pre> <p>I customized it. I separate the initialize, I created the process object one time I still have problem, to run the second command I use these codes for the second call:</p> <pre><code>pProcess.StartInfo.FileName = strCommand; //strCommandParameters are parameters to pass to program pProcess.StartInfo.Arguments = strCommandParameters; //Start the process pProcess.Start(); //Get program output string strOutput = pProcess.StandardOutput.ReadToEnd(); //Wait for process to finish pProcess.WaitForExit(); </code></pre> <p>Thanks in advance</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USAmir
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POExecute multiple command lines with the same process using C#
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COFWIW, those comments are just noise...
      singulars
      1. POExecute multiple command lines with the same process using C#
      1. USAustin Salonen
    2. CODo you mean you want to start the process once, but send multiple commands to it? If so, why not just send multiple commands starting the whole process from scratch each time (pun not intended, but fun anyway)
      singulars
      1. POExecute multiple command lines with the same process using C#
      1. USJacques Bosch
    3. COExactly... I just run one time sqlplus after that i give user/pass and if it login send Sql.PL command. I m a little bit confusing :( actully it take time each time i try to connect DB & run my commands...but i dont have any idea,maybe other software use like this? ha?any Idea?
      singulars
      1. POExecute multiple command lines with the same process using C#
      1. USAmir
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload