using System; using System.Data; using System.Data.SqlClient; using System.Xml; class UsingXmlDocument { public static void Main() { SqlConnection mySqlConnection = new SqlConnection( "server=localhost;database=Northwind;uid=sa;pwd=sa" ); SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.CommandText = "SELECT TOP 2 CustomerID, CompanyName, Country " + "FROM Customers " + "ORDER BY CustomerID"; SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); mySqlDataAdapter.SelectCommand = mySqlCommand; DataSet myDataSet = new DataSet(); mySqlConnection.Open(); mySqlDataAdapter.Fill(myDataSet, "Customers"); mySqlConnection.Close(); XmlDocument myXmlDocument = new XmlDocument(); myXmlDocument.LoadXml(myDataSet.GetXml()); Console.WriteLine("Contents of myXmlDocument:"); myXmlDocument.Save(Console.Out); foreach (XmlNode myXmlNode in myXmlDocument.SelectNodes("/NewDataSet/Customers")) { Console.WriteLine("CustomerID = " + myXmlNode.ChildNodes[0].InnerText); Console.WriteLine("CompanyName = " + myXmlNode.ChildNodes[1].InnerText); Console.WriteLine("Country = " + myXmlNode.ChildNodes[2].InnerText); } XmlNode myXmlNode2 = myXmlDocument.SelectSingleNode("/NewDataSet/Customers[CustomerID=" ANATR"]"); Console.WriteLine("CustomerID = " + myXmlNode2.ChildNodes[0].InnerText); Console.WriteLine("CompanyName = " + myXmlNode2.ChildNodes[1].InnerText); Console.WriteLine("Country = " + myXmlNode2.ChildNodes[2].InnerText); } }