private void Form1_Shown(object sender, EventArgs e)
{
DataGridView1.SuspendLayout();
string[] fields;
// Add reference for Microsoft.VisualBasic to your project for TextFieldParser
using (var parser = new TextFieldParser(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "People.csv")))
{
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");
while (!parser.EndOfData)
{
fields = parser.ReadFields();
DataGridView1.Rows.Add(fields[0], fields[1], fields[2], string.IsNullOrWhiteSpace(fields[3]) ? "9/23/1987" : fields[3]);
}
}
DataGridView1.ExpandColumns();
DataGridView1.ResumeLayout();
}
