Visual Studio 2012 Exceptions

Question

2.00/5 (1 vote)

See more:

VS2012

Hi, I don't know what's going on with visual studio 2012? when I run the following code in Visual Studio 2010, it works fine as expected. but when I run the same code in Visual Studio 2012, neither it throws exception nor it notify me about the exception. can some one tell me the matter?

C#

string connectionString = "Data Source=xyz;Initial Catalog=abc;User ID=sa; Password=123; Integrated Security=true ";
           SqlConnection sqlConnection = new SqlConnection(connectionString);
           try
           {
               sqlConnection.Open();
               SqlCommand sqlCommand = new SqlCommand("SELECT COUNT(*) FROM tblProduct");
               sqlCommand.Connection = sqlConnection;

               int RecordCount = Convert.ToInt32(sqlCommand.ExecuteScalar());
           }
           catch (Exception ex)
           {
             MessageBox.Show(   ex.Message.ToString());
           }

Posted 15-Jan-13 1:16am

Faisalabadians

Updated 15-Jan-13 1:25am

v2

Add a Solution

Comments

[no name] 15-Jan-13 10:44am

Can you tell me what does your code do here?

Faisalabadians 15-Jan-13 10:57am

when control enters in "try" body and reads "sqlConnection.Open()" then there hangs for some time and after that form is shown, mean remaining code after the line "sqlConnection.Open();" is not executed.

Sergey Alexandrovich Kryukov 15-Jan-13 11:57am

It has nothing to do with Visual Studio whatsoever.
—SA

2 solutions

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)

Andreas Gieriet · Answer 1 · 2013-01-15T07:50:00

Solution 1

Maybe, this helps: Set in VisualStudio in the Debug --> Exceptions --> .Net Exception stop on throw.
Then debug the code again: the debugger will stop at the throw-location.
Cheers
Andi

Posted 15-Jan-13 7:50am

Andreas Gieriet

Jason Gleim · Answer 2 · 2013-01-15T09:08:00

Your connection is timing out.. or rather isn't timing out... and that is why the app is hanging. You are opening the connection to the server on the UI thread and it isn't able to connect to your datasource so it is making your application hang while it is trying to connect. I think the default timeout is 3 minutes... if you wait that long it should, finally, throw an exception. If you aren't that patient, you can set the ConnectionTimeout property of the sqlConnection object before you call the Open method, then the method will timeout sooner if it can't connect to the datasource.

If connectivity to your datasource will be intermittent, then you should consider moving the connection management to a non-UI thread so the delays in opening a SQL connection are hidden from the user.

As to why it can't connect, that is another issue and it is highly dependent on what you are connecting to. Unfortunately, 'xyz' doesn't tell us much so I can't help you there. :-)