My windowform applicatioin stoped working when we execute in debugging mode

Question

0.00/5 (No votes)

See more:

Visual-Studio

ADO.NET

C#5.0

, +

application stopped working when i open in debugging mode using C#
one image are

What I have tried:

C#

private void Export()
{ 
 SaveFileDialog saveDialog = new SaveFileDialog();
            saveDialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
            saveDialog.FilterIndex = 2;

            if (saveDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                xlWorkBook.SaveAs(saveDialog.FileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
                StripStatusLabel.Visible = true;
                StripStatusLabel.Image = Image.FromFile(@"\\90.0.0.8\d\Nouman's Development\SizaPayRoll For Backup\backup\SizaPayRoll\icons\images (3).jpg");
                StripStatusLabel.ForeColor = Color.Green;
                StripStatusLabel.Text = "Increment export to excel successfully...";
                xlWorkBook.Close(true, misValue, misValue);
                xlApp.Quit();
                releaseObject(xlWorkSheet);
                releaseObject(xlWorkBook);
                releaseObject(xlApp);
            }
            else if (saveDialog.ShowDialog() == System.Windows.Forms.DialogResult.Cancel)
            {

            }
}
 private void releaseObject(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception ex)
            {
                obj = null;
                MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
            }
            finally
            {
                GC.Collect();
            }
        }

Posted 19-Dec-16 22:49pm

Siza International

Updated 20-Dec-16 0:27am

Add a Solution

Comments

Richard MacCutchan 20-Dec-16 4:59am

Sorry but we cannot guess where it stopped.

OriginalGriff 20-Dec-16 5:03am

So put a breakpoint at the top of each method, and step through until it "stops".
Then tell us what it was showing just before.
Remember we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

Siza International 20-Dec-16 5:08am

ok thanks, but i want share an image,but there is no option available

Siza International 20-Dec-16 5:11am

After stop the application my application are showing that error
An unhandled exception of type 'System.AccessViolationException' occurred in System.Windows.Forms.dll

Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

OriginalGriff 20-Dec-16 5:24am

So use the debugger and find out where it was immediately before the problem showed up.
Probably, what you have done is passed bad data, or a wrong value to Excel - but we can't help you work out which without you gathering information as we can't run your code: we don't have any access to your data!

And posting an image is not allowed - a picture of a crash message tells un nothing useful anyway!

Siza International 20-Dec-16 5:04am

Really i am also wordring...

1 solution

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)

Ralf Meier · Answer 1 · 2016-12-20T00:27:00

I only can suppose ... but I think you should change your code like this :

C#

private void Export()
{ 
 SaveFileDialog saveDialog = new SaveFileDialog();
            saveDialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
            saveDialog.FilterIndex = 2;
            DialogResult myResult = saveDialog.ShowDialog ;  // <- Changes here !!!

            if (myResult == System.Windows.Forms.DialogResult.OK)  // <- Changes here !!!
            {
                xlWorkBook.SaveAs(saveDialog.FileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
                StripStatusLabel.Visible = true;
                StripStatusLabel.Image = Image.FromFile(@"\\90.0.0.8\d\Nouman's Development\SizaPayRoll For Backup\backup\SizaPayRoll\icons\images (3).jpg");
                StripStatusLabel.ForeColor = Color.Green;
                StripStatusLabel.Text = "Increment export to excel successfully...";
                xlWorkBook.Close(true, misValue, misValue);
                xlApp.Quit();
                releaseObject(xlWorkSheet);
                releaseObject(xlWorkBook);
                releaseObject(xlApp);
            }
            else if (myResult == System.Windows.Forms.DialogResult.Cancel)  // <- Changes here !!!
            {

            }
}

... because if you get a DialogResult from the SaveFileDialog the SaveFileDialog is no more existing ...

Please try it ...