Open the XML file and read into a DataSet : DataSet : Database C# Source Code

Open the XML file and read into a DataSet

    




using System;
using System.IO;
using System.Data;

public class MainClass {
    static void Main(string[] args) {
        if (args.Length != 1)
            return;

        FileStream fs = new FileStream(args[0], FileMode.Open);
        DataSet ds = new DataSet();
        ds.ReadXml(fs);

        // Use a DataTable to display the members.
        DataTable mt = ds.Tables["member"];
        for (int row = 0; row < mt.Rows.Count; row++) {
            for (int col = 0; col < mt.Columns.Count - 1; col++) {
                Console.WriteLine("{0,-10}{1}",
                    mt.Columns[col].Caption,
                    mt.Rows[row][col].ToString().Trim());
            }
            Console.WriteLine();
        }
        fs.Close();
    }
}

           
       
    
   
  
   

Related in same category :
• Print DataSet out
• Finding Data
• How to perform a SELECT statement and store the returned rows in a DataSet object
• Populate a DataSet object using a SELECT statement
• Populate a DataSet object with multiple DataTable objects
• Populate a DataSet with multiple DataTable objects using multiple SELECT statements
• Use the Merge() method
• DataSet Delete
• For each row in DataSet, reference the column data by column name
• DataSet Read
• ReadXml
• Populate a DataSet object with a range of rows from a SELECT statement
• Using Datasets
• Using Multi Tabled Datasets
• Read data from DataSet