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

ado net

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
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.
0
ado net16y ago
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).
0
Mahesh Chand16y ago
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.
0
Sam Hobbs16y ago
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.
0