vb.net - How to update the Dataset to reflect an added column in the data source without deleting the adapter? -

I have created a dataset using the dataset designer, and I'm trying to add a column database (added one column Gone, nothing fancy). Is there a way to 'refresh' the dataset schema from the data source without removing your adapter (and all the ways and questions I have created)?

I know that it has been a while since you posted, but like That I had the same problem and found out how to do it, I believe that I will post a solution that works for me.

1. You want to update that update on the dataset object (at the bottom of your view bar)

2. "Dataset Edit in

3. In the dataset designer, click on the top of the table that you want to add to the column

4. Configure Configure. .. this will bring the SQL statement which is used to attract values ​​in the dataset for this table

5. To include the column to include the column in which you want to include the table of your dataset and click Finish, select your column name in the list, select

6. Close the dataset designer For any control (in my case it's a datagrid view), click the arrow on the task arrow (click the upper right hand corner of the handle) and add the column

7. newly created From the list of databbound columns in the column and click on "Add"

8. Select "Edit columns" from the task menu

9. Move the column in the correct position (this will always be placed as the last column in your grid and you can not make it the last column)

   Voice, I know it Hard to fast, but it is beating hell to remove the dataset and then cure all the coding errors ... I'm also doing it second nature (I would like to hope)

   As regards work

   ps VS2010 After