Added new datatable/dataadapter to dataset but not accessible when I try to bind

BrownFingers

Member
Joined
Nov 21, 2008
Messages
15
Programming Experience
Beginner
Winforms newbie here.

I have added a new datatable and dataadapter to an existing dataset. However when I try and bind a control do my new datatable, it does not appear to be visible in the list of available datatables for that dataset. I can see all the other datatables on the dataset.

I am trying to bind a list to a combo box. I click on datasources, other datasources, project datasources, mydataset. I see all other datatables except the new one I added.

If I open up the dataset to confirm that I have actually added my new dataset, I can see it.

Any ideas?
 
Yes I tried building the project.

One thing I noticed about this dataset.

I have 2 DataSets CustomerDataset and SearchDataSet. SearchDataset is the one that is giving me the problem.

In Solution explorer it looks like this ( i.e. the .designer.vb file appears linked to the .vb file )

VB.NET:
SearchDataSet
>SearchDataSet.vb
    ->SearchDataSet.Designer.Vb
>SearchDataSet.xsc
>SearchDataSet.xss

where as my CustomerDataSet which I have no problem with appears in solution explorer like below ( i.e. all files on same level )
VB.NET:
CustomerDataSet
>CustomerDataSet.Designer.Vb
>CustomerDataSet.vb
>CustomerDataSet.xsc
>CustomerDataSet.xss
Not sure if that gives any clues ...
 
That does seem a bit odd. In situations like this I tend to try dragging the offending item to a new project in the Solution Explorer, deleting the original, then dragging it back. This causes the IDE to regenerate some files that may been corrupted. It's not a guaranteed fix but it has often worked for me in the past. Just make sure you back up your solution first.
 
I created a new dataset and copied everything on my SearchDataset ( the one I had problems with ) to the new dataset. The structure in Solution Explorer looked fine on the new dataset so I deleted my SearchDataset. I then attemped to rename my new dataset to SearchDataSet and I got the attached message.
 

Attachments

  • refactor.JPG
    refactor.JPG
    19.4 KB · Views: 28

Latest posts

Back
Top