Updating DataSet
-
I want to bind a table in my access database to a datagridview control in my application. I have created a dataset, and bind the table successfully to my datagridview. Now I want to add two new columns to the table in database. I have updated the data table of both dataset and access database, however, the changes are not reflected in the datagridview, as I added two new columns into datagridview, I can not see the two fields I just added to the dataset when I try to set DataPropertyName field. Datagridview control still binds to the old dataset even though the dataset has been changed. The only way Ive found to update the datagridview is to delete the dataset and create a new one base on the updated database. Is there a way to update the dataset automatically without deleting the old dataset? Thanks in advance:)
-
I want to bind a table in my access database to a datagridview control in my application. I have created a dataset, and bind the table successfully to my datagridview. Now I want to add two new columns to the table in database. I have updated the data table of both dataset and access database, however, the changes are not reflected in the datagridview, as I added two new columns into datagridview, I can not see the two fields I just added to the dataset when I try to set DataPropertyName field. Datagridview control still binds to the old dataset even though the dataset has been changed. The only way Ive found to update the datagridview is to delete the dataset and create a new one base on the updated database. Is there a way to update the dataset automatically without deleting the old dataset? Thanks in advance:)