Member Avatar for jalmeida

Im puzzled, the thing is, i have a software that was running ok, with a connection of to access 2010 db. A rotine to add a customer, to the database that was already coded, started to fail. saing that the insert method of the tableadapter was not avalaible. the tableadapter is ok, and it retrieves the data without any problems. WTF is going on. There is another tableadapter that works fine and the coding is the same.The strange thing is that the fill, getdata, etc is avalaible.

me.militarestableadapter.insert(idor,nom,mat)                            ^




                        |
          insert is not a member of dataset
Edited by jalmeida
  • 2 Contributors
  • 4 Replies
  • 196 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by G_Waddell
Member Avatar for G_Waddell

Hi,

Have you defined an Insert command for the Adaptor? Have you checked the syntax of the command by running it in your database?

Member Avatar for jalmeida

Sorry i didn't understand, defined an insert command? what do you mean? I'Sorry but i'm new to these situations. The only thing that i did was changing the structure of the table?

Member Avatar for jalmeida

Situation solved, thank for your help in showing the way g.wadell.
When i changed the structure of the table it created a second table called militares1, and for that reason the tableadapter did not know where to insert the data. I've delete the table from the datasource, and added again and the problem was solved.

Member Avatar for G_Waddell

Glad I could help - I think...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.