How to update a dataset to reflect the added column in the data source without removing the adapter?

Question

I created a dataset using the dataset constructor, and I'm trying to add a column to reflect the changes made to the database (added column, nothing unusual). Is there a way to “update” the dataset schema from the data source without removing my adapter (and all the methods and queries that I created)?

Answer 1

I know that some time has passed since you posted, but since I had the same problem, and I figured out how to do it, I decided that I would post a solution that worked for me.

• Right-click the dataset object you want to update (in the bar at the bottom of the viewport)

• Select "Edit in Dataset Designer"

• in the dataset designer, right-click the header of the table you want to add a column to

• select configure ... this will invoke the sql statement, which is used to draw the values ​​in the dataset for this table.

• Edit sql to include the column that you want to include in the dataset table, and click Finish, that is, in the select statement, include the column name in the list

• close the data set constructor, then go to any controls (in my case it is a datagridview), click the task arrow (in the upper right corner next to the descriptor) and select add column

• select the newly created column from the list of database columns and click "add"

• select "edit columns" in the task menu

• move the column to the desired position (it will always be placed as the last column in your grid, and you may not want it to be the last column)

voila, I know that it is almost instantaneous, but it damn much deletes the data set and then fixes all the coding errors that occur ... also after that it will be like second nature several times (I hope)

considers

ps I work in VS2010

Answer 2

I just had to remove the adapter and the table. This is pretty annoying, but I think that is actually not the case. Perhaps in VS2010 or later versions of .net.