C# Catching Error while connecting to MySQL

Question

0.00/5 (No votes)

See more:

Hello, here's the scenario, when im trying to use my program to other network and that PC doesnt have internet connection, I want to catch the error as soon as possible, that will prompt that the user isn't connected to any network, coz now its throwing that it doesnt connect to MySql, and sometimes it waits and hangs to wait for the connection" i Hope someone can help me with this, BTW im using MysqldataReader to Login

Posted 17-Dec-15 13:43pm

Rencyrence

Add a Solution

Comments

PIEBALDconsult 17-Dec-15 20:51pm

I'd just stick with saying that it can't connect to the database and not care about why. Often the Exceptions will provide more detail anyway.

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)

Edgar105 · Answer 1 · 2015-12-17T13:58:00

Solution 1

Since you need to check if there is a conection, you can use an if statement to do that, if so, proceed; otherwise show a message to avoid the hangup, use

VB

My.Computer.Network.IsAvailable()

Posted 17-Dec-15 13:58pm

Edgar105

Comments

Rencyrence 17-Dec-15 20:23pm

How can i use this? please elaborate

Edgar105 18-Dec-15 13:09pm

for example:

if My.Computer.Network.IsAvailable() then
'do all your initialization and conection procedure, etc
else
'show a message to the user there is no connection
'don´t start the mysql connection so the program does not freeze catching the error trying to connect
MessageBox.show("An internet connection is required to continue")
end if