dataset disappears from designer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a windows app and I use the data adapter wizard to generate a SQL query. Once the data adapter is created, I generate a dataset from it and my dataset appears in the designer. Then I create another data adapter from the wizard and when that is complete I try to generate the existing dataset from the new data adapter. My dataset disappears from the desinger. If a generate my dataset from data adapter 1 again then a new instance of the dataset is created, but as soon as I try to add data from another data adapter to it disappears again. It appears that the windows generated code to intialize the dataset stays intact, but I get build errors if I try to reference it in my code

I've found many other postings about objects disappearing from the designer and I know that there are hotfixes available. Does anyone know if I really have to pay $245 and go through the phone support @ Microsoft to obtain the one I need? This has to be a bug because it happens consistantly in a new project when nothing else is happening. Thanks!
 
Hi Suzi,

Before you spent $245 you can try to create a new project and only do that
what you decribe in your message, with me sometimes old datasets stays in
this situation the designercode and gave problems as you described.

Cor
 
Hi Suzi,

I tried it on a complete new project and had no problem check what I did if
that is the same?

I created an SQLdataadapter using the wizard with everything on it for one
table
I generated a dataset
I created another SQL dataadapter using the wizard from another database
again for one table
I generated the same dataset from that adapter.
When I did look in the dataset I had two tables in it from different
databases.

What version are you using by the way?

Cor
 
Hi Suzie,

I am using also VS2003 and it is in my opinion very less buggier than 2002.
(With Adonet I did not even even one bug)

The only thing you can try maybe is taking another database and get from
there some dummy tables. But this is only guessing because this sounds
really weird.

Cor
 
Try not clicking on the data adapter itself to hit generate dataset, click
on the component tray itself, then it should show the results of multiple
data adatpers, see if that works for you.

-CJ

Suzi said:
Yes, that is exactly what I am doing. I am using 2003. I think this
Click to expand...
started to happen when I had to reinstall VS.Net 2003 because my CR.net
keycode was set wrong and CR told me the only way to reset it was to
reinstall. Are you using 2003? I have heard rumors that 2003 is buggier
than 2002 as far as ADO.net goes, do you agree?
 
Back
Top