Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio Express Editions >> Visual Basic 2005 Express Edition

VB Express 2005 Dataset Problems

Hey, All!

I've been trying to do a project now for sometime in VB Express 2005 that relies heavily on a SQL Server database and keep running into problems with my dataset.

I'll be running along fine and, all of a sudden, my dataset will disappear from my project. The database is still there in the Database Explorer pane, with all created tables and diagrams, etc. But, my dataset has completely disappeared from the project and, therefore, I am unable to load my forms into the Designer windows.

I have restarted VB and, sometimes, the dataset returns. However, this time, the dataset did not return with the project when I started up VB. The weird part is that my forms loaded into the Designer windows without errors. So, I added the dataset again and now have LOEDataSet and LOEDataSet1, which are exactly the same. How do I remove LOEDataSet1 from my project, as it is causing 102 compiler errors due to multiple definitions of the same procedures? This is really starting to get frustrating.

I've been programming in VB since VB 3.0 and always had to hand-code my database access and thought that having the IDE do all of the "hard work" would be a nice thing, but I'm really considering moving back to VB 6.0 and doing it all by hand again.

Any help is greatly appreciated. Thanks in advance.

Cheers,

Sean Carrick

[1384 byte] By [sean.carrick] at [2007-12-22]
«« DSN Creation
»» Moving objects on-screen after RotateTransform?
# 1

Hey sean,

I'm not sure why your dataset is dissappearing.....I also come from the VB3 and C(flat) days where everything had to be done manually...Although the IDE automation is nice...because of some of these quirks that you mention, I still find it better to manually code things instead of relying on the IDE to do what it thinks you want

DMan1 at 2007-8-30 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...
# 2
Actually, it's not the database that's disappearing, just the connection to it.

I've been playing with trying to get this project going, have created

the database in its entirety and started designing the forms about 4

times now. It is just getting very frustrating to have to keep

reinventing the wheel. I've gotten errors that say the database

file is corrupted, so I've deleted the file and recreated the database

(using my print of the relationships diagram, so I don't have to think

too hard). The database usually returns when I reopen the

project, but it's the dataset connection that doesn't. Normally,

when this happens, I receive all kinds of errors when I try to open a

form in the designer and the designer does not display the form.

This time, my connection had disappeared, but the forms opened fine in

the designer. So, I added the connection to the database again,

and now have the 102 errors mentioned in my original post. I have

LOEDataset and LOEDataset1 and cannot figure out how to delete the

redundant dataset.

Sean

sean.carrick at 2007-8-30 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...
Visual Studio Express Editions
Visual Basic 2005 Express Edition

Visual Studio Express Editions Hot Topic

Visual Studio Express Editions New Topic

Visual Studio Express Editions

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified