Capture error when click button

Question

I want to make a button that when it is clicked is shown the information of SQL Server and say that it is connected (have to configure the file in XML Configuration File)

See below the code:

public class Functions
{
    public static void conn()
    {
        string connectionString = Conn.tank();
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            bool Open = true;
            if (Open)
            {
                connection.Open();
                Globals.UpdateLogs("Conexão testada:");
                Globals.UpdateLogs("Status da Conexão : " + connection.State);  //info
                Globals.UpdateLogs("User : " + connection.WorkstationId);  //info
                Globals.UpdateLogs("Banco de dados : " + connection.Database);  //info
                Globals.UpdateLogs("Versão SQL : " + connection.ServerVersion); //info
            }
            else
            {
                Globals.UpdateLogs("O programa não está conectado em sua DataBase, verifique as configurações");
            }

        }
    }

In case it works right when you press the button and the data are right it says the most settings when SQL Server data is wrong, it stops working the program.

I took a code already ready I’m just trying to make it better, but I can’t do "If the data is wrong show the message".

Answer 1

I’m not sure I quite understand what you want and not even if that code makes sense, but that’s kind of what I think you want:

public class Functions {
    public static void conn() {
        string connectionString = Conn.tank();
        var connection = new SqlConnection(connectionString);
        try {
            connection.Open();
            Globals.UpdateLogs("Conexão testada:");
            Globals.UpdateLogs("Status da Conexão : " + connection.State);
            Globals.UpdateLogs("User : " + connection.WorkstationId);
            Globals.UpdateLogs("Banco de dados : " + connection.Database);
            Globals.UpdateLogs("Versão SQL : " + connection.ServerVersion);
        } catch (SystemException ex) {
            if (ex is InvalidOperationException || ex is SqlException || ex is ConfigurationErrorsException) {
                Globals.UpdateLogs("O programa não está conectado em sua DataBase, verifique as configurações");
            }
        } finally {
            if (connection != null) {
                ((IDisposable)connection).Dispose();
            }
        }
    }
}

I put in the Github for future reference.

Surely you have better ways of doing that, but you’d have to think about design as a whole.

For C# 5 or earlier:

public class Functions {
    public static void conn() {
        string connectionString = Conn.tank();
        var connection = new SqlConnection(connectionString);
        try {
            connection.Open();
            Globals.UpdateLogs("Conexão testada:");
            Globals.UpdateLogs("Status da Conexão : " + connection.State);
            Globals.UpdateLogs("User : " + connection.WorkstationId);
            Globals.UpdateLogs("Banco de dados : " + connection.Database);
            Globals.UpdateLogs("Versão SQL : " + connection.ServerVersion);
        } catch (InvalidOperationException ex) {
            Globals.UpdateLogs("O programa não está conectado em sua DataBase, verifique as configurações");
        } catch (SqlException  ex) {
            Globals.UpdateLogs("pode por uma mensagem mais específica aqui");
        } catch (ConfigurationErrorsException ex) {
            Globals.UpdateLogs("pode por uma mensagem mais específica aqui");
        } finally {
            if (connection != null) {
                ((IDisposable)connection).Dispose();
            }
        }
    }
}