[RESOLVED] No TableAdapter on the data table

[DavidGraham167]

I have an existing database from an old project.
I have created a new data table with designer by right clicking and saying create data table.
I have added and edited the columns. The table & colums are shown on the Data Sources tab.
I now want to add a TableAdapter. I'm not sure how to do it.
In the server exporer the new table is not shown.
If I select TableAdapter from the toolbox it is asking to specify the table but it is not in the server exporer - but it is in the data sources.

Thanks for your help.

[DavidGraham167]

I should have created the table in the SQL server manager first.
Then in Visual Studio with the desiner window, I could drag the table from the ServerExplorer onto the designer - it then has the data table and the table adapter.