Run one more command on Process.

[NanaA]

I want to run .sql script file on Oracle database using c#.net.
What I am doint is,

ProcessStartInfo processInfo = new ProcessStartInfo("sqlplus");
processInfo.Arguments = "scott@db/tiger @M:\\OracleRunScriptTest.sql";
Process exeProcess = new Process();
exeProcess.StartInfo = processInfo;
bool b = exeProcess.Start();

This is running the script, But it opens a cmd window.
And Unless and untill I close that window, it doesnt commit the changes.

If I add
processInfo.WindowStyle = ProcessWindowStyle.Hidden;
processInfo.CreateNoWindow = true

not to open window, it doesnt do anything.

So I think is I want to fire "commit", or "exit" or "quit" on same cmd exe in current Process and then close the window.

uuufffff finally finished writing my problem.
Now anybody has answer to this??
Its urgent

[NanaA]

ALL MVPs please atleast I expect something from you guys and Gals.

I want to run .sql script file on Oracle database using c#.net.
What I am doint is,

ProcessStartInfo processInfo = new ProcessStartInfo("sqlplus");
processInfo.Arguments = "scott@db/tiger @M:\\OracleRunScriptTest.sql";
Process exeProcess = new Process();
exeProcess.StartInfo = processInfo;
bool b = exeProcess.Start();

This is running the script, But it opens a cmd window.
And Unless and untill I close that window, it doesnt commit the changes.

If I add
processInfo.WindowStyle = ProcessWindowStyle.Hidden;
processInfo.CreateNoWindow = true

not to open window, it doesnt do anything.

So I think is I want to fire "commit", or "exit" or "quit" on same cmd exe in current Process and then close the window.

uuufffff finally finished writing my problem.
Now anybody has answer to this??
Its urgent