• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 603
  • Last Modified:

Vb.net dataset designer

In Visual Studio 2005 (VB.Net), how do I take a graphically-designed dataset and change it into code?
0
k3n51mm
Asked:
k3n51mm
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
Fernando SotoRetiredCommented:
There should have been a class already create after going through the graphical designer wizard. Look in the Solution Explorer.
0
 
Bob LearnedCommented:
Look for the .designer file with the 'Show all files' option selected in the Solution Explorer.

Bob
0
 
k3n51mmAuthor Commented:
Right, it's there. I can see the designer in Solution Explorer.

But I need to take the dataset, table adapters, relationships, and everything having to do with this designed data structure and change it into coded entities instead of relying on the designer.

The code in the designer is a classic Microsoft clusterf*ck. Must I decipher all that junk, really?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Fernando SotoRetiredCommented:
The class they created gives you a Strongly typed data object and Microsoft does not recommend changing it without the use of there designer.

The other option is to write the code yourself and get what you need the way you need it.
0
 
k3n51mmAuthor Commented:
Right Fernando, that's it. But since it was already created in a designer by a consultant we hired (no one told him not to use the graphical designer), I was hoping for a few hints about how to be able to create the same dataset as was created in the graphical designer, but in code. Then I could reuse the other processing code already created to work with the dataset. It has to do with importing and exporting the data as an XML file to and from the application.
0
 
Fernando SotoRetiredCommented:
I do not know if there is a tool out there that would convert a strongly type data object to one created by hand. I am not saying that there is none but I have never seen one or come across one.
0
 
Bob LearnedCommented:
There isn't a tool, and probably because nobody has had a need (mother of invention and all that).  You would have to take the code from the .designer file, and strip out all the things that you don't need, and leave what you do--good luck!!

Bob
0
 
garyLynn7Commented:
Hi k3n51mm,
you may have already condidered these options, but;
if you are converting datasets to object classes,  why not do it from the database itself?  There are several good tools out there that can generate great dal and bo.

I've been using a 3rd party generator that actually modeled a database with 3 related tables into class files and field properties, and created the crud as well.

I've researched at least 6 of these generators, some have great value and provide sound source code; while some will obfuscate most of the code to dll's, and charge substantial amounts of money.

The question is how much goofing around one is willing to put up with while trying to make the conversions.

Two tools I've found to be very usefull for what you are describing are:

http://www.apexsql.com/default.asp

http://www.codeauthor.org/index.html

And by far my favorite set of tools come from Developer Express, specifically the component called XPO.
If you haven't look at XPO, you may find it is just what you need for custom data entities:
http://www.devexpress.com/Help/?document=XPO

It sounds like your undertaking will be fairly pain-staking, so any help with the drudgery might be useful!

Sorry this isn't much help, but maybe you can gain from it somehow!

Good luck!

Gary
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now