Failed To Add Table Adapter in XSD

Question

I am running with an weird issue, I have an existing SXD project in my solution. I am just trying to add a new table adapter to it but after I am done with all the steps (specifying connection string, SQL query etc); hit finish it fails with error

Failed To Add Table Adapter -- Unable to find connection string "testcon" for object settings.

But when I check the setting.settings file OR App.config I can see the testcon connection string is present right there and it's correct. Then what's wrong?

Tried searching in MSDN forums (AND) Google but no luck.

Have anyone faced this issue before? Any idea how can I fix this? IS this a VS Bug?

NOTE: I am working in VS2010 SP1.

Thanks for your help.

Answer 1

Exactly not sure whether it's a VS bug or not but I resolved it.

Somehow, felt that the connection string under "Settings.Setting" file have been messed (OR) corrupted. So ended up removing all the connection string and recreating them afresh. It's did worked perfectly.

Hope this helps to someone.

Thanks.