I have a DataTable that gets filled with multiple sets of records. Each set contains 5-7 records. Once the DataTable is filled, it is then bound to a BindingSource. The BindingSource has a filter applied to it "testNO = ?" (testNO represents each set of records).
I have a two DataGridView's, DGV1 contains the "testNO" and DGV2 contains a set of records which is determined by the "testNO" in DGV1.
In DGV2, there are several 2 columns that get updated. What I noticed was that when I switched to another "set" of data and then went back to the "set" that had 2 columns updated...the updates weren't there. The changes that were made....were they to the DataTable or DGV2?
What do I need to do to ensure the DataTable gets the updates? I tried using the statement "DataTable.AcceptChanges" but that didn't seem to work.