using System;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
public class DirectXML
{
private static string connectionString = "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI";
public static void Main()
{
string SQL = "SELECT CategoryID, CategoryName, Description FROM Categories FOR XML AUTO";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand com = new SqlCommand(SQL, con);
try
{
con.Open();
XmlReader reader = com.ExecuteXmlReader();
while (reader.Read())
{
Console.WriteLine(reader.Name);
if (reader.HasAttributes)
{
for (int i = 0; i < reader.AttributeCount; i++)
{
reader.MoveToAttribute(i);
Console.Write(reader.Name + ": " + reader.Value);
}
reader.MoveToElement();
}
}
reader.Close();
}
catch (Exception err)
{
Console.WriteLine(err.ToString());
}
finally
{
con.Close();
}
}
}
|