How to load a datagridview with a text file that was saved using StreamWriter

Question

I was trying to use streamreader to achieve this but I don't know how to make it work. I tried several different things but no luck. The text file was made from the same amount of datagridview columns. Overall what I am trying to do is save a selected row and append it to the file from one datagridview on one form then load that saved file into another datagridview on form2 to be displayed as histoy. Thanks in advance for you help!
I'm new to the form and my code didn't display properly sorry.

Ok here is the code I used to save to the file...

private void button4_Click(object sender, EventArgs e)
{
    string location = @"C:\Users\lee\Lees Test File\testfile3.txt";
    StreamWriter myWriter = new StreamWriter(location, true);
    for (int j = 0; j < dataGridView1.Columns.Count; j++)
    {
        myWriter.Write(dataGridView1.Rows[selectedRow].Cells[j].Value.ToString() + "|");
    }
    myWriter.Close();
    MessageBox.Show("File Saved!");
}

This is the datagridview that I want to send file to...

put the columns in it...then use this https://stackoverflow.com/questions/1166272/efficient-function-for-reading-a-delimited-file-into-datatable — Ctznkane525, Jul 07 '18 at 16:12
Possible duplicate of [Efficient function for reading a delimited file into DataTable](https://stackoverflow.com/questions/1166272/efficient-function-for-reading-a-delimited-file-into-datatable) — Ctznkane525, Jul 07 '18 at 16:12

Dhanushka Dayawansha · Answer 1 · 2018-07-08T10:10:13.673

form load:

 private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

        }

button click event:

 private void button4_Click(object sender, EventArgs e)
        {
            string location = @"C:\Users\lee\Lees Test File\testfile3.txt";
            StreamWriter myWriter = new StreamWriter(location, true);

            foreach (DataGridViewRow row in dataGridView1.SelectedRows)
            {
                for (int j = 0; j < dataGridView1.Columns.Count; j++)
                { 
                myWriter.Write(row.Cells[j].Value.ToString() + "|");
                }
            }
            myWriter.Close();
            MessageBox.Show("File Saved!"); 
        }

score 0 · Answer 2 · answered Jul 23 '18 at 17:08

    private void mySreamReader()
    {
        try
        {
            dataGridView1.Rows.Clear();

            StreamReader streamReader = new StreamReader (@"C:\Users\lee\Lees App File\LeesHistoryFile.txt");
            dataGridView1.AllowUserToAddRows = false;
            string text = "";
            for (text = streamReader.ReadLine(); text != null; text = streamReader.ReadLine())
            {

                    string[] array = text.Split(new char[] { '|' });
                    dataGridView1.Rows.Add(array);

            }
            streamReader.Close();

        }
        catch (Exception err)
        {
            MessageBox.Show("Error" + err.Message);
        }

    }

How to load a datagridview with a text file that was saved using StreamWriter

2 Answers2