Solved

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

Posted on 2011-09-13
5
207 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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…
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

773 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