Skip to main content

Posts

Showing posts with the label XML

A simple how to export from TableAdapter to XML file

I 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: In Visual Studio I created a new project I added Connected to Access database using the Database Explorer, this created a link in the App_Data folder Then on the default page I allowed the user to place the file name, I then added a new DataSet, created a new TableAdapter, put the query I needed in there and 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 =...

How to fix you iTunes library when moving the music files

Computer Crashed :( Recently my old computer that I was running iTunes on gave up the ghost. IT was running RAMBUS memory and the memory decided its day had come. So I could not get into my old machine where all my music is. Since there is some legal issue around downloading music from iTunes in South Africa, I have relied on ripping CD to the iTunes library. Thinking I was clever that I could save time doing this all again (I have over 500 CD's, a collection started in 1985). I decided that since the hard drive in my old machine was still okay I would get an external chassis and lace the drive in there. Loaded new goodies After the experience of the crashed drive I also bought a new external drive so that my music library would be portable. I copied the music folder to a new folder called music in the root of the new external drive. Then I loaded iTunes onto the new machine. I set the iTunes folder to the new folder on the new external drive and the library imported fine. Fine ...