How to resolve "Failed to add adapter"?

Question

0.00/5 (No votes)

See more:

VS2012

I've got a dataset and several tables in it, using VB.Net(VS 2012). Everything is working fine i can add or delete any table from the dataset whenever I want to except for one particular table. Whenever I am adding it, It is giving me the following error.

"Failed to add adapter"
"An item with the same key has already been added"

Please help.

Posted 29-Dec-14 19:51pm

Aziz Sheikh

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shahan Ayyub · Answer 1 · 2014-12-29T20:19:00

Solution 1

You should check first if the table with the same key already exists in dataset or not.

If (ds.Tables.Contains(tableName)) Then

   ' Here you can remove first and re-add, if there are some updates in the table you are going to add.
   ' On the other hand no need to define ELSE case as you can't re-add them if already exists  
End If

Posted 29-Dec-14 20:19pm

Shahan Ayyub

Comments

Aziz Sheikh 31-Dec-14 3:20am

Thanks for the reply. I tried your method but there is no table with the name I am having trouble with. And besides this I am using the designer to add the tableadapter.

Shahan Ayyub 31-Dec-14 6:37am

Can you please show us how do you do it then in designer ?

Aziz Sheikh 1-Jan-15 4:13am

Well I hope i could explain it. Anyways, I go in the designer right click and add table adapter and then I select the table from the database. After that when i click finish i get the said error.