1

I have a dataset that uses an access .mdb database. How do I synchronize the dataset when I make changes to the access database?

Edit: I mean: if I add a table or change its structure in the Access mdb, the DataSet in Visual Studio does not update. I've tried the Refresh menu item, but I still see the old structure.

IfThenElse
  • 485
  • 5
  • 13
  • Not sure if you are talking about typed dataset. See this answer https://stackoverflow.com/questions/9497689/update-dataset-structure-in-visual-studio-to-match-new-sql-database-structure/9497756#9497756 – Steve Feb 20 '21 at 16:11
  • I mean: if I add a table or change its structure in the access mdb, the DataSet in Visual Studio does not update. I've tried the Refresh menu item, but I still see the old structure. – IfThenElse Feb 20 '21 at 16:15

1 Answers1

0

Because the dataset and the information in it that is available in the visual studio, is a copy of mdb file information. that can be sent to the dataset or from the dataset to mdb by sqlDataAdapter. For this reason, the edited information in the mdb file is not displayed in the program, because after editing, the information must be retrieved by the dataset from mdb file.

sorry for my English...

Amirhossein Azhdari
  • 170
  • 1
  • 3
  • 20