Typed Dataset - Access Table Adapters

Matthew Norman

I have created a typed dataset but I cant seem to access the table adapters that it automatically creates. I can access the dataset and tables but not this. Can anyone advise how I would do this?

6 Replies

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

Sam Hobbs16y ago
Matthew, I agree that TableAdapters are not adequately documented; it can be frustrating.
0
16y ago
Can you see what is the namespace is present in the *.designer.cs file. ?
For me I am getting namespace like WindowsFormsApplication1.DataSet1TableAdapters
Please chceck the *.designer.cs file.
Hope this helps you.
0
16y ago
Can see what is the namespace is present in the *.designer.cs file. ?
For me I am getting namespace like WindowsFormsApplication1.DataSet1TableAdapters
Please chceck the *.designer.cs file.
Hope this helps you.
0
Matthew Norman16y ago
Problem solved. I did a search through the solution for the name of the adapter and found that the correct namespace was "AutoClaim.Data.AutoClaimDataSetTableAdapters" and not just AutoClaimDataSetTableAdapters.
0
Matthew Norman16y ago
This doesn't really explain my problem. I know how to use the tableadapter but I cant create a new instance of the tableadapters. From looking at tutorials if my data set is called AutoClaimDataSet then I would add a using directive "using AutoClaimDataSetTableAdapters and then I would be able to access them but I get an error saying that the namespace doesnt exist.
0
16y ago
http://blogs.msdn.com/b/bethmassi/archive/2009/05/14/using-tableadapters-to-insert-related-data-into-an-ms-access-database.aspx
Hope this helps you.
0