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);
}
}
|