1,105,423 Community Members

I'm puzzled

Member Avatar
jalmeida
Newbie Poster
11 posts since Oct 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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
Member Avatar
G_Waddell
Practically a Posting Shark
821 posts since Nov 2009
Reputation Points: 131 [?]
Q&As Helped to Solve: 137 [?]
Skill Endorsements: 13 [?]
 
0
 

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
jalmeida
Newbie Poster
11 posts since Oct 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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
jalmeida
Newbie Poster
11 posts since Oct 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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.

Question Answered as of 5 Months Ago by G_Waddell
Member Avatar
G_Waddell
Practically a Posting Shark
821 posts since Nov 2009
Reputation Points: 131 [?]
Q&As Helped to Solve: 137 [?]
Skill Endorsements: 13 [?]
 
0
 

Glad I could help - I think...

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article