Post
Ask Question

How To Dataset Object Deal With XML File

XML Methods of DataSet Object,

  1. ReadXml :Read the Xml file and load to dataset object.

    eg: objDataset.ReadXml("path of xml file");

  2. GetXML :DataSet object (DataTable) Value Generate into Xml Formate and return into string formate.

    eg: string strXml = objeDataset.GetXml()

  3. Writexml: DataSet object (DataTable) Value Generate into Xml Formate and write to Xmlfile in your disk.

    eg. objDataSet.WriteXml("path where you want to write xmlfile");

    /*Create xml file into your solution*/

    Employee.xml
    1. <?xml version="1.0" encoding="utf-8" ?>  
    2. <Employees>  
    3.     <Employee>  
    4.         <EmpID>101</EmpID>  
    5.         <Name>umesh</Name>  
    6.         <Salary>10400</Salary>  
    7.     </Employee>  
    8.     <Employee>  
    9.         <EmpID>102</EmpID>  
    10.         <Name>Ashish</Name>  
    11.         <Salary>24000</Salary>  
    12.     </Employee>  
    13.     <Employee>  
    14.         <EmpID>103</EmpID>  
    15.         <Name>Sanket</Name>  
    16.         <Salary>35000</Salary>  
    17.     </Employee>  
    18.     <Employee>  
    19.         <EmpID>104</EmpID>  
    20.         <Name>Swapnil</Name>  
    21.         <Salary>20000</Salary>  
    22.     </Employee>  
    23. </Employees>  

ReadXml Example

  1. using System;  
  2. using System.Data;  
  3. namespace DataSetXMLDemo   
  4. {  
  5.     class ReadXMLClass   
  6.     {  
  7.         /*ReadXML: Reads XML document into the DataSet.*/  
  8.         public static void Main() {  
  9.             DataSet objdataSet = new DataSet();  
  10.             objdataSet.ReadXml(@ "D:\Practice\DataSetXMLDemo\DataSetXMLDemo\Employee.xml");  
  11.             foreach(DataRow dataRow in objdataSet.Tables[0].Rows) {  
  12.                 Console.WriteLine("{0}\t {1} \t{2}", dataRow[0], dataRow[1], dataRow[2]);  
  13.             }  
  14.             Console.ReadKey();  
  15.         }  
  16.     }  
  17. }  
GetXml Example
  1. using System;  
  2. using System.Data;  
  3. namespace DataSetXMLDemo   
  4. {  
  5.     // GetXML : It will Return XmlFile Containt in string Formate  
  6.     class GetXMLClass {  
  7.         public static void Main() {  
  8.             DataSet dataSet = new DataSet();  
  9.             //first we reading xml file into dataset  
  10.             dataSet.ReadXml(@ "D:\Practice\DataSetXMLDemo\DataSetXMLDemo\Employee.xml");  
  11.             //Now we Getting xml file containt in string formate  
  12.             string xmlFileContaint = dataSet.GetXml();  
  13.             Console.WriteLine(xmlFileContaint);  
  14.             Console.ReadKey();  
  15.         }  
  16.     }  
  17. }  
WriteXml Example

 

  1. using System;  
  2. using System.Data;  
  3. namespace DataSetXMLDemo {  
  4.     class WriteXMLClass {  
  5.         /* 
  6.         WriteXML : This writes XML data to disk. 
  7.         That means dynamicaly we are creating xml file with data of dataset 
  8.         */  
  9.         public static void Main() {  
  10.             DataSet dataset = new DataSet();  
  11.             dataset = CreateDynamicDataSet();  
  12.             dataset.WriteXml(@ "D:\Practice\DataSetXMLDemo\DataSetXMLDemo\Students.xml");  
  13.             foreach(DataRow item in dataset.Tables[0].Rows) {  
  14.                 Console.WriteLine("{0} \t{1} \t\t{2}", item[0], item[1], item[2]);  
  15.             }  
  16.             dataset.AcceptChanges();  
  17.             Console.ReadKey();  
  18.         }  
  19.         public static DataSet CreateDynamicDataSet() {  
  20.             //Dataset is Collection of DataTable  
  21.             DataSet dataset = new DataSet();  
  22.             dataset.Namespace = "OOPS.ADO.NET";  
  23.             //DataTable is Collection of DataRow  
  24.             DataTable dataTable = new DataTable("Student");  
  25.             DataColumn dataColumn = new DataColumn();  
  26.             dataTable.Columns.Add("StudentID");  
  27.             dataTable.Columns.Add("Name");  
  28.             dataTable.Columns.Add("Percent");  
  29.             DataRow dataRow = dataTable.NewRow();  
  30.             dataRow[0] = "Stud101";  
  31.             dataRow[1] = "Pooja";  
  32.             dataRow[2] = 60;  
  33.             dataTable.Rows.Add(dataRow);  
  34.             DataRow dataRow1 = dataTable.NewRow();  
  35.             dataRow1[0] = "Stud102";  
  36.             dataRow1[1] = "Pronoti";  
  37.             dataRow1[2] = 70;  
  38.             dataTable.Rows.Add(dataRow1);  
  39.             DataRow dataRow2 = dataTable.NewRow();  
  40.             dataRow2[0] = "Stud103";  
  41.             dataRow2[1] = "Pinki";  
  42.             dataRow2[2] = 35;  
  43.             dataTable.Rows.Add(dataRow2);  
  44.             dataset.Tables.Add(dataTable);  
  45.             return dataset;  
  46.         }  
  47.     }  
  48. }  
  49. /*I hope this is help full..*/