I have a datagrid on a form with controls to allow the adding of a new record to the database. The adding process works fine, except that after I click the Save button, the grid doesn't reflect the new item (if it's on the same page currently shown) unless I flip pages in the datagrid away from and back to that page. I want to make the grid automatically update itself to show the new record. Here's my code:
DBGrid1.DataSource = DS_UserSetup1
So once the new record is saved to the database, then the dataset is told to accept the changes. Afterwards, I refill the dataset, reset the datasource for the grid and tell it to bind again. But this apparently doesn't make the control refresh. I still have to flip to the next page and then back in the datagrid to see the new record.