Skip to main content

A simple how to export from TableAdapter to XML file

The XML Schema CompanionI recently wanted to import data from an existing system that is written in Access. The system allows for XML imports. Since I needed to do some background programming on the system, I opted to rather to it programmatically than use the standard export, since I would have to do it a few times, and also manipulate the data once it was imported and then exported.
I struggled to find information on how to do this, so eventually decided to figure it out myself and this is how I did it:
  1. In Visual Studio I created a new project
  2. I added Connected to Access database using the Database Explorer, this created a link in the App_Data folder
  3. Then on the default page I allowed the user to place the file name,
  4. I then added a new DataSet, created a new TableAdapter, put the query I needed in there and
  5. Then in my code I exported to XML

So the in Default.aspx It looks like this:

File to Export to:
<asp:TextBox ID="tbxCustomersToXML" runat="server" Width="375px" ToolTip="XML File Target" 
Text="C:\Users\username
\Documents\junk\Customers.XML" />
<asp:Button ID="btnCustomersToXML" runat="server" Text="Customers TBL to XML" onclick
="btnCustomersToXML_Click" />
<br />
<asp:Label ID ="lblStatus" runat="server" />
<br />


And the in Default.aspx.cs looks like this:


protected void btnCustomersToXML_Click(object sender, 
EventArgs e)
 {
  if (tbxCustomersToXML.Text != "")
     {
     try
       {
         CustomersTblTableAdapter dtaCompanys = new CustomersTblTableAdapter();
         // retrieve the data using GetData since this is where the correct Query is
         TrackerCompaniesDataSet.CustomersTblDataTable dtCompanys = dtaCompanys.GetData();
         System.IO.StreamWriter swXMLTarget = File.CreateText(tbxCustomersToXML.Text);

         dtCompanys.WriteXml(swXMLTarget, XmlWriteMode.WriteSchema);
         lblStatus.Text = "Extract status: Done!";
       }
       catch (Exception ex)
       {
         lblStatus.Text = "Extract status: The file could not be exported. The following error occurred: " + ex.Message;
       }
     }
   }

Hope that this helps someone, I may need to refer to it myself.

Comments

Popular posts from this blog

POST as form using C# to Pay Provider

The Remote Post Form class I have used the code for the jigar site and added my own goodies, so all credit to him. Sorry about the flast formating but is the only way I could get a neatish post using System; using System.Collections.Generic; using System.Web; using System.Security.Cryptography; /// <summary> /// Remotely handle and Post form from http://www.jigar.net/articles/viewhtmlcontent78.aspx%20 /// </summary> public class RemotePost { private System.Collections.Specialized.NameValueCollection Inputs = new System.Collections.Specialized.NameValueCollection(); public string Url; public string Method; public string FormName; public RemotePost(string pURL) { // // TODO: Add constructor logic here // Url = pURL; Method = "post"; FormName = "frmRemotePost"; }   public void Add(string name, string value) { Inputs.Add(name, value); } public void

Fixing winmail.dat problem - specifically in Quickbooks

For months we have had problems with attachments from Quickbooks. Having looked down many avenues I think we have found a fix or few: (See below for update) Here are a few websites that help out: Microsoft Outlook/Exchange MS-TNEF handling (aka "Winmail.dat", "Win.dat", or "Part 1.2" problem of unopenable email attachments) http://news.office-watch.com/t/n.aspx?a=716 KB958012 : When you use Outlook 2007 to send an e-mail message, the recipient of the message sees an attachment that is called Winmail.dat Essentially the summary is that there is a problem with Outlook trying to force Rich Text Format. so you need to turn that off. Mail users not receiving email in an Outlook derivative will have a problem. This format is called So: Go into Outlook On the "Tools" menu, click "Options", then click the "Mail Format" tab, and then the "Internet Format" button. Set "When sending Outlook Ri

Bitcoin / Cryptocurrency – what is it and how can I benefit

What is it I started investigating Bitcoin when it was worth just over $1000 a bitcoin. I was interested in what it was and how it worked. A lot of people are saying we missed the boat, but I believe that everyone should at least try put a little money in now, or at least use a faucet (see below) to make a little micro-currency. You can read a Wiki article about bitcoin and its history etc. But what you need to know is that it is a currency, that is independent of country. No one really knows who invented the concept of a cryptocurrency since the person who published the paper used a nom de plume. All new cryptocurrencies work more or less the same way as Bitcoin. So as I explain below I interchange these terms. Bitcoin is the original cryptocurrency. How Bitcoin works The currency releases a coin based on a mathematical formula. There will never be more than 21 million bitcoins (other cryptocurrencies do not work like this). Each bitcoin can have divided into one hundred mil