Solved

How to export existing data fields/dataset to an xml file

Posted on 2011-09-13
5
218 Views
Last Modified: 2012-05-12
This report was made with vb.net 2005. I have an existing crystal report where its database fields were created from a dataset made in my vb project. Someone deleted and remove the dataset from the vb project. I know there's a way to export the database fields to an xml file or something where you can then reimport, add new columns and update it in the report. I don't remember how to do this. Can someone refresh my memory?
0
Comment
Question by:glenn_r
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36533038
I don't know if this example of feeding the report from the application has enough code or not ti help

http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
0
 
LVL 40
ID: 36533740
No backup??? :-)

Exporting the structure of tables to XML is a feature that is implemented in different ways depending on each database.

In Access for example, where I had to do that job a few years ago, you can right-click on a table, select Export, xml file, and you will be asked if you want to save the data or only the schema. Since you are talking about a DataSet, there were probably many linked tables. In such a case, you create a query with the tables and their link and export the query as explained for the table.

In other database, it's done through a SQL command.

So consult your database documentation or tell us the database you are using. Somebody might be able to help.

In Visual Studio, when you open an xml document that contains a schema, the schema is exposed in a graphical representation that shows the tables and their links. You can change that schema with right clicks. Note that although xml is a standard, some schemas might not be recognized properly when you import them in Visual Studio.

Your greatest problem will be to recreate a DataSet that is exactly as the one that was there. Unless it was documented, it can be a pain.

I hope this helps.

Good luck.
0
 

Accepted Solution

by:
glenn_r earned 0 total points
ID: 36535907
Let me rephrase the question. I have a vb.ne project that contains a dataset with one table defined. I created a crystal report and then right click database fields and database expert from the context menu. Then click project data and finall ado.net datasets to add it to the project. Basically it displays the table name and the fields in the crystal field explorer. From here I drag the fields to the report designer to site them. I have a customer where they've delete the vb.net dataset. I need to add a few fields to the table and right now the only way to do that is to recreate the vb.net dataset, add the fields and then use the database fields set datasource command to update the crystal table and fields. Allot of work. I've done this in the past but forgot how. You can export the crystal table and fields and import it back into the project. Hope this clarifies my question.
0
 

Author Closing Comment

by:glenn_r
ID: 37736771
no solution
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question