C# - csv to form text-fields (copy and paste)

Question

I have form:

and a csv file containing these values:

110977,3871933,317731,0,

How would I be able to copy the CSV data and paste it into all the correct fields in one copy and paste action? (All the data will be in the correct order)

Thanks in advance!

Answer 1

I would suggest reading the CSV file by opening it, then split by comma, put your values into the string array and then update your textBoxes. Refer to the answer to this question. You can also use OpenFileDialog to provide the UI for opening the file.

EDIT:

I prepared some basic example to handle exactly the case you asked for. It assumes you have 4 values in the copied CSV line separated by comma (anyway if you have more than 4 in copied line just first 4 will be put into textBoxes). It only requires to copy the CSV line and paste it using Ctrl + V into the first textBox (txtValue1) so it is then splitted by , and all those values from copied CSV line are put into corresponding textBoxes (txtValue1, txtValue2, txtValue3, txtValue4 consecutively).

My form looks just like that:

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

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            txtValue1.KeyDown += TxtValue1_KeyDown;
        }

        private void TxtValue1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.Control && e.KeyCode == Keys.V)
            {
                string csvLine = Clipboard.GetText();
                if (String.IsNullOrEmpty(csvLine))
                    return;
                string[] values = csvLine.Split(',');

                if (values.Count() < 4)
                    return;

                txtValue1.Text = values[0];
                txtValue2.Text = values[1];
                txtValue3.Text = values[2];
                txtValue4.Text = values[3];

                e.SuppressKeyPress = true;
            }
        }
    }

It could of course be made more generic and handle possible exceptions. This is only to show how to solve what you need easily.

Answer 2

Copy/Pasting? More like reading CSV from a stream ?

Create a Model aka a class to store the values once you start reading the CSV using any sort of stream reader. As you read the positions of the fields from the CSV you can start storing them into your model and then it is easy from there. You might want to think about reading everything into a List, so you only read once.

Here is your class

public class Model
{
    public string InvoiceNumber { get; set; }
    ...
}

Here is the CSV reading piece

        using (StreamReader sr = new StreamReader(sourceFileName))
        {
            List<Model> modelList = new List<Model>();
            string headerLine = sr.ReadLine();
            string currentLine;
            for (int i = 0; i < strArray.Length; i++)
            {       
                while ((currentLine = sr.ReadLine()) != null)
                {
                 string[] strArray = currentLine.Split(',');
                 Model myModel = new Model();

                 switch (i)
                    {
                        case 0: myModel.InvoiceNumber =  = strArray[i]; break;
                        case 1: myModel.InvoiceHeaderId = strArray[i]; break;
                    }
                }
            }
         modelList.Add(myModel);
        }

        }

From Here you can assign this to the UI.It depends which row you want to read, maybe filter the result to get the id, or filter my other pieces of data. Up to you to decide, you can add those filters in the for each loop. Or even better, take a look at LINQ. :D

foreach (var item in modelList)
{
    txtInvoiceNumber.Text = mymodel.InvoiceNumber;
    txtinvoiceHeaderId.Text = mymodel.InvoiceHeaderId;


}