Where XML is helpful..
1.There is a need to store set of hardcoded records(will change once after so many days) and should be retrieved in multiple pages.
for ex::: if you have a prodcuts dropdownlist which is used in several screens.Please use XML in that case instead of SQL SERVER in order to avoid database hits.
2.XML is very helpful in keeping confugaration details like path of the folder in webserver,Role settings .
3.XML is very helpful in interchanging DATA between two different plotforms.for ex say there are two applications need to share data.one is built in .net and another one is in java.
Advantages of XML..
XMl is very easy to read and understand with user defined tag(in opposite to HTML,there are predefined tags)
xml is very flexible in such a way that most of the languages can easily use xml in applications.
Please read below link for more information in dotnetfunda::
which is best one sql server or xml because most of the project created in xml?
sql server is best over xml if you are looking to store records and would like to perform operations on them,reasons are very simple there are no indexing future in xml this leads to performance issue and also with xml you cant update the records so easily.
Xml was originally designed with interoperability in mind, not performance so go with sql server for storing more records.
XMl is not a database but instead it is a data interchange format.
Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator