Unable to write to file using csvHelper C#

Question

I am not able to write to a file using the CsvHelper and receive the following error at line: foreach (CSV3 sa in cSV3BindingSource.DataSource as List<CSV3>):

System.NullReferenceException: 'Object reference not set to an instance of an object.'
(... as System.Collections.Generic.List) returned null.

private void Save_Click(object sender, EventArgs e)
{
    using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "CSV|*.csv", ValidateNames = true })
    {

        if (sfd.ShowDialog() == DialogResult.OK)
        {
            using (var sw = new StreamWriter(sfd.FileName))
            {
                var writer = new CsvWriter(sw);
                writer.WriteHeader(typeof(CSV3));

                foreach (CSV3 sa in cSV3BindingSource.DataSource as List<CSV3>) 
                {             
                    writer.WriteRecord(sa);
                }
            }
            MessageBox.Show("File has been saved", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);

        }
    }
}

I'm not sure what is causing that null reference exception.

Then `cSV3BindingSource.DataSource` might not contain an instance of type `List` (assuming DataSource itself is not null). Fix that first. — rene, Nov 19 '17 at 13:41
CSv3 is an additional class with some string properties as the headers. Thanks. — Sama, Nov 19 '17 at 13:48
You are not showing us what is or where DataSource it's being loaded. The above code does not reproduce the error. — Daniel Manta, Nov 19 '17 at 15:22

Unable to write to file using csvHelper C#

0 Answers0