Re: How to run a Command and retrieve data from it ? - C# Discussion Boards

Problem with multirow selection in DataGridView control

sandeepkavade2-Feb-11 22:14

2-Feb-11 22:14

Hi,

I have a DataGridView control on a form. It as one DataGridViewComboBoxColumn column. DataGridView control is not bound to any datatable or collection. I am populating it manually. Suppose DataGridViewComboBoxColumn has items 'CCW' and 'CW'. User can select either of these. While closing the form I am just reading the column values. So for its fine till MultiSelect is set to False.

I want to change DataGrid's behavior to multi select row. User can select multiple rows and change the property to 'CW' or 'CCW' and it should get applicable to all the selected rows in the grid.

How I can achieve it?

How to run a Command and retrieve data from it ?

All Time Programming2-Feb-11 21:01

All Time Programming

2-Feb-11 21:01

Hello,

I want to run a Command from command promt and want its output and maipulate its output. If required, want to close the process and display error or appropriate message.

How is that possible. Any help is highly appreciated. I am stuck with this and would be glad if any body helps me solve my problem.

Thanks

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

Richard MacCutchan2-Feb-11 21:58

Richard MacCutchan

2-Feb-11 21:58

Send the output to a file and retrieve and process it from there. However, your exact requirements in the above question are a little unclear.

I must get a clever new signature for 2011.

Re: How to run a Command and retrieve data from it ?

All Time Programming2-Feb-11 22:38

All Time Programming

2-Feb-11 22:38

I am tying to connect to server via cmd. Server keeps on giving output. Suppose the server gave output as : Trying to start ..... Cananot load file ..... Exiting OR
Trying to start ..... Authenticating... Some thing ..... More.... Else,.......... keeps on going

While retrieving the output, I want to check for lines like "Cannot find file", "Connected Successfully, etc and set properties ccordingly (like connected = true, errorMsg = "Cannot find file". Where I am calling the class, I can take care of those proeprties and stop if found connected == true or errorMsg.length > 0. With this inform the user that "Connection is achieved or error msg stating regarding "Cannot load file" and disconnect the server if errorMsg found.

try
{
process = Process.Start(processInfo);

process.BeginOutputReadLine();

I start the process, now got to <b>check the output while the process is already running</b>. That checking part am stuck up with. Process mostly wont Exit normally, I got to exit it. I mean just dir and got results ans process is exited - nothing like that. command keeps on giving output lines. To stop the server, I got to press "F4" on command prompt. How do I stop from here.

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

Pravin Patil, Mumbai2-Feb-11 22:17

Pravin Patil, Mumbai

2-Feb-11 22:17

As Richard said, you can direct the output of any command to output file.
e.g.
dir >> C:\\list.txt

this will output all the directories in the current drive to C:\\list.txt file.

Hope this helps.
All the best.

Re: How to run a Command and retrieve data from it ?

OriginalGriff3-Feb-11 0:00

OriginalGriff

3-Feb-11 0:00

If you are starting the process from a C# app, then you could use the Process.StandardOutput[^] property to capture the command output and do what you like with it. There is an example in the link.

The other option is to start the command in a command prompt and pipe it's output to your app. That would work with a console app, but I've never needed to try it with a WinForms.

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."

Re: How to run a Command and retrieve data from it ?

All Time Programming3-Feb-11 1:02

All Time Programming

3-Feb-11 1:02

Thanks OriginalGriff,

I coded the foloowing :
<code>
processInfo = new ProcessStartInfo("cmd.exe", "/C " + command);
sb = new StringBuilder();
processInfo.UseShellExecute = false;
processInfo.RedirectStandardOutput = true;
processInfo.CreateNoWindow = true;
process = Process.Start(processInfo);

process.BeginOutputReadLine();
process.OutputDataReceived += new DataReceivedEventHandler(Process_OutputDataReceived);

public string ErrorMessage
{
get { return errorMsg; }
set { errorMsg = value; }
}

private void Process_OutputDataReceived(object sender, DataReceivedEventArgs e)
{
errorMsg = "";
connected = false;
string d = e.Data;

if (!string.IsNullOrEmpty(d))
{
if (sb != null)
sb.Append(d + "\n");
Console.WriteLine("LINE = " + d); // I see each line
if (d.IndexOf("Initialization Completed") > 0)
{
connected = true;
Console.WriteLine("********* Connected = " + connected);
}
else if (isInValidLine(d))
{
//throw new Exception(d);
connected = false;
errorMsg = d;
return;
}
}
}
private bool isInValidLine(string line)
{
if (line.IndexOf("Cannot load file") > 0)
{
errorMsg = line;
return true;
}
return false;
}
</code>

The output that I see is :
LINE = Thu Feb 03 17:22:28 2011 Cannot load file path (null) (SSL_CTX_load_verify_locations): error:02001002:system library:fopen:No such file or directory: error:2006D080:BIO routines:BIO_new_file:no such file: error:0B084002:

Based on the above code and output, isInValidLine() should find the text "Cannot load file" and errorMsg should be set to the line and it should return true.

My Implementation :
<pre>
while (!oc.Connected)
{
timepassed = (int)(DateTime.Now - start).TotalMilliseconds;
if (timepassed > timeout)
{
oc.DisconnectServer();
connectedToVpn = false;
throw new Exception("NotConnectedException");
} else if (oc.ErrorMessage.Length > 0)
{
oc.DisconnectServer();
connectedToVpn = false;
throw new Exception(oc.ErrorMessage);
}
Thread.Sleep(100);
}
</pre>

checks for if (oc.ErrorMessage.Length &gt; 0), but the value of errorMsg is always "". Why so ?

Where am I going wrong or doing something invalid that the code seems to never check for isInvalid() method only ? I tried adding the same lines of isinvalid() in the place it is called, but yet no differnce.

Where am I going wrong that the Process_OutputDataReceived never sets and errorMsg via isInvalid() ? Please help me get my mistake and rectify it. Badly stuck up at this location.

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

OriginalGriff3-Feb-11 1:11

OriginalGriff

3-Feb-11 1:11

I can't see anything too obvious with the code as it stands (but remmebr to check the "use HTML in this post" option at the bottom, and use "code block" rather than "inline code" next time).

If you are getting the line printed - and it appears you are - then it isn't obvious what is happening.
Have you tried putting a breakpoint at the start of Process_OutputDataReceived and stepping through?

Re: How to run a Command and retrieve data from it ?

All Time Programming3-Feb-11 1:24

All Time Programming

3-Feb-11 1:24

Hmm, the class that handles the conection is in a library. When i added break in Process_OutputDataReceived (before execution & while execution), the app doesn't print any Line on Console. I removed the break and tried again then it showed the LINE = on console.

How to add breakpoint in a library class whose dll is included in main project. While degbuging the dll class comes normally and does the debugging.

How to handle this ? Is it due to the class is in a library ?

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

OriginalGriff3-Feb-11 1:30

OriginalGriff

3-Feb-11 1:30

All Time Programming wrote:
When i added break in Process_OutputDataReceived (before execution & while execution), the app doesn't print any Line on Console. I removed the break and tried again then it showed the LINE = on console.

That implies it hit the breakpoint - did you try switching to VS and looking at the library code where you put the BP?

I tried your code on my machine - using "dir" as the command, and a file size and date for the comparison - and it worked fine. You need to look at the data you are comparing against, I think: are those really spaces for example?

Or: are you using the release version of the library in the app, and modifying the debug version?

Re: How to run a Command and retrieve data from it ?

All Time Programming3-Feb-11 2:02

All Time Programming

3-Feb-11 2:02

>> Or: are you using the release version of the library in the app, and modifying the debug version?

What do you mean ? I change the code in library and build it. The reference is added in main application. I build the main app, which updates the dll file and I execute the application. I checked the dll file date/time in main app, its of Release version of library. The library & app is in Release version.

Should they be in Debug version ? How to change them ?

The spacing must not be a problem as I copy from the output only and put in my if to look for indexOf.

But yes, I think that applying BP on 1st line of Process_OutputDataReceived while execution helps. It got the "Cannot load file..." line and it went in isInvalid, went inside that if, changed "connected = false", and for the next line

        else if (isInValidLine(d))
        {
            //throw new Exception(d);
            connected = false;     // MADE THIS
            errorMsg = d;          // EXECUTED THIS ALSO BUT AGAIN VALUE = ""
            return;
        }


private bool isInValidLine(string line)
{
    if (line.IndexOf("Cannot load CA certificate file") > 0)
    {
        errorMsg = line;   // EXECUTED THIS, BUT VALUE REMAINED ""
        return true;
    }
    return false;
}

i GUESS i GOT TO debug more carefully. AND should I remove & add refernce everytime I buid the library ?

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

OriginalGriff3-Feb-11 2:30

OriginalGriff

3-Feb-11 2:30

If your library is part of the same solution as your app, then they will both be Release or Debug together: Normally I have separate solutions, and issue the release version of a library for apps to use, while I continue changes in the debug version. In your case, that doesn't apply!

If you mean that errorMsg remained empty after executing the code, could it be that the next line to be received (whether it is blank or not) starts off by setting errorMsg = ""; perhaps? Move your Console.WriteLine to immediately before the first if and see what happens.

Re: How to run a Command and retrieve data from it ?

All Time Programming3-Feb-11 2:49

All Time Programming

3-Feb-11 2:49

Both are of different solutions.

But yes, realized during debugging & removed the errorMsg = "" & connected = false lines. And now I see that errorMsg has value in it.

Implementaion PART :

                    try
                    {
                        //conThread = new Thread(new ThreadStart(StartConnect));
                        //conThread.Start();
                        StartConnect();
                    }
                    catch (ThreadAbortException te)
                    {
                        Console.WriteLine("Abort Exception CAUGHT");
                    }
                    catch (Exception ex)
                    {
                        string msg = ex.Message;
                        if (msg.Equals("NotConnectedException"))
                            MessageBox.Show("Error connecting to the Server : Connection Time Out \n Unable to connect to the Server", "Time Out", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        else if (msg.IndexOf("Cannot load CA certificate file") > 0)
                            MessageBox.Show("Error connecting to the Server : Problem with Certificate File \n Unable to Load or Find required Certificate file.", "Failed to Connect", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        else if (msg.IndexOf("Error opening 'Auth' auth file:") > 0)
                            MessageBox.Show("Error connecting to the Server : Problem with Authentication File \n Unable to Load or Find required Authentication file.", "Failed to Connect", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        else if (msg.IndexOf("Error opening configuration file:") > 0)
                            MessageBox.Show("Error connecting to the Server : Problem with Configuration File \n Unable to find required Configuration file.", "Failed to Connect", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        else
                            MessageBox.Show("Error connecting to the Server : \n " + msg, "Failed to Connect", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    }
                    finally
                    {
                        //conThread.Abort();                        
                        //Console.WriteLine("Thread ISAlive = " + conThread.IsAlive);
                    }                    
                      
                    Console.WriteLine("Execution Completed ");
//**************

        private void StartConnect()
        {
            DateTime start = DateTime.Now;

            int timeout = 100000, timepassed = 0;
            
            oc = new OpenConnect(cmd, timeout);
            int retVal = oc.ConnectToServer();
            while (!oc.Connected)
            {
                timepassed = (int)(DateTime.Now - start).TotalMilliseconds;
                if (timepassed > timeout)
                {
                    oc.DisconnectServer();
                    connectedToVpn = false;
                    throw new Exception("NotConnectedException");
                } else if (oc.ErrorMessage.Length > 0)
                {
                    Console.WriteLine("ERROR MESAGE = " + oc.ErrorMessage);  // THIS IS PRINTED
                    oc.DisconnectServer();
                    Console.WriteLine("DISCONNECTED");    // THIS IS PRINTED
                    connectedToVpn = false;
                    throw new Exception(oc.ErrorMessage);  // BUT THIS IS NEVER THROWN
                    Console.WriteLine("THROWN");
                }
                Thread.Sleep(100);
            }
            return;
        }

iT THROWS "NotConnectedException" exception when the time is over.
The OUTPUT :
LINE = Thu Feb 03 19:07:10 2011 Cannot load CA certificate file........
ERROR MESAGE = Thu Feb 03 19:07:10 2011 Cannot load CA certificate file ......
LINE = Thu Feb 03 19:07:10 2011 Exiting
DISCONNECTED
/// SEE MSGBOX OF TIME OUT I.E. OF NotConnectedException
Execution Completed

Why it doesn't throw that exception of error message ?
I ran without debugging also, increased the timeout duration, yet it waits hlds itself and throws Time out Exception only.
What can be the problem for this ?

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

OriginalGriff3-Feb-11 3:01

OriginalGriff

3-Feb-11 3:01

Reply: it is.
If it wasn't, then your output would contain the line: "THROWN" from the following statement.

Best guess: You are swallowing or ignoring the exception at a higher level.

Re: How to run a Command and retrieve data from it ?

All Time Programming3-Feb-11 3:17

All Time Programming

3-Feb-11 3:17

YES, then it should have printed "THROWN".

>> Best guess: You are swallowing or ignoring the exception at a higher level.
Didn't get you. Can you please explain it or show proper guideline to modify accordingly.

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

All Time Programming3-Feb-11 2:56

All Time Programming

3-Feb-11 2:56

You see the code of StartConnect. I think and hence wanted to add StartConnect() in a thread and catch exceptions like that, but it didn't work out.

Is it better to handle it in thread (the code that's commented) or as I have dneo is correct. If the commented is correct, then how to trap exceptions that are thrown by StartConnect or not to throw exceptions and handle them in that method only.

Please guide me for this also. I am on this issue from last 3 days, on many trials couldn't suceed. Your points are helping to suceed. Thanks a lot. I highly appreciate it. Please keep helping on this issue and help me run the code normally to its and yours best.

Thanks & Regards,

Re: How to run a Command and retrieve data from it ?

OriginalGriff3-Feb-11 3:06

OriginalGriff

3-Feb-11 3:06

From looking briefly at your code, I think you first need to read up on threads before you try moving the code: you don't seem to understand what you are trying to do and the effects it has on execution.

Read up first, and get your head round it. Then try it, and if you have problems, post a new question!

Re: How to run a Command and retrieve data from it ? [modified]

All Time Programming3-Feb-11 3:27

All Time Programming

3-Feb-11 3:27

Truly telling I read Threading tutorials of C#, but not getting such ways of threading. I mean calling method in it and such.

I get threading of Java & C++ nicely, but C# can't get in mind properly. Unsure | :~

If StartConnect is in a Thread, it cannot throw exceptions. If adding such type of code in a thread is best practice, then how to accomplish such activity as I have done. If I am wrong in my this thought, please tell me.

Without putting in thread (the current situation), its working proper & also showing exception of cannot find file only. Thanks a lot for this. Please if you can help with the above also would be great. Atleast guide, I am not asking for written code. As said, this type of threading doesn't fit proeprly in my mind, so need assistance.

Thanks & Regards,

modified on Thursday, February 3, 2011 9:38 AM

Re: How to run a Command and retrieve data from it ?

PIEBALDconsult3-Feb-11 1:44

PIEBALDconsult

3-Feb-11 1:44

Maybe this[^] is what you want.

Print Settings for ReportViewer pogrammatically

freshonlineMax2-Feb-11 18:24

freshonlineMax

2-Feb-11 18:24

Hello
I'm developing a project with C# 2010.
I want to set paper size and layout programmatically.
But it doesnt work properly.
There is no usefull document at the web.

Regards

Re: Print Settings for ReportViewer pogrammatically

Praveen Raghuvanshi2-Feb-11 19:07

Praveen Raghuvanshi

2-Feb-11 19:07

Please be specific.
Let us know what you have tried with a piece of code and what error you got.

Praveen Raghuvanshi
Software Developer

Re: Print Settings for ReportViewer pogrammatically

freshonlineMax2-Feb-11 19:46

freshonlineMax

2-Feb-11 19:46

Thank you.
I created my Report and i can see it at run time, But for printing, everytime user should open printer settings and change the paper size.
i want to set paper size at design time and print the report programmatically.
I wrote below code (doesnt work):

this.reportViewer1.PrinterSettings.DefaultPageSettings.PaperSize.Height = 1169;
this.reportViewer1.PrinterSettings.DefaultPageSettings.PaperSize.Kind = PaperKind.A4Extra;   //Error, Kind is Read-Only
this.reportViewer1.RefreshReport();

Also i couldn't find PrintReport option for ReportViewer.

[Solved] Drag'N'Drop to and on control [modified]

lukeer2-Feb-11 4:04

lukeer

2-Feb-11 4:04

Hi Experts,

there is a control derived from System.Windows.Forms.Panel that I can drop things on. The panel shows a representation of what was dropped onto it. Further, I can drag things around on that panel, moving the representation in the process.

Now I have to change that behaviour in such a way, that representations get created OnDragEnter. Customers shall move things around without having to drop them and grab them again.

Now my problem is that OnMouseMove doesn't fire during drag'n'drop operation. Therefore, panel creates a representation OnDragEnter, but refuses to move it around until user releases the left mouse button.

Does anyone know of a solution for that problem?
Can I abort a drag'n'drop operation (there's no drgevent.Cancel)?

Ciao,

luker

-- Modified Friday, February 4, 2011 6:17 AM

Re: Drag'N'Drop to and on control

Henry Minute2-Feb-11 9:25

Henry Minute

2-Feb-11 9:25

Would this[^] help with the drag image?

There's a DragAction.Cancel property. Any good?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

Re: Drag'N'Drop to and on control

lukeer4-Feb-11 0:17

lukeer

4-Feb-11 0:17

Since DragAction.Cancel belongs to
protected void OnQueryContinueDrag(QueryContinueDragEventArgs e), which is overridable, I can at this point find out, wheter to continue the drag operation and this works as expected.

Thanks a lot.

Ciao,

luker

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.