Changing Data Source of connectionstring to a server that is not on current computer

[Twilight78]

Hi people,

I have a bug which originated when I changed the data source of the connectionstring (in the properties of a tableadapter, dataset design mode) to a server which is not accessible on the computer I am working on, i changed it from "(local)" to the name of the server for the database. The Error is: "The Roostertableadapter is not a member of rooster.deelnemersroosterdatasettableadapters.Tableadaptermanager". Is there someone who knows how to get rid of this bug? changing the data source back to "local" does not help...

[dunfiddlin]

to a server which is not accessible on the computer I am working on

Er ... do I need to point out the obvious here or did you mean to say something else?

[Twilight78]

Yesss, what's the obvious? how do i get rid of the bug? changing the data source back to a server wich IS accessible does not help, the error will still be there?

[dunfiddlin]

If you changed it back to exactly the same set-up as the working version then it would be working still. Therefore I can only assume that despite the fact that you were about to do something incomprehensible you failed to make a record of this rather important information. Now you're asking us by some strange psychic process in which we are denied any pertinent details whatsoever to identify the problem in a code we have never seen and can only guess at.

[Twilight78]

'TableAdapterManager
'
Me.TableAdapterManager.BackupDataSetBeforeUpdate = False
Me.TableAdapterManager.RoosterTableAdapter = Me.RoosterTableAdapter
Me.TableAdapterManager.UpdateOrder = Rooster.DeelnemersRoosterDataSetTableAdapters.TableAdapterManager.UpdateOrderOption.InsertUpdateDele te

This is the error, it's in the file form1.designer.vb, it says that roostertableadapter is not a member of Rooster.DeelnemersRoosterDataSetTableAdapters.TableAdapterManager.

what do you need to know more about my project?

[kevininstructor]

In regards to

Me.TableAdapterManager.RoosterTableAdapter = Me.RoosterTableAdapter

Seems to me the obvious reason for this to happen is either you removed the adapter from the form via selecting it and deleting or completely re-did the database via the data wizard. Look at the form (not code) , can you see RoosterTableAdapter? If it is not there it is obvious you need to generate it and if not create it again.

[Twilight78]

I understand what you mean, but the designer for my form is not accessible, it is not working. So I cannot see if the table adapter is there, in the designer.

[kevininstructor]

I understand what you mean, but the designer for my form is not accessible, it is not working. So I cannot see if the table adapter is there, in the designer.

For safety sake backup your project before continuing.
Select the project in Solution Explorer in the IDE, from the IDE menu select project then show all. The form in solution explorer will have a plus symbol, click it, open the form designer.

Examine each line, one or more will have errors indicated by squiggly lines. With care remove only the offending lines, save the file.
Next rebuild the project.
Unload the project.
Open the form as you normally would open the form.
If it opens okay then proceed as you see fit to recover.
If it does not open properly re-open the form designer file and look for more issues as per above. Repeat until all issues are resolved.
If you repeat and cannot resolve discard the form and start over. I have gone thru these steps myself and have never had to discard a form but it all depends on how well you can traverse the designer file and scrap out offending code.

[Twilight78]

Thanks for your replie, I am afraid i have to start all over....

[kevininstructor]

Thanks for your replie, I am afraid i have to start all over....

You should not start over but instead open the designer file as I have indicated. The only reason you would not be able to open the file is if it was completely missing. This file is simply a text file with information for VS to display your form.