How to refresh existing TableAdapter at design time after I added new field to existing table in database?

Question

Sam Hobbs · Answer

I am sorry but I don't understand what you are trying to say about not seeing the field in the list of sources. Perhaps it just need to be refreshed.

ado net · Answer

Thank you Sam and Mahech. It works. Problem that I see now - with DataTable (above TableAdapter in Designer). I pressed Configure... and updated SQL (added new field name). After this I can see my new field in the fields' list in DataTable. But if I stay (press mouse in DataTable Designer) on this field I look to the Properties window -> Source. Value in this property is correct. But if I try see list of sources (I press on combo in value cell) - I CAN'T see my new field. Do you now reason? (It seems worked now - but a bit strange on design).

Mahesh Chand · Answer

Yes Sam is correct. Try to reconfigure the TableAdapter and add a new field in the query. It will update the query and related code.

Sam Hobbs · Answer

I know I have done it but I forget how. Try configuring the TableAdapter and changing the SQL to add the field. You can use the Query Bulder to make it easier.