C#

OriginalGriff wrote:

You get into your car, and put your phone in the glove box. Then you buy a new car. Would you expect your phone to be in the new car's glove box?

int Fib(int n) => n > 1 ? Fib(n - 1) + Fib(n - 2) : n;
Console.WriteLine(Fib(6)); // displays 8

(Of course, the best solution for calculating Fibonacci numbers is to avoid recursion. )

Member 13325846 wrote:

i have to sort them in my database

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 13325846 wrote:

new OleDBCammand(“Select *From[“+txtBox1.Text+”]”,con)

public class ControlUpdater<TControl, TValue> : IReadOnlyList<TValue>
{
    private readonly List<(TControl control, TValue value)> _items = new List<(TControl, TValue)>();
    private readonly Func<TControl, TValue, bool> _setValue;
    
    public ControlUpdater(Func<TControl, TValue, bool> setValue, IEnumerable<(TControl, TValue)> items)
    {
        _setValue = setValue ?? throw new ArgumentNullException(nameof(setValue));
        if (items != null) AddRange(items);
    }
    
    public ControlUpdater(Func<TControl, TValue, bool> setValue, params (TControl, TValue)[] items) : this(setValue, items.AsEnumerable())
    {
    }
    
    public ControlUpdater(Func<TControl, TValue, bool> setValue, IEnumerable<TControl> items)
    {
        _setValue = setValue ?? throw new ArgumentNullException(nameof(setValue));
        if (items != null) AddRange(items);
    }
    
    public ControlUpdater(Func<TControl, TValue, bool> setValue, params TControl[] items) : this(setValue, items.AsEnumerable())
    {
    }
    
    public ControlUpdater(Func<TControl, TValue, bool> setValue) : this(setValue, default(IEnumerable<(TControl, TValue)>))
    {
    }
    
    public void AddRange(IEnumerable<(TControl, TValue)> items) => _items.AddRange(items);
    
    public void AddRange(IEnumerable<TControl> items, TValue value = default(TValue)) => _items.AddRange(items.Select(c => (c, value)));
    
    public void Add((TControl, TValue) item) => _items.Add(item);
    
    public void Add(TControl control, TValue value = default(TValue)) => _items.Add((control, value));
    
    public void Insert(int index, (TControl, TValue) item) => _items.Insert(index, item);
    
    public void Insert(int index, TControl control, TValue value = default(TValue)) => _items.Insert(index, (control, value));
    
    public void RemoveAt(int index) => _items.RemoveAt(index);
    
    public int Count => _items.Count;
    
    public TValue this[int index]
    {
        get 
        {
            var (_, value) = _items[index];
            return value;
        }
        set 
        {
            var (control, _) = _items[index];
            if (_setValue(control, value))
            {
                _items[index] = (control, value);
            }
        }
    }
    
    public IEnumerator<TValue> GetEnumerator()
    {
        foreach (var (_, value) in _items)
        {
            yield return value;
        }
    }
    
    IEnumerator IEnumerable.GetEnumerator() => GetEnumerator();
}

var tba = new ControlUpdater<TextBox, int>(
    (tbx, value) =>
    {
        tbx.Text = value.ToString();
        return true;
    });

var controls = Enumerable.Range(0, 5).Select(i => new TextBox { Name = $"Ints{i + 10}" });
tba.AddRange(controls);

tba[3] = 1000;     // as expected
var xxx = tba[3];  // as expected

was also slightly confused by the value stored in the list, until I realised it was meant to be the value of the control at the specified index. It would probably be better to make that a generic type parameter as well.

BillWoodruff wrote:

Good idea ? Bad idea ?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

I'd compare it to classical databinding; a oneliner that doesn't generate the UI (textBox1.Bindings.Add