C#

Member 13070736 wrote:

that seems like way too much effort just to slot an array into textboxes.

Quote:

The need for a collection of TextBox Controls functioning as a kind of logical unit for inputting/validating a set of data is very common. I prefer to implement this in a UserControl (or Panel) that implements validation, provides options for either sequential entry, random entry, etc. ... or, in a Form shown as a Dialog.

using System;
using System.Collections.Specialized;
using System.Windows.Forms;
using System.Collections.ObjectModel;

namespace YourNameSpace
{
    public class MapIntsToTextBoxes : ObservableCollection<int>
    {
        public MapIntsToTextBoxes(params int[] ints)
        {
            // initialize the collection
            foreach (int i in ints)
            {
                this.Add(i);
            } 
        }
    }
}

using System;
using System.Collections.Specialized;
using System.Windows.Forms;
using YourNameSpace;

namespace YourWinFormProject
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private List<TextBox> TBoxes = new List<TBoxes>{
            textBox10,
            textBox11,
            textBox12,
            textBox13,
            textBox14
        };

        // construct and initialize
        private MapIntsToTextBoxes mapper = new MapIntsToTextBoxes(1,2,3,4,5);

        private void Form1_Load(object sender, System.EventArgs e)
        {
            mapper.CollectionChanged += MapperOnCollectionChanged;

            // change a vakue
            mapper[3] = 1000;
        }

        private void MapperOnCollectionChanged(object sender, NotifyCollectionChangedEventArgs e)
        {
            switch (e.Action)
            {
                case NotifyCollectionChangedAction.Replace:
                    TBoxes[e.OldStartingIndex].Text = e.NewItems[0].ToString();
                    break;
                case NotifyCollectionChangedAction.Add:
                    break;
                case NotifyCollectionChangedAction.Remove:
                    break;
                case NotifyCollectionChangedAction.Move:
                    break;
                case NotifyCollectionChangedAction.Reset:
                    break;
            }
        }
    }
}

Member 13070736 wrote:

that seems like way too much effort just to slot an array into textboxes.

Luc Pattyn wrote:

When your user interface requires a large number of Controls you probably should rethink your design

Luc Pattyn wrote:

Of course having several TextBoxes isn't automatically wrong, or bad design; it may even be the right choice. Showing code for five, plus ellipsis, made me produce a warning.

TextBox tbs[] = { textBox10, textBox11, ..., textBox99 };
Object arr[tbs.Length];
for (int i = 0; i < tbs.Length; i++)
    tbs[i].Text = arr[i].ToString();

TextBox tbs[] = { textBox10, textBox11, ..., textBox99 };
Object arr[tbs.Length];
int i = 0;
foreach (TextBox tb in tbs)
      tb.Text = arr[i++].ToString();

Rick_Bishop wrote:

they would be "pissed" if a variable was used in a method, that wasn't passed into it.

Rick_Bishop wrote:

because I use long variable names

Rick_Bishop wrote:

public T ExecuteScalar<T>(string queryString, string connection_string)

private OleDbCommand CreateCommand(OleDbConnection connection, string queryString, object[] parameters)
{
    var command = new OleDbCommand("", connection);
    
    if (parameters != null && parameters.Length != 0)
    {
        // OleDb doesn't use named parameters, so convert them to positional:
        queryString = Regex.Replace(queryString, @"\{(\d+)\}", match =>
        {
            int index = int.Parse(match.Groups[1].Value);
            object value = parameters[index];
            string name = "@p" + command.Parameters.Count;
            command.Parameters.AddWithValue(name, value);
            return "?";
        });
    }
    
    command.CommandText = queryString;
    return command;
}

public T ExecuteScalar<T>(string queryString, params object[] parameters)
{
    using (OleDbConnection connection = new OleDbConnection(connection_string))
    using (OleDbCommand command = CreateCommand(connection, queryString, parameters))
    {
        var result = cmd.ExecuteScalar();
        if (Convert.IsDBNull(result)) return default(T);
        return (T)result;
    }
}

private void SomeMethod(string zipCode)
{
    var zipcode = ExecuteScalar<string>("select zipcode from Zipcodes where Zip = {0}", zipCode);
    ...
}