DataSet Access is throwing NullReferenceException

Question

This portion of my code is creating a nullReferenceException when I am trying to access a certain row of an Access file.





Answer 1

This portion of my code is creating a nullReferenceException when I am trying to access a certain row of an Access file.

Specifically when I try to throw the oldRow.PID on the Textbox.



PID = "123456";
oldRow = finalCoachDBDataSet1.Coach.FindByPID(PID);
Textbox_PID.Text = oldRow.PID;
Textbox_Name.Text = oldRow.Name;
Textbox_Phone.Text = oldRow.Phone;
Textbox_Description.Text = oldRow.Description;
            

Answer 2

This means that the FindByPID method doesn't return anything, i.e. the oldRow variable is a NULL reference.

You should make sure that the FindByPID method does what you expect it to do and that you have a corresponding row with the PID = "123456" in the database.