How to fix a value not found exception in MySQL in C#?

Question

MySQL

There is this code:

string login = "serega404"; // если в базе нет этого ника то мы получаем исключение
           string CommandText = "SELECT money FROM  users WHERE login = '" + login + "'";
            string Connect = "Database=bd;Data Source=localhost;User Id=root;Password=;SslMode=none";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);
            myConnection.Open(); 
            string money = myCommand.ExecuteScalar().ToString();
            myConnection.Close();
            return money;

Answer 1

Well, use try...catch...finally , something like this

try
    {
        string login = "serega404"; // если в базе нет этого ника то мы получаем исключение
           string CommandText = "SELECT money FROM  users WHERE login = '" + login + "'";
            string Connect = "Database=bd;Data Source=localhost;User Id=root;Password=;SslMode=none";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);
            myConnection.Open(); 
            string money = myCommand.ExecuteScalar().ToString();
            myConnection.Close();
            return money;
    }
    catch (Exception ex)
    {
        Console.WriteLine("Ахтунг, нету такого: " + ex.Message);
    }