C# Inserting last 5 lines from a .csv file into datagrid

Question

I am trying to pull that last 5 lines from a .csv file and display them in a datagrid on my form. How would I insert the data onto the datagrid?

Here is my current Code,

        int x = 5;   
        var buffor = new Queue<string>(x);

        var log = new StreamReader(@"MyPath");

        while (!log.EndOfStream)
        {
            string line = log.ReadLine();

            if (buffor.Count >= x)
                buffor.Dequeue();
            buffor.Enqueue(line);
        }

        string[] lastLines = buffor.ToArray();

Thanks in advance.

score 1 · Accepted Answer · answered Oct 12 '16 at 02:14

1

You can do this,

 public Form1()
        {
            InitializeComponent();
            int x = 5;
            var buffor = new Queue<string>(x);
            foreach (var headerLine in File.ReadLines("C:/NewMap.csv").Take(1))
            {
                foreach (var headerItem in headerLine.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries))
                {
                    dataGridView1.Columns.Add(headerItem.ToString().Trim(), headerItem.ToString());
                }
            }
            var log = new StreamReader("C:/NewMap.csv");

            while (!log.EndOfStream)
            {
                string line = log.ReadLine();

                if (buffor.Count >= x)
                    buffor.Dequeue();
                buffor.Enqueue(line);
            }

            foreach (var line in buffor)
            {
                if (line != string.Empty || line != string.Empty)
                {
                    dataGridView1.Rows.Add(line);
                }
            }
        }

answered Oct 12 '16 at 02:14

Sajeetharan

216,225
63
350
396

Is it possible to keep the same amount of columns? My csv file has eight columns of info, when inserted to datagrid it combines into one – Shadow89 Oct 12 '16 at 02:24
1

Yes you can have, just define it in the datagrid, mark as answer if it has helped – Sajeetharan Oct 12 '16 at 02:24
how would I define it in the datagrid, I am very new to datagrids, sorry – Shadow89 Oct 12 '16 at 02:29
1

It will be something like this dataGridView1.Columns.Add("Column1", "Age"); – Sajeetharan Oct 12 '16 at 02:30
1

Check this answer http://stackoverflow.com/questions/14157153/faster-way-of-reading-csv-to-grid – Sajeetharan Oct 12 '16 at 02:32
would I just use the split on line? – Shadow89 Oct 12 '16 at 02:34
1

@Shadow89 you can defined the columns initially and then it is a matter of assigning the datagrid source – Sajeetharan Oct 12 '16 at 02:35
I already had the columns defined, but it just pushed them over – Shadow89 Oct 12 '16 at 02:36
1

can you give me teamviewer? – Sajeetharan Oct 12 '16 at 02:39
I'm sorry I do not know what that is – Shadow89 Oct 12 '16 at 02:39
I used your code above and put in my paths, and it finds the info and puts it into one column, I just need to know with the code you supplied above, how do I spit the information into my predefined columns? – Shadow89 Oct 12 '16 at 02:46

C# Inserting last 5 lines from a .csv file into datagrid

1 Answers1