How can i check my connection string is able to open

Saqi

MySqlConnection cnn = new MySqlConnection();
                cnn.ConnectionString += @"DataBase=" + dbhosts + ";";
                cnn.ConnectionString += @"User=" + usuario + ";";
                cnn.ConnectionString += @"Password=" + senha + ";";
                cnn.ConnectionString += @"DataSource=" + hosts[count] + ";";
                if ( cnn is able to open )
                {
                    cnn.Open();
                }
                else
                {
                    MessageBox.Show("HOST:" + hosts[count].ToString() + "DATABASE:" + dbhosts.ToString() + "\n\r" + "Recheck connection");
                }

before open i need to know if it right connection How?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
The only thing I can suggest is that you use a try/catch statement and catch the exception thrown if the connection cannot be opened for some reason:

using (MySqlConnection cnn = new MySqlConnection())
{
cnn.ConnectionString += @"DataBase=" + dbhosts + ";";
cnn.ConnectionString += @"User=" + usuario + ";";
cnn.ConnectionString += @"Password=" + senha + ";";
cnn.ConnectionString += @"DataSource=" + hosts[count] + ";";
try
{
cnn.Open();
}
catch(MySqlException e)
{
MessageBox.Show(e.Message + "\r\n\r\n" + "HOST:" + hosts[count].ToString() + "DATABASE:" + dbhosts.ToString() + "\r\n" + "Recheck connection");
}
}
Saqi14y ago
thanks i got it