SQL loader using in C# for text file data to database

Question

0.00/5 (No votes)

See more:

Any one suggestion about my code which is giving error. Please suggest..

C#

protected void btnFlatFileData_Click(object sender, EventArgs e)
    {

        System.Diagnostics.Process sysprocess = null;
       
        string myCommand = "/C SQLLDR cccsgd/cccsgd@XE CONTROL=D:\\WorkingFolder\\Ctrl.ctl";

        try
        {
            sysprocess = System.Diagnostics.Process.Start("CMD.EXE", myCommand);
            sysprocess.StartInfo.RedirectStandardOutput = false;
            sysprocess.StartInfo.FileName = myCommand;
            sysprocess.StartInfo.UseShellExecute = false;
            sysprocess.StartInfo.WorkingDirectory = @"D:\WorkingFolder";
            sysprocess.StartInfo.RedirectStandardError = true;
            sysprocess.WaitForExit();
            sysprocess.Close();
            if ((sysprocess.ExitCode == 0))
            {
                lblmsg.Text = "Success SQLLOADER completed data insertion";
            }
            else
            {
                lblmsg.Text = sysprocess.StandardError.ReadToEnd().ToString();
            }
        }
        catch (Exception ex)
        {
            lblmsg.Text = ex.Message.ToString();
        }
        
    }

Getting Error

C#

No process is associated with this object.

Posted 24-Dec-13 1:06am

Daljit S. Gill

Updated 24-Dec-13 1:21am

phil.o

v3

Add a Solution

3 solutions

Solution 3

Thanks for help

Its working fine.

Posted 26-Dec-13 1:48am

Daljit S. Gill

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Richard MacCutchan · Accepted Answer · 2013-12-24T01:47:00

Solution 1

You have called the Start method, before you set up the StartInfo properties.

Posted 24-Dec-13 1:47am

Richard MacCutchan

Comments

thatraja 24-Dec-13 9:29am

Well spotted, 5!

Daljit S. Gill 24-Dec-13 23:28pm

Still getting error!!

Richard MacCutchan 25-Dec-13 4:29am

Well I'm afraid my crystal ball is not working today so I have no idea what that means.

Daljit S. Gill 25-Dec-13 5:25am

I have tried as per yours given instruction about program like but its even giving error. Please check and reply .

Thanks

Daljit S. Gill

Richard MacCutchan 26-Dec-13 5:23am

Well, I still can't guess what you are doing or what the error is. Please think about your problem and provide proper details of what your code doea, and what results you see or don't see.

Daljit S. Gill 26-Dec-13 5:32am

No process is associated with this object.

above mentioned error i m getting ...

pls see the code

Richard MacCutchan 26-Dec-13 6:28am

No sorry, I still can't guess. How about giving us a clue?

Daljit S. Gill 26-Dec-13 6:36am

can u tell me one thing when say "CMD.exe" from C# program on that Command Box what home path come?

Daljit S. Gill 26-Dec-13 6:40am

I have not much experience on C#.

Daljit S. Gill 26-Dec-13 6:42am

My program basically upload flat file (.txt) to oracle DB through this program. But I am not able to implement it.

Daljit S. Gill 26-Dec-13 6:44am

This program kind of BULK data insert into Oracle.

Richard MacCutchan 26-Dec-13 7:20am

See my latest solution below.

Daljit S. Gill 26-Dec-13 7:48am

thanks for help

its working fine!!

Richard MacCutchan · Accepted Answer · 2013-12-26T01:20:00

Try something like:

C#

ProcessStartInfo startInfo = new ProcessStartInfo("cmd.exe", myCommand);
startInfo.RedirectStandardOutput = false;
startInfo.UseShellExecute = false;
startInfo.WorkingDirectory = @"D:\WorkingFolder";
startInfo.RedirectStandardError = true;
System.Diagnostics.Process.Start(startInfo);