"NullReferenceException was unhandled" when Assigning DataTable to DataGridView

Question

On the line that includes dgdMain.DataSource = dt;, I am getting a "NullReferenceException was unhandled" error. I have tried to find a solution and I'm sure it's simple but I am clearly missing it. Thanks for any input.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Dashboard
{
    public partial class frmMain : Form
    {
        public frmMain()
        {
            BindingSource bindingSource = new BindingSource();
            DataTable dt = Program.GetDataTableFromCSV("../../res/sampledata.csv");
            dgdMain.DataSource = dt;

            InitializeComponent();

        }
    }
}

... and here is GetDataTableFromCSV():

public static DataTable GetDataTableFromCSV(string path)
{
    DataTable dataTable = new DataTable();
    String[] values;

    values = File.ReadAllLines(path);

    string[] csvRows = System.IO.File.ReadAllLines(path);
    string[] headers = csvRows[0].Split(',');

    // Adding columns name
    foreach (var item in headers)
        dataTable.Columns.Add(new DataColumn(item));

    string[] fields = null;

    foreach (string csvRow in csvRows)
    {
        //Debug.Write(csvRow+"\r\n");
        fields = csvRow.Split(',');
        DataRow row = dataTable.NewRow();
        row.ItemArray = fields;
        dataTable.Rows.Add(row);
    }

    return dataTable;
}

Why do you create a BindingSource in the constructor that you never use? And why do you execute File.ReadAllLines(path) twice in GetDataTable...,(values is also never used)? — Tim Schmelter
– Tim Schmelter, Commented Jun 26, 2013 at 22:08
First call InitializeComponent() and then you can use dgdMain. — Adriano Repetti
– Adriano Repetti, Commented Jun 26, 2013 at 22:08
In addition, CSV files have the potential to have commas inside actual values and thus splitting on the ',' is not the best idea. Refer to stackoverflow.com/questions/2081418/… — chancea
– chancea, Commented Jun 26, 2013 at 22:10

Azhar Khorasany · Accepted Answer · 2013-06-26 22:09:44Z

4

InializeComponent must be on top. It should be like this:

    public frmMain()
    {
        InitializeComponent();

        BindingSource bindingSource = new BindingSource();
        DataTable dt = Program.GetDataTableFromCSV("../../res/sampledata.csv");
        dgdMain.DataSource = dt;
    }

answered Jun 26, 2013 at 22:09

Azhar Khorasany

2,70919 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:17:00Z

2

dgdMain is null and that's why it's throwing a NullReferenceException.

You have to use it after calling InitializeComponent.

Also, have a look at this link. What is a NullReferenceException, and how do I fix it?

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Jun 26, 2013 at 22:08

Fabian Bigler

10.9k6 gold badges52 silver badges74 bronze badges

Collectives™ on Stack Overflow

"NullReferenceException was unhandled" when Assigning DataTable to DataGridView

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related