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.

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)