4 Replies - 682 Views - Last Post: 14 February 2009 - 12:45 PM Rate Topic: -----

#1 Kkarinisme  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 07-February 09

XML and Databases

Post icon  Posted 13 February 2009 - 04:33 PM

I used dbase relational databases for many years. Xml tables are certainly a type of database but ....

When I read any book on Xml files, sql databases seem to be constantly interjected into the discussions.

So, my questions:

I am creating a project in C# using an xml file. Do I need to convert this file to an sql database to easily work with the controls like list boxes and tables. Or, do xml files that have an associated transformation file act as stand alone databases and I just haven't figured out how to access the data yet?

My reason for asking this is that I was about to give up using the xml file and begin learning sql databases but thought maybe I should ask first.

If you can decipher my problem :wub: , thx for any help you can give.

Karin

This post has been edited by Kkarinisme: 13 February 2009 - 04:36 PM


Is This A Good Question/Topic? 0
  • +

Replies To: XML and Databases

#2 pr4y  Icon User is offline

  • Location: 127.0.0.1
  • member icon

Reputation: 35
  • View blog
  • Posts: 621
  • Joined: 19-September 08

Re: XML and Databases

Posted 13 February 2009 - 04:36 PM

Depending on the data being used in the XML file... I'd 99% of the time use an SQL database as opposed to XML. There are those times when XML comes in handy for quick projects that just need a few definitions of certain controls... but if the data is in any way sensitive, I use MySQL.

Was that the answer you were looking for? I hope I was helpful!
Was This Post Helpful? 0
  • +
  • -

#3 Kkarinisme  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 07-February 09

Re: XML and Databases

Posted 14 February 2009 - 08:12 AM

View Postpr4y, on 13 Feb, 2009 - 03:36 PM, said:

Depending on the data being used in the XML file... I'd 99% of the time use an SQL database as opposed to XML. There are those times when XML comes in handy for quick projects that just need a few definitions of certain controls... but if the data is in any way sensitive, I use MySQL.

Was that the answer you were looking for? I hope I was helpful!



Thx. Guess I'd better dive into SQL -- Karin
Was This Post Helpful? 0
  • +
  • -

#4 Hary  Icon User is offline

  • D.I.C Regular

Reputation: 44
  • View blog
  • Posts: 427
  • Joined: 23-September 08

Re: XML and Databases

Posted 14 February 2009 - 11:19 AM

Just a rule of thumb:
Storing data on a system: SQL Database
Exchanging data between different systems: XML
Was This Post Helpful? 0
  • +
  • -

#5 Kkarinisme  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 07-February 09

Re: XML and Databases

Posted 14 February 2009 - 12:45 PM

View PostHary, on 14 Feb, 2009 - 10:19 AM, said:

Just a rule of thumb:
Storing data on a system: SQL Database
Exchanging data between different systems: XML


Thx Hary
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1