//*c# *code
//Скажите, разве здесь что-то выглядит неправильно?
        public int TimeBalance(string login1)
        {
            MySqlConnection con = new MySqlConnection(connStr);
            try {

                string sql = (@"select time_balance from time_used where user_id = (@id);");
                MySqlCommand cmd = new MySqlCommand(sql);
                cmd.Parameters.AddWithValue("@id",login1);
                cmd.Connection = con;
                con.Open();
                balance = int.Parse(cmd.ExecuteScalar().ToString());
                cmd.Connection.Close();
            }
            catch (MySqlException){
                throw new MySqlException();
            }
            finally {
                //con.Close();
                con.Dispose();
            }
            //BalanceMinus(login);
            return balance;
        }
    public void BalanceMinus(string login1, int newBalance)
        {
            //this.login = login;
            //balance--;
            MySqlConnection con = new MySqlConnection(connStr);
            try
            {
                string myQuery = "UPDATE time_used SET time_balance = @balance WHERE user_id = @id;";
                MySqlCommand cmd = new MySqlCommand(myQuery);
                cmd.Parameters.AddWithValue("@balance",newBalance.ToString());
                cmd.Parameters.AddWithValue("@id",login1);

                cmd.Connection = con;
                con.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
            }
            catch (MySqlException) {
                MessageBox.Show("5 C40;>AL A2O70BLAO A A5@25@>< ");
                MainForm.ActiveForm.Activate();
            }
            finally {
               con.Dispose();
            }
        }